CKMLHD SAP table for – Material Ledger: Header Record

Here we would like to draw your attention to CKMLHD table in SAP. As we know it is being mainly used with the SAP CO-PC (Product Cost Controlling in CO) component which is coming under CO module (Controlling). CKMLHD is a SAP standard transparent table used for storing Material Ledger: Header Record related data in SAP. It comes under the package CKML.

SAP CKMLHD table

Table CKMLHD technical data

TableCKMLHD
Data storingMaterial Ledger: Header Record
ModuleCO
ComponentCO-PC
SAP PackageCKML
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CKMLHD Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in CKMLHD table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • XOBEW
    Its data type is C (Character String) with field length 1
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • VBELN : Sales and Distribution Document Number
    Its data type is C (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its data type is N (Character String with Digits Only) with field length 6
  • PSPNR : Standard WBS element
    Its data type is N (Character String with Digits Only) with field length 8
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its a key field. Its data type is N (Character String with Digits Only) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CKI_CKMLHD
  • MLAST
    Its data type is C (Character String) with field length 1
  • XABRECH
    Its data type is C (Character String) with field length 1
  • ABRECHDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • XABRERR
    Its data type is C (Character String) with field length 1
  • ABRECHUHR
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18