Model comparison of material inventory management between sap ECC and s4hana material

MATDOC The database contains Material Header information and line item data of material data . Mixed table ( for example MARC、MARD etc. ) There is still , But they only store master data information (Master Data). All inventory information displayed during the selection of these tables is dynamically calculated . When dynamically calculating inventory data , Use MATDOC_EXTRACT The purpose of the table is to accelerate Yes MATDOC Summary of table .

Be careful , stay S/4HANA in ,MARD The inventory values contained in these tables , It is already the result of dynamic calculation , That is, independent data information table MARC And other inventory related tables, such as NSDM_V_MARC Dynamic calculation results .

image MARD Such hybrid tables still exist , And still return inventory data . However , These numbers were created using the new data model CDS view View dynamically computed . This can be done from SE16 Transaction MARD in select Of SQL I see :

CDS View is a DDL( Data definition language )SQL Scripted ABAP Entity . In this context , They are used to aggregate data from different sources into a single root view .

Use MB80 Business ( from SAP Note 2542130 Provide ) or SAP ABAP Development Tool, You can check the direction ABAP Catalog in SE11 Of the view created by the transaction code DDL file . for example ,MARD Of CDS The view consists of the following elements :

• Data definition file :NSDM_DDL_MARD
• Dictionary view :NSDM_V_MARD
• A database entity ( Exists at the database level , Only by DDL quote ):NSDM_E_MARD

We use it ABAP Development Tool stay S/4HANA System , open MARD, Can see a @AbapCatalog.replacementObject : 'nsdm_e_mard' annotation ：

CDS Views can be defined as alternative objects to database tables (replacement, Sometimes it is also called proxy object ), It can also be defined as ABAP Dictionary Classic database view in . under these circumstances ,ABAP SQL When reading a database table , The read operation automatically accesses the replacement object defined by the annotation .

nsdm_e_mard Source code ：