MARD-LABST shows zero

[former_member665106]

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.

[FredericGirod]

LABST from the SQL consol in Eclipse show result. Is it how you check it with Hana studio ?

[venkateswaran_k]

Please paste your SQL

[former_member665106]

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.

[venkateswaran_k]

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.

[former_member665106]

Hi,

Output query through Se16.Is it anything related to Authorization.

[venkateswaran_k]

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

[former_member665106]

Hi,

Still same issue.Only 999 client.

[venkateswaran_k]

Please check if any column level security is there.

[venkateswaran_k]

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

[venkateswaran_k]

Hi

Please update if you find any solution

[former_member684548]

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.

[former_member606509]

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

[alejandroge]

Thank you Mr. Mustapha. Your answer save my life. Real quantities are correct from NSDM_V_MARD.

[former_member844819]

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.