SAP NDBSMATG16 Table in S/4 HANA - Mapping Table: Material Number/GUID (RAW16)









NDBSMATG16 is a standard SAP Table which is used to store Mapping Table: Material Number/GUID (RAW16) data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the NDBSMATG16 table(ECC)

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Transparent table
View reference: SCMPRDNDBSMTG16
DDL Object: SCMPRD_NDBSMATG16
Database Table: MARA


NDBSMATG16 data in SAP S/4 Hana is actually from table MARA

So NDBSMATG16 ECC R/3 vs NDBSMATG16 SAP S/4 Hana... has it not been replaced? The answer is yes NDBSMATG16 has been replaced by MARA in SAP S/4 Hana systems...ok so why is it still there and contain data when you look via transaction codes like SE11/SE16 etc, and doesn't that add a level of complexity keeping both tables upto date....


Well actually no, although you can still see NDBSMATG16 as a table it is actually just a view of the new Hana table with all the same fields traditionally associated with NDBSMATG16. Behind the scenes it is a DDL object CDS view which selects the data from MARA and presents it as if the original table still exists. Clever really as this means all the old ABAP code that performs a select on this table will actually still work.. Yes you may want to rewrite it to take advantage of the new Hana table and all the in memory benefits but untill you do it will still work.


MARA used for fields of table NDBSMATG16

The data and therefore the actual field list comes from the ddl cds view and are mapped from the source hana table to match the legacy ECC SAP NDBSMATG16 Table. Below is the CDS code that builds this table view

NDBSMATG16 table structure field list

Also Below is the traditional view of NDBSMATG16 field list that makes up the SAP database table structure as you would see it within SE11, including highlighted key fields, description, data type and other technical details of each field

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) MANDT
MATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
GUIDGUID for Material (RAW16)MATGUID16RAW16(0) MATGUID16




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!