The SAP ERP 6.0 stock inventory management data model consists of the two document tables MKPF for document header information and MSEG for document item data. Additionally there were aggregated actual stock quantity data stored in several tables. Some of these tables do also store material master data attributes like the tables MARC, MARD and MCHB. Such tables with material master data attributes as well as actual stock quantities will be named as hybrid tables in the following. In contrast there are also tables like MSSA containing only aggregated actual stock quantities for sales order stock. Such tables will be called in the following as replaced aggregation tables.
With S/4HANA this data model has been changed significantly. The new de-normalized table MATDOC has been introduced which contains the former header and item data of a material document as well as a lot of further attributes. Material document data will be stored in MATDOC only and not anymore in MKPF and MSEG. Additionally the aggregated actual stock quantities will not be persisted anymore in the hybrid or replaced aggregation tables. Instead, actual stock quantity data will be calculated on-the-fly from the new material document table MATDOC for which some of those additional special fields are used. Hence, with the new MM-IM data model the system will work on data base level in an INSERT only mode without DB locks.
Nevertheless, for stock decreasing processes there will be still ABAP locks to ensure stock consistency. A further advantage of the new MM-IM data model is the capability of simple and fast reporting because the most information is in one place: MATDOC.
All below mentioned tables of the SAP ERP 6.0 world do still exist in S/4HANA as DDIC definition as well as data base object and the hybrid tables will still be used to store the material master data attributes. For compatibility reasons there are Core Data Service (CDS) Views assigned as proxy objects to all those tables ensuring that each read access to one of the mentioned tables below still returns the data as before in SAP ERP 6.0. The CDS Views do the on-the-fly aggregation of actual stock quantities from the new MM-IM data model and join the master data attributes from the material master data table. Hence all customer coding will work as before because each read access to one of the tables will get redirected in the database interface layer of NetWeaver to the assigned CDS view.
库存管理数据模型改变了。新的MATDOC表会记录所有物料凭证数据和其他属性,不再记录在MKPF 和 MSEG表中(实际上这两个表仍有记录,应该是考虑到兼容性)。实际库存数据不再记录,而是实时对照MATDOC表算出。
历史表、汇总表都不存在了,换成了CDS视图。
The affected tables are listedbelow:
Table | Table description | DDL Source of CDSView for redirect | View to read the content ofthe database table (w/oredirect to compatibilityview) | View to read themaster dataattributes only |
---|---|---|---|---|
MKPF | Materialdocumentheader | NSDM_DDL_MKPF | NSDM_MIG_MKPF | |
MSEG | Materialdocument item | NSDM_DDL_MSEG | NSDM_MIG_MSEG | |
MARC | Plant Data forMaterial | NSDM_DDL_MARC | NSDM_MIG_MARC | V_MARC_MD |
MARD | Storage LocationData for Material | NSDM_DDL_MARD | NSDM_MIG_MARD | V_MARD_MD |
MCHB | Batch stocks | NSDM_DDL_MCHB | NSDM_MIG_MCHB | V_MCHB_MD |
MKOL | Special Stocksfrom Vendor | NSDM_DDL_MKOL | NSDM_MIG_MKOL | V_MKOL_MD |
MSLB | Special Stockswith Vendor | NSDM_DDL_MSLB | NSDM_MIG_MSLB | V_MSLB_MD |
MSKA | Sales Order Stock | NSDM_DDL_MSKA | NSDM_MIG_MSKA | V_MSKA_MD |
MSSA | Total CustomerOrders on Hand | NSDM_DDL_MSSA | NSDM_MIG_MSSA | |
MSPR | Project Stock | NSDM_DDL_MSPR | NSDM_MIG_MSPR | V_MSPR_MD |
MSSL | Total SpecialStocks withVendor | NSDM_DDL_MSSL | NSDM_MIG_MSSL | |
MSSQ | Project StockTotal | NSDM_DDL_MSSQ | NSDM_MIG_MSSQ | |
MSKU | Special Stockswith Customer | NSDM_DDL_MSKA | NSDM_MIG_MSKU | V_MSKU_MD |
MSTB | Stock in Transit | NSDM_DDL_MSTB | NSDM_MIG_MSTB | |
MSTE | Stock in Transitto Sales andDistributionDocument | NSDM_DDL_MSTE | NSDM_MIG_MSTE | |
MSTQ | Stock in Transitfor Project | NSDM_DDL_MSTQ | NSDM_MIG_MSTQ | |
MCSD | DIMP: CustomerStock | NSDM_DDL_MCSD | NSDM_MIG_MCSD | MCSD_MD |
MCSS | DIMP: TotalCustomer Stock | NSDM_DDL_MCSS | NSDM_MIG_MCSS | MCSS_MD |
MSCD | DIMP: Customerstock withvendor | NSDM_DDL_MSCD | NSDM_MIG_MSCD | MSCD_MD |
MSCS | DIMP: Customerstock withvendor - Total | NSDM_DDL_MSCS | NSDM_MIG_MSCS | MSCS_MD |
MSFD | DIMP: SalesOrder Stock withVendor | NSDM_DDL_MSFD | NSDM_MIG_MSFD | MSFD_MD |
MSFS | DIMP: SalesOrder Stock withVendor - Total | NSDM_DDL_MFS | NSDM_MIG_MSFS | MSFS_MD |
MSID | DIMP: VendorStock withVendor | NSDM_DDL_MSID | NSDM_MIG_MSID | MSID_MD |
MSIS | DIMP: VendorStock withVendor - Total | NSDM_DDL_MSIS | NSDM_MIG_MSIS | MSIS_MD |
MSRD | DIMP: ProjectStock withVendor | NSDM_DDL_MSRD | NSDM_MIG_MSRD | MSRD_MD |
MSRS | DIMP: ProjectStock withVendor - Total | NSDM_DDL_MSRS | NSDM_MIG_MSRS | MSRS_MD |
MARCH | History | NSDM_DDL_MARCH | NSDM_MIG_MARCH | |
MARDH | History | NSDM_DDL_MARDH | NSDM_MIG_MARDH | |
MCHBH | History | NSDM_DDL_MCHBH | NSDM_MIG_MCHBH | |
MKOLH | History | NSDM_DDL_MKOLH | NSDM_MIG_MKOLH | |
MSLBH | History | NSDM_DDL_MSLBH | NSDM_MIG_MSLBH | |
MSKAH | History | NSDM_DDL_MSKAH | NSDM_MIG_MSKAH | |
MSSAH | History | NSDM_DDL_MSSAH | NSDM_MIG_MSSAH | |
MSPRH | History | NSDM_DDL_MSPRH | NSDM_MIG_MSPRH | |
MSSQH | History | NSDM_DDL_MSSQH | NSDM_MIG_MSSQH | |
MSKUH | History | NSDM_DDL_MSKAH | NSDM_MIG_MSKAH | |
MSTBH | History | NSDM_DDL_MSTBH | NSDM_MIG_MSTBH | |
MSTEH | History | NSDM_DDL_MSTEH | NSDM_MIG_MSTEH | |
MSTQH | History | NSDM_DDL_MSTQH | NSDM_MIG_MSTQH | |
MCSDH | History | NSDM_DDL_MCSDH | NSDM_MIG_MCSDH | |
MCSSH | History | NSDM_DDL_MCSSH | NSDM_MIG_MCSSH | |
MSCDH | History | NSDM_DDL_MSCDH | NSDM_MIG_MSCDH | |
MSFDH | History | NSDM_DDL_MSFDH | NSDM_MIG_MSFDH | |
MSIDH | History | NSDM_DDL_MSIDH | NSDM_MIG_MSIDH | |
MSRDH | History | NSDM_DDL_MSRDH | NSDM_MIG_MSRDH |