Miss matching data between CDS results and SAP table data

[rakeshmb_sap2]

Hi , I'm trying to get data from MSLB table through CDS view but the result looks different , pls check the attachments and help me to resolve the issue.

Thank you

[Venkatesh_Pelli · Accepted solution]

Hi Rakesh,

In S/4 HANA the actual data for this table will be present in MATDOC and proxy object.

Please try to use NSMD_E_MSLB view instead of MSLB in CDS views for reading proper data.

[rakesh_94 · Accepted solution]

Thank you for your response but the NSMD_E_MSLB view is does not exist

is any other way to achieve it?.

[Venkatesh_Pelli]

Please try view NSDM_DDL_MSLB

[rakesh_94]

Hi Venkateshwarlu, Thanks you so much it got resolved my issue and how do we explore these kind of tables and their view names? Could you please give me some Inputs so it will help me lot because similar issue I am facing with MSEG table,

the data exists in the table when try to get the data from CDS view it shows no data on some materials.

[rakesh_94]

The table has data

[Venkatesh_Pelli]

when you open table in SE16N you will see any proxy object. It means they are replaced mostly and actual CDS view linked to proxy object which will have proper data accessing vai CDS views or Hana Views.

[Venkatesh_Pelli]

Can you please mark the answer if issue is resolved

[Venkatesh_Pelli]

Please refer SAP Note 2206980 for standard documentation on this tables.

https://launchpad.support.sap.com/#/notes/2206980

[rakesh_94]

Nothing just i executed the view NSDM_DDL_MSLB and got expectd output now i am trying to use that in my cds view.