1. Home
  2. Resources
  3. SAP Tables
  4. CKMLHD - Material Ledger: Header Record

SAP Table CKMLHD

Material Ledger: Header Record

CKMLHD (Material Ledger: Header Record) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKMLHD to other SAP tables.

Source: CKMLHD (Material Ledger: Header Record)

CKMLHD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
XABRECH Movements have Occurred Since the Last Price Determination CK_XABRECH CHAR 1 0
X Yes
NULL No
ABRECHDAT Date of Last Successful Price Determination CK_ABRDAT DATS 8 0
XABRERR Obsolete CKML_D_NOTUSED_CHAR1 CHAR 1 0
ABRECHUHR Time of Last Sucessful Price Determination CK_ABRUHR TIMS 6 0
MATNR Material Number MATNR MARA CHAR 18 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
XOBEW Vendor Stock Valuation Indicator XOBEW CHAR 1 0
X Yes
NULL No
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0

CKMLHD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMLHD BWKEY CKMLHD MANDT T001K Valuation area MANDT
CKMLHD BWKEY CKMLHD BWKEY T001K Valuation area BWKEY
CKMLHD BWTAR CKMLHD MANDT T149D Global Valuation Types MANDT
CKMLHD BWTAR CKMLHD BWTAR T149D Global Valuation Types BWTAR
CKMLHD MATNR CKMLHD MANDT MARA General Material Data MANDT
CKMLHD MATNR CKMLHD MATNR MARA General Material Data MATNR