1. Home
  2. Resources
  3. SAP Tables
  4. CKMLPR - Material Ledger: Prices

SAP Table CKMLPR

Material Ledger: Prices

CKMLPR (Material Ledger: Prices) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CKMLPR to other SAP tables.

CKMLPR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
PEINH Price Unit PEINH DEC 5 0
ZPRSDAT Date from which a future valuation price is to be valid CK_ZPRSDAT DATS 8 0
ZKPRS Future price DZKPRS CURR 11 2
KALKZ Indicator: standard cost estimate for future period KAXKZ CHAR 1 0
X Yes
NULL No
PPRDZ Period of Future Standard Cost Estimate CK_PPRDZ NUMC 3 0
PDATZ Fiscal Year of Future Standard Cost Estimate CK_PDATZ NUMC 4 0
BWVA1 Valuation Variant for Future Standard Cost Estimate CK_BWVA1 CHAR 3 0
VERS1 Costing Version of Future Standard Cost Estimate CK_TVERS1 NUMC 2 0
ZPLPR Future planned price DZPLPR CURR 11 2
FPLPX Fixed Portion of Future Planned Price CK_ZPLPX CURR 11 2
ZBWST Valuation Strategy for Future Planned Price, Special Stock CK_ZBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
KALKL Standard Cost Estimate for Current Period KALKL CHAR 1 0
X Yes
NULL No
PPRDL Period of Current Standard Cost Estimate CK_PPRDL NUMC 3 0
PDATL Fiscal Year of Current Standard Cost Estimate CK_PDATL NUMC 4 0
BWVA2 Valuation Variant for Current Standard Cost Estimate CK_BWVA2 CHAR 3 0
VERS2 Costing Version of Current Standard Cost Estimate CK_TVERS2 NUMC 2 0
LPLPR Current Planned Price CK_LPLPR CURR 11 2
LPLPX Fixed Portion of Current Planned Price CK_LPLPX CURR 11 2
LBWST Val. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
KALKV Indicator: standard cost estimate for previous period KALKV CHAR 1 0
X Yes
NULL No
PPRDV Period of Previous Standard Cost Estimate CK_PPRDV NUMC 3 0
PDATV Fiscal Year of Previous Standard Cost Estimate CK_PDATV NUMC 4 0
BWVA3 Valuation Variant for Previous Standard Cost Estimate CK_BWVA3 CHAR 3 0
VERS3 Costing Version of Previous Standard Cost Estimate CK_TVERS3 NUMC 2 0
VPLPR Previous planned price VPLPR CURR 11 2
VPLPX Fixed Portion of Previous Planned Price CK_VPLPX CURR 11 2
CBWST Valuation Strategy for Previous Plan Price, Special Stock CK_VBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
SET_BY_MARKING This Currency Type Was Updated to the Material Ledger CK_SET_BY_MARKG CHAR 1 0
X Yes
NULL No
EIBDATJ Year in Which the Ending Inventory Price Is Valid CK_EIBDATJ NUMC 4 0
EIPOPER Period for Which the Ending Inventory Price Is Valid CK_EIPOPER NUMC 3 0
EIPRICE Price for Ending Inventory Valuation CK_EIPRICE CURR 11 2

CKMLPR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMLPR MANDT CKMLPR MANDT T000 Clients MANDT