SAP S/4 HANA新变化-MM物料管理:数据模型(转)

数据模型变化


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.


SAP S/4 HANA新变化-MM物料管理:数据模型(转)_第1张图片

库存管理数据模型改变了。新的MATDOC表会记录所有物料凭证数据和其他属性,不再记录在MKPF 和 MSEG表中(实际上这两个表仍有记录,应该是考虑到兼容性)。实际库存数据不再记录,而是实时对照MATDOC表算出。

历史表、汇总表都不存在了,换成了CDS视图。


The affected tables are listedbelow:

Table

Table  description

DDL  Source of CDS

View  for redirect

View  to read the content of

the  database table (w/o

redirect  to compatibility

view)

View  to read the

master  data

attributes  only

MKPF

Material

document

header

NSDM_DDL_MKPF

NSDM_MIG_MKPF


MSEG

Material

document item

NSDM_DDL_MSEG

NSDM_MIG_MSEG


MARC

Plant Data for

Material

NSDM_DDL_MARC

NSDM_MIG_MARC

V_MARC_MD

MARD

Storage Location

Data 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 Stocks

from Vendor

NSDM_DDL_MKOL

NSDM_MIG_MKOL

V_MKOL_MD

MSLB

Special Stocks

with 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 Customer

Orders on Hand

NSDM_DDL_MSSA

NSDM_MIG_MSSA


MSPR

Project Stock

NSDM_DDL_MSPR

NSDM_MIG_MSPR

V_MSPR_MD

MSSL

Total Special

Stocks with

Vendor

NSDM_DDL_MSSL

NSDM_MIG_MSSL


MSSQ

Project Stock

Total

NSDM_DDL_MSSQ

NSDM_MIG_MSSQ


MSKU

Special Stocks

with Customer

NSDM_DDL_MSKA

NSDM_MIG_MSKU

V_MSKU_MD

MSTB

Stock in Transit

NSDM_DDL_MSTB

NSDM_MIG_MSTB


MSTE

Stock in Transit

to Sales and

Distribution

Document

NSDM_DDL_MSTE

NSDM_MIG_MSTE


MSTQ

Stock in Transit

for Project

NSDM_DDL_MSTQ

NSDM_MIG_MSTQ


MCSD

DIMP: Customer

Stock

NSDM_DDL_MCSD

NSDM_MIG_MCSD

MCSD_MD

MCSS

DIMP: Total

Customer Stock

NSDM_DDL_MCSS

NSDM_MIG_MCSS

MCSS_MD

MSCD

DIMP: Customer

stock with

vendor

NSDM_DDL_MSCD

NSDM_MIG_MSCD

MSCD_MD

MSCS

DIMP: Customer

stock with

vendor - Total

NSDM_DDL_MSCS

NSDM_MIG_MSCS

MSCS_MD

MSFD

DIMP: Sales

Order Stock with

Vendor

NSDM_DDL_MSFD

NSDM_MIG_MSFD

MSFD_MD

MSFS

DIMP: Sales

Order Stock with

Vendor - Total

NSDM_DDL_MFS

NSDM_MIG_MSFS

MSFS_MD

MSID

DIMP: Vendor

Stock with

Vendor

NSDM_DDL_MSID

NSDM_MIG_MSID

MSID_MD

MSIS

DIMP: Vendor

Stock with

Vendor - Total

NSDM_DDL_MSIS

NSDM_MIG_MSIS

MSIS_MD

MSRD

DIMP: Project

Stock with

Vendor

NSDM_DDL_MSRD

NSDM_MIG_MSRD

MSRD_MD

MSRS

DIMP: Project

Stock with

Vendor - 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


你可能感兴趣的