The CKMLPR_EB table in SAP ERP or S/4HANA stores Prices for Ending Inventory/Balance Sheet Valuation data. There are total 18 fields in CKMLPR_EB table. The Prices for Ending Inventory/Balance Sheet Valuation 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 CKMLPR_EB table. It is in Material Ledger (CKML) ABAP package and is part of the Actual Costing/Material Ledger (CO-PC-ACT) module.
SAP CKMLPR_EB Table Fields
Following is the list of fields that are available in SAP CKMLPR_EB 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), PRKZG (Price Name for Ending Inventory/Balance Sheet Valuation), CURTP (Currency type and valuation view).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | 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) | |
| PRKZG | Price Name for Ending Inventory/Balance Sheet Valuation | CK_PRICE_KZG | TCKMLPR_EB | CHAR (3) |
| CURTP | Currency type and valuation view | CURTP | CHAR (2) | |
| WAERS | Currency Key | WAERS | * | CUKY (5) |
| FINAL | Indicator for Final Result of Balance Sheet Valuation | CK_FINAL | CHAR (1) | |
| SALK3 | Value of Total Valuated Inventory | CK_SALK3_1 | CURR (15) | |
| LBKUM | Total Valuated Stock | LBKUM | QUAN (13) | |
| MEINS | Base Unit of Measure | MEINS | * | UNIT (3) |
| PRICE | Price for Ending Inventory Valuation | CK_EIPRICE | CURR (11) | |
| PEINH | Price unit | PEINH | DEC (5) | |
| PRGID | Balance Sheet Valuation Program ID | MY_PROGID | CHAR (2) | |
| TIMEL | Time Stamp – Long Format | TZNTSTMPLL | NUMC (21) | |
| SALK3_INV | Value of Total Valuated Inventory | CK_SALK3_1 | CURR (15) | |
| LBKUM_INV | Total Valuated Stock | LBKUM | QUAN (13) |
