SAP table MLHD (Material Ledger Document: Header)

SAP table MLHD has 3 primary key fields being MANDT,BELNR,KJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
VGART Material Ledger: Transaction Type CHAR 2 0 CK_VGART
AC Input-Activity Type/ABC Process (Multilevel Pr. Determ.)
AD Adjustment of Negative Consumptions & Single-Material Cycles
AL Activity Type/ABC Process Closing
AT ML Update - Activity Consumption
CC Alternatice Valuation Run Closing
CL Material Ledger Closing
DA DATA AGING
DC Debit/Credit Material
MA Manual Change of Actual Cost Component Splits
MB Beginning Inventory (Multilevel Price Determination)
MC Input Material: Currency Types Of Outputs (Multilvl Pr.Det.)
MI Input Material (Multilevel Price Determination)
MO Output Material (Multilevel Price Determination)
MS Multilevel Price Determination
MY Delta Posting Balance Sheet Valuation
OC New Valuation Logical Inventory (Only IS-Oil)
PC Price Change
RC Revaluation of Consumption
RE Material Ledger Repair
RO Revaluation of Consumption to Original Account Assignment
RS Revaluation of Consumption to Collective Account Assignment
ST Single-Level Price Determination
UP Material Ledger Update
W1 Material (Total WIP Revaluation)
W2 Material (Process WIP Revaluation)
W3 Activity Type (Total WIP Revaluation)
W4 Activity Type (Process WIP Revaluation)
WC WIP: Input Material: Currency Type Output
WI WIP: Input Material (Multilevel Price Determination)
WL WIP: Input Activity Type/ABC Process (Multilevel)
WP WIP Revaluation
WQ WIP Quantity Document (WIP Determination)
LDGRP Ledger Group CHAR 4 0 FAGL_TLDGRP FAGL_LDGRP
AWTYP Reference procedure CHAR 5 0 AWTYP
AWREF Reference document number CHAR 10 0 AWREF
AWORG Reference Organizational Units CHAR 10 0 AWORG
AWSYS Logical System CHAR 10 0 LOGSYSTEM
STORNO Indicator: Material Ledger Reversal Document CHAR 1 0 CK_STORNO
UMBEW The Materials Should Be Revaluated CHAR 1 0 CK_UMBEWERTEN
BLDAT Document Date in Document DATS 8 0 BLDAT
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USNAM
TCODE Transaction Code CHAR 20 0 TCODE
GLVOR Business Transaction CHAR 4 0 GLVOR
LOGSYS Logical System CHAR 10 0 LOGSYSTEM
PVERS Release of SAP System CHAR 4 0 SYSAPRL
XCOBL_CONS CO Acc. Assignmt for Revaluation of Single Level Consumption CHAR 1 0 CKML_XCOBL_CONS
BKTXT Document Header Text CHAR 25 0 BKTXT
KONGR Account Assignment Reason CHAR 3 0 CKML_KONGR
ACC_PRINCIPLE Accounting Principle CHAR 4 0 ACCOUNTING_PRINCIPLE

MLHD foreign key relationships

Table Field Check Table Check Field
0 MLHD LDGRP FAGL_TLDGRP Ledger Group LDGRP
1 MLHD MANDT T000 Clients MANDT