The CKMLO table in SAP ERP or S/4HANA stores Material Ledger: Organizational Jobs data. There are total 17 fields in CKMLO table. The Material Ledger: Organizational Jobs 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 CKMLO table. It is in Material Ledger (CKML) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP CKMLO Table Fields
Following is the list of fields that are available in SAP CKMLO table. The primary key fields of the table are MANDT (Client), BWKEY (Valuation area), BDATJ (Posting Date YYYY), POPER (Posting period).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BWKEY | Valuation area | BWKEY | T001K | CHAR (4) |
| BDATJ | Posting Date YYYY | BDATJ | NUMC (4) | |
| POPER | Posting period | POPER | NUMC (3) | |
| ABRERL | Material Price Determination Allowed | ML_ABRERL | CHAR (1) | |
| ABRUSER | User Name | SYUNAME | CHAR (12) | |
| ABRDAT | Local Date | SYSTDATLO | DATS (8) | |
| ABRUHR | Local Time | SYSTTIMLO | TIMS (6) | |
| ABSERL | Material Ledger Closing Entries Allowed | ML_ABSERL | CHAR (1) | |
| ABSUSER | User Name | SYUNAME | CHAR (12) | |
| ABSDAT | Local Date | SYSTDATLO | DATS (8) | |
| ABSUHR | Local Time | SYSTTIMLO | TIMS (6) | |
| PERLOCK | Period is locked (Material Ledger) | ML_PERLOCK | CHAR (1) | |
| LOCKUSER | User Name | SYUNAME | CHAR (12) | |
| LOCKDATE | Local Date | SYSTDATLO | DATS (8) | |
| LOCKTIME | Local Time | SYSTTIMLO | TIMS (6) | |
| LOCKRUN | Costing Run in Actual Costing | CKML_RUN_TYPE | CHAR (8) |
