The CKMLHD_AGGR table in SAP ERP or S/4HANA stores Material Ledger: Header Record data. There are total 19 fields in CKMLHD_AGGR table. The Material Ledger: Header Record table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CKMLHD_AGGR table. It is in Aggregation (CO_ML_AGGR) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP CKMLHD_AGGR Table Fields
Following is the list of fields that are available in SAP CKMLHD_AGGR table. The primary key fields of the table are MANDT (Client), KALN1 (Cost Estimate Number for Cost Est. w/o Qty Structure).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| KALN1 | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC (12) | |
| MLAST | Material Price Determination: Control | CK_ML_ABST | CHAR (1) | |
| XABRECH | Movements Have Occurred Since the Last Price Determination | CK_XABRECH | CHAR (1) | |
| ABRECHDAT | Date of Last Successful Price Determination | CK_ABRDAT | DATS (8) | |
| XABRERR | Obsolete | CKML_D_NOTUSED_CHAR1 | CHAR (1) | |
| ABRECHUHR | Time of Last Sucessful Price Determination | CK_ABRUHR | TIMS (6) | |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| BWKEY | Valuation area | BWKEY | T001K | CHAR (4) |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR (10) |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR (1) | |
| XOBEW | Vendor Stock Valuation Indicator | XOBEW | CHAR (1) | |
| SOBKZ | Special Stock Indicator | SOBKZ | * | CHAR (1) |
| VBELN | Sales and Distribution Document Number | VBELN | CHAR (10) | |
| POSNR | Item number of the SD document | POSNR | NUMC (6) | |
| PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | * | NUMC (8) |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| AEXTERRIND | Indicator: ACDOCA_M_EXTRACT incorrect | CKML_AEXTERRIND | CHAR (1) | |
| MATDOC_AEXTERRIND | Indicator: difference between MATDOC and ACDOCA_M_EXTRACT | CKML_MATDOC_AEXTERRIND | CHAR (1) |
