03-07-2020 3:24 PM
When i retrieve MARD table data using direct select query through dbacockpit or HANA studio LABST(Unrestricted) always shows zero.what could be the reason.If i retrieve same through .Net select query same issue.Kindly help with a solution for the above.
03-11-2020 11:50 AM
LABST from the SQL consol in Eclipse show result. Is it how you check it with Hana studio ?
03-11-2020 11:52 AM
03-11-2020 1:57 PM
Below is my SQL and MB51 view with Query Output from HANA for same Material.
Select MATNR,WERKS,LGORT,LABST from sapabap1.MARD WHERE WERKS='1036' AND MATNR IN('ST801021', 'TR336665', 'TR662030', 'TR662031', 'TR662034', 'UT180192' )
Thanks.
03-11-2020 2:30 PM
Hi
It is very strange,
Can you please query the same directly in SE16 in SAP table MARD. Would like to see how it is.
03-11-2020 2:41 PM
Hi,
Output query through Se16.Is it anything related to Authorization.
03-12-2020 8:38 PM
Hi
How many clients are there in the system.
Please do one thing.
Add MANDT in the where clause of the Query.
Select MATNR,WERKS,LGORT,LABST from sapabap1.MARD
WHERE WERKS='1036' AND
MATNR IN('ST801021', 'TR336665', 'TR662030', 'TR662031', 'TR662034', 'UT180192' ) AND MANDT = '999'
Regards,
Venkat
03-14-2020 1:50 PM
03-14-2020 2:31 PM
03-14-2020 2:34 PM
Hi
It looks like the user sapabap1 having column level security on LABST column.
try execute the query at admin level user or grant all privileges to sababap1 and try again
03-16-2020 3:17 PM
11-17-2020 12:14 AM
In S/4HANA many tables are replaced by compatibility views to improve performance. So, if you try to execute a table directly using SQL it won't return the right values. Make sure to include the redirected Proxy object/compatibility views.
Wrong - SELECT * FROM XYZ.MARD WHERE LGORT = 'XXX' AND MATNR = 'XXX';
Right- Select * FROM
/* Redirected table: MARD */ "NSDM_V_MARD" "MARD"
WHERE
"MANDT" = ' ' AND "LGORT" = 'XXX' AND "MATNR" = 'XXX'.
TIP: You can pull the right SQL statement by executing Se16n with SQL Trace.
12-13-2020 1:15 PM
Hi , You need just to use this view NSDM_V_MARD to check the real quantities
so your SQL Query will look like this :
select LABST from "SAPABAP1"."NSDM_V_MARD"
where "MATNR" = 'material'
and you can also make join it with MARD table
08-31-2022 11:46 AM
Thank you Mr. Mustapha. Your answer save my life. Real quantities are correct from NSDM_V_MARD.
03-02-2023 9:51 AM
Please check this SAP Note : 2595627 - Accessing table from SE16/SE16N shows different results to SAP HANA database.
From HANA database approaches the table is empty, or shows different value than expectation.
In S/4HANA many tables are replaced by compatibility views with same name.