The CKMLLACR table in SAP ERP or S/4HANA stores ML Activity Type: Period Record/Currency Record data. There are total 19 fields in CKMLLACR table. The ML Activity Type: Period Record/Currency 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 CKMLLACR table. It is in Update of Activity Consumption in Quantity Structure (CKMLLA) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP CKMLLACR Table Fields
Following is the list of fields that are available in SAP CKMLLACR table. The primary key fields of the table are MANDT (Client), KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), BDATJ (Posting Date YYYY), POPER (Posting period), UNTPER (Value Structure Type), CURTP (Currency type and valuation view).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | * | NUMC (12) |
| BDATJ | Posting Date YYYY | BDATJ | NUMC (4) | |
| POPER | Posting period | POPER | NUMC (3) | |
| UNTPER | Value Structure Type | CK_UNTPER | NUMC (3) | |
| CURTP | Currency type and valuation view | CURTP | CHAR (2) | |
| TOGBTR | Basic Rate – Total | CKML_PRICE | CURR (11) | |
| TOFBTR | Fixed Basic Rate | CKML_PRICE_FIX | CURR (11) | |
| TOGBTRD | Price Variance for Each Unit of Measure | TOGDELTA | CURR (11) | |
| TOE | Price Units in Object Currency | TOEXXX | NUMC (5) | |
| WAERS | Currency Key | WAERS | * | CUKY (5) |
| TOGBTR_S | Basic Rate – Total | CKML_PRICE | CURR (11) | |
| TOFBTR_S | Fixed Basic Rate | CKML_PRICE_FIX | CURR (11) | |
| TOGBTRD_S | Price Variance for Each Unit of Measure | TOGDELTA | CURR (11) | |
| TOE_S | Price Units in Object Currency | TOEXXX | NUMC (5) | |
| WAERS_S | Currency Key | WAERS | * | CUKY (5) |
| BWSTRAT | Strategy for Determining an Allocation Price | BWSTRAT | CHAR (1) | |
| NO_SETTLE | Ind.: Do Not Take Activity Type into Account Upon Pr. Determ | CKML_NO_SETTLE | CHAR (1) | |
| SAPRL | Release of SAP System | SYSAPRL | CHAR (4) |
