SAP CKMLV Table – Material Ledger Control Records

The CKMLV table in SAP ERP or S/4HANA stores Material Ledger Control Records data. There are total 9 fields in CKMLV table. The Material Ledger Control Records 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 CKMLV table. It is in Material Ledger (CKML) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.

SAP CKMLV Table Fields

Following is the list of fields that are available in SAP CKMLV table. The primary key fields of the table are MANDT (Client), BWKEY (Valuation area).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT (3)
BWKEY Valuation area BWKEY T001K CHAR (4)
MLBWI Material Ledger Live in Valuation Area CK_ML_BWAI CHAR (1)
MLBWI_PROG ABAP Program: Current Master Program SYREPID CHAR (40)
MLBWI_VERS Release of SAP System SYSAPRL CHAR (4)
MLBWI_DATE Date on Which Valuation Area Went Live CK_INITDAT DATS (8)
MLBWI_USER User Who Set Valuation Area to Live CK_INITUSR CHAR (12)
MLBWI_TRANS_DATE Date of currency translation FML_TRANS_DATE DATS (8)
ACT_LIVE Material Ledger Actual Costing Live in Valuation Area FML_ACT_LIVE CHAR (1)