CKMLPR SAP (Material Ledger: Prices) Table details

Dictionary Type: Table
Description: Material Ledger: Prices




ABAP Code to SELECT data from CKMLPR
Related tables to CKMLPR
Access table CKMLPR




Table field list including key, data, relationships and ABAP select examples

CKMLPR is a standard SAP Table which is used to store Material Ledger: Prices data and is available within R/3 SAP systems depending on the version and release level.

The CKMLPR table consists of various fields, each holding specific information or linking keys about Material Ledger: Prices data available in SAP. These include KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), CURTP (Currency Type and Valuation View), PEINH (Price Unit), ZPRSDAT (Date from which a future valuation price is to be valid).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CKMLPR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
CURTPCurrency Type and Valuation View CURTPCHAR2CURTP
PEINHPrice Unit PEINHDEC5PACK3
ZPRSDATDate from which a future valuation price is to be valid CK_ZPRSDATDATS8SYDATS
ZKPRSFuture price DZKPRSCURR11(2) WERT11
KALKZIndicator: standard cost estimate for future period KAXKZCHAR1XFELD
PPRDZPeriod of Future Standard Cost Estimate CK_PPRDZNUMC3POPERBUP
PDATZFiscal Year of Future Standard Cost Estimate CK_PDATZNUMC4GJAHRGJAHRGEJ
BWVA1Valuation Variant for Future Standard Cost Estimate CK_BWVA1CHAR3Assigned to domainCK_BWVAR
VERS1Costing Version of Future Standard Cost Estimate CK_TVERS1NUMC2CK_VERSIONVSN
ZPLPRFuture planned price DZPLPRCURR11(2) WERT11
FPLPXFixed Portion of Future Planned Price CK_ZPLPXCURR11(2) WERT11V
ZBWSTValuation Strategy for Future Planned Price, Special Stock CK_ZBWSTCHAR1CK_BWST
KALKLStandard Cost Estimate for Current Period KALKLCHAR1XFELD
PPRDLPeriod of Current Standard Cost Estimate CK_PPRDLNUMC3POPER
PDATLFiscal Year of Current Standard Cost Estimate CK_PDATLNUMC4GJAHRGJAHR
BWVA2Valuation Variant for Current Standard Cost Estimate CK_BWVA2CHAR3Assigned to domainCK_BWVAR
VERS2Costing Version of Current Standard Cost Estimate CK_TVERS2NUMC2CK_VERSION
LPLPRCurrent Planned Price CK_LPLPRCURR11(2) WERT11
LPLPXFixed Portion of Current Planned Price CK_LPLPXCURR11(2) WERT11V
LBWSTVal. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWSTCHAR1CK_BWST
KALKVIndicator: standard cost estimate for previous period KALKVCHAR1XFELD
PPRDVPeriod of Previous Standard Cost Estimate CK_PPRDVNUMC3POPER
PDATVFiscal Year of Previous Standard Cost Estimate CK_PDATVNUMC4GJAHRGJAHR
BWVA3Valuation Variant for Previous Standard Cost Estimate CK_BWVA3CHAR3Assigned to domainCK_BWVAR
VERS3Costing Version of Previous Standard Cost Estimate CK_TVERS3NUMC2CK_VERSION
VPLPRPrevious planned price VPLPRCURR11(2) WERT11
VPLPXFixed Portion of Previous Planned Price CK_VPLPXCURR11(2) WERT11V
CBWSTValuation Strategy for Previous Plan Price, Special Stock CK_VBWSTCHAR1CK_BWST
SET_BY_MARKINGThis Currency Type Was Updated to the Material Ledger CK_SET_BY_MARKGCHAR1XFELD
EIBDATJYear in Which the Ending Inventory Price Is Valid CK_EIBDATJNUMC4GJAHRGJAHR
EIPOPERPeriod for Which the Ending Inventory Price Is Valid CK_EIPOPERNUMC3POPER
EIPRICEPrice for Ending Inventory Valuation CK_EIPRICECURR11(2) WERT11

Key field Non-key field



How do I retrieve data from SAP table CKMLPR using ABAP code

The following ABAP code Example will allow you to do a basic selection on CKMLPR to SELECT all data from the table
DATA: WA_CKMLPR TYPE CKMLPR.

SELECT SINGLE *
FROM CKMLPR
INTO CORRESPONDING FIELDS OF WA_CKMLPR
WHERE...

How to access SAP table CKMLPR

Within an ECC or HANA version of SAP you can also view further information about CKMLPR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!