SAP table CKMLHD (Material Ledger: Header Record)

SAP table CKMLHD has 2 primary key fields being MANDT,KALNR.

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 MANDT
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CK_KALNR
MLAST Material Price Determination: Control CHAR 1 0 CK_ML_ABST
2 Transaction-Based
3 Single-/Multilevel
XABRECH Movements Have Occurred Since the Last Price Determination CHAR 1 0 CK_XABRECH
ABRECHDAT Date of Last Successful Price Determination DATS 8 0 CK_ABRDAT
XABRERR Obsolete CHAR 1 0 CKML_D_NOTUSED_CHAR1
ABRECHUHR Time of Last Sucessful Price Determination TIMS 6 0 CK_ABRUHR
MATNR Material Number CHAR 40 0 MARA MATNR
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
XOBEW Vendor Stock Valuation Indicator CHAR 1 0 XOBEW
SOBKZ Special Stock Indicator CHAR 1 0 * SOBKZ
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
AEXTERRIND Indicator: ACDOCA_M_EXTRACT incorrect CHAR 1 0 CKML_AEXTERRIND
MATDOC_AEXTERRIND Indicator: difference between MATDOC and ACDOCA_M_EXTRACT CHAR 1 0 CKML_MATDOC_AEXTERRIND
PRICE_SDM_YEARPER Price SDM Fiscal Year Period NUMC 7 0 FML_PRICE_SDM_YEARPER

CKMLHD foreign key relationships

Table Field Check Table Check Field
0 CKMLHD BWTAR T149D Global Valuation Types MANDT
0 CKMLHD BWTAR T149D Global Valuation Types BWTAR
1 CKMLHD MATNR MARA General Material Data MANDT
1 CKMLHD MATNR MARA General Material Data MATNR