Model / MM / MATDOC

MM — Materials Management

MATDOC

51 fields · 9 key · 20 foreign keys · sourced from www.s4hd.com

Material Document Segment (S/4HANA universal material-movement table) — the S/4HANA replacement for the classic ECC pairing of MKPF (material document header) and MSEG (material document item). MATDOC supersedes MKPF/MSEG outright: a customer running classic ECC mirrors MKPF/MSEG, while a customer on S/4HANA mirrors MATDOC — the model must read both to cover the MM inventory-movement lane across a customer's install base, the exact same duality FAGLFLEXA vs ACDOCA covers on the FI side (a customer running classic ECC mirrors FAGLFLEXA; a customer on S/4HANA mirrors ACDOCA). Structurally MATDOC is not keyed by MBLNR/MJAHR/ZEILE the way MSEG is — those remain present only as non-key legacy-compatibility reference fields — instead each row is keyed by a split GUID (KEY1 through KEY6) plus MANDT, RECORD_TYPE, and HEADER_COUNTER, reflecting MATDOC's role as a wide semantic-flattened table that carries stock-characteristic dimensions (material, plant, storage location, batch, special-stock indicators) directly on each movement row rather than requiring a join back to master data. SAP's real table carries 300+ fields including CWM parallel-unit-of-measure fields, EWM warehouse-document linkage, retail/fashion segmentation, and joint-venture accounting extensions; this definition is scoped to the split-GUID key, the legacy MBLNR/MJAHR/ZEILE compatibility fields, and the core business fields a downstream MM/FI crosswalk consumes (material, plant, storage location, batch, movement type, quantities, amounts, dates, and the account-assignment fields — cost center, order, WBS, asset, G/L account — that hand off to ACDOCA) — no fewer than 25 fields, per the wide-table rule.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
KEY1 keySplit GUID, Part 1RAW 4
KEY2 keySplit GUID, Part 2RAW 4
KEY3 keySplit GUID, Part 3RAW 5
KEY4 keySplit GUID, Part 4RAW 1
KEY5 keySplit GUID, Part 5RAW 1
KEY6 keySplit GUID, Part 6RAW 1
TBL_GEN keytabula genusRecord TypeNSDM_RECORD_TYPECHAR 60
MAT_DOC_NMR keymateria documentum numeratorMaterial Document CounterNSDM_HEADER_COUNTERRAW 4
NUM_MAT_DOCnumerus materia documentumNumber of Material Document (legacy-compatibility reference field, non-key)MBLNRCHAR 20
MAT_DOC_ANNmateria documentum annusMaterial Document Year (legacy-compatibility reference field, non-key)MJAHRNUMC 8
POS_MAT_DOCpositio materia documentumItem in Material Document (legacy-compatibility reference field, non-key)MBLPONUMC 8
MAT_NUMmateria numerusMaterial NumberMATNRCHAR 80
OFCofficinaPlantWERKS_DCHAR 8
LOClocus repositionisStorage LocationLGORT_DCHAR 8T001L
GRX_NUMgrex numerusBatch NumberCHARG_DCHAR 20
AES_GENaestimatio genusValuation TypeBWTAR_DCHAR 20
MTM_GENmotus genusMovement Type (Inventory Management)BWARTCHAR 6T156
SOCcodex societatisCompany CodeBUKRSCHAR 8T001
QNTquantitasQuantityMENGE_DDEC 7
MENmensuraBase Unit of MeasureMEINSCHAR 6T006
SUM_MONsumma monetaAmount in Local CurrencyDMBTR_CSDEC 7
CVMclavis monetaeCurrency KeyWAERSCHAR 10TCURC
DIN_DOCdies inscriptionis documentumPosting Date in the DocumentBUDATDATS 16
DDC_DOCdies documenti documentumDocument Date in DocumentBLDATDATS 16
DIE_DOCdies documentumDay On Which Accounting Document Was EnteredCPUDTDATS 16
ANFannus fiscalisFiscal YearGJAHRNUMC 8
RFR_NDOreferentia numerus documentiReference Document NumberXBLNR1CHAR 32
MEM_NUMmandatum emptionis numerusPurchase order numberBSTNRCHAR 20EKKO
POS_NUM_DEMpositio numerus documentum emptionisItem Number of Purchasing DocumentEBELPNUMC 10EKPO
VEN_RAT_NUMvenditor ratio numerusSupplier's Account NumberELIFNCHAR 20LFA1
RAT_NUM_EMPratio numerus emptorAccount number of customerEKUNNCHAR 20KNA1
MND_NUMmandatum numerusOrder NumberAUFNRCHAR 24AUFK
PTM_NUMpatrimonium numerusMain Asset NumberANLN1CHAR 24ANLH
PTMpatrimoniumAsset SubnumberANLN2CHAR 8ANLA
CSMcentrum sumptusCost CenterKOSTLCHAR 20CSKS
AMDarea moderationisControlling AreaKOKRSCHAR 8TKA01
OPS_ELM_EOPopus elementum elementum operisWork Breakdown Structure Element (WBS Element)PS_PSP_PNRCHAR 16PRPS
CLUcentrum lucriProfit CenterPRCTRCHAR 20
RAT_NUMratio numerusG/L Account NumberSAKNRCHAR 20SKA1
SMP_OBIsumptus obiectumCost ObjectKSTRGCHAR 24
NUM_RAT_ASGnumerus ratio assignatioSequential Number of Account AssignmentDZEKKNNUMC 4
DBT_CRD_IDXdebitum creditum indexDebit/Credit IndicatorSHKZGCHAR 2
CPA_GENcopia genusStock TypeMB_INSMKCHAR 2
CPA_IDXcopia indexSpecial Stock IndicatorSOBKZCHAR 2
CSA_MTMcausa motusReason for MovementMB_GRBEWNUMC 8T157D
TRB_VDT_CODtributum venditio codexTax on sales/purchases codeMWSKZCHAR 4T007A
TRBtributumTax JurisdictionTXJCDCHAR 30
NUM_DOC_CNDnumerus documentum condicioNumber of the Document ConditionKNUMVCHAR 20
POS_CREpositio creatusItem automatically createdMB_XAUTOCHAR 2
NHR_HORnumerus horrei horreumWarehouse Number / Warehouse ComplexLGNUMCHAR 6T300

Foreign keys

FieldCheck tableCheck field
MANDTT000MANDT
LGORTT001LLGORT
BWARTT156BWART
BUKRST001BUKRS
MEINST006MSEHI
WAERSTCURCWAERS
EBELNEKKOEBELN
EBELPEKPOEBELP
LIFNRLFA1LIFNR
KUNNRKNA1KUNNR
AUFNRAUFKAUFNR
ANLN1ANLHANLN1
ANLN2ANLAANLN2
KOSTLCSKSKOSTL
KOKRSTKA01KOKRS
PS_PSP_PNRPRPSPSPNR
SAKTOSKA1SAKNR
GRUNDT157DGRUND
MWSKZT007AMWSKZ
LGNUMT300LGNUM

View MATDOC.yaml in the repository