CKMLCR SAP (Material Ledger: Period Totals Records Values) Table details

Dictionary Type: Table
Description: Material Ledger: Period Totals Records Values




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




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

CKMLCR is a standard SAP Table which is used to store Material Ledger: Period Totals Records Values data and is available within R/3 SAP systems depending on the version and release level.

The CKMLCR table consists of various fields, each holding specific information or linking keys about Material Ledger: Period Totals Records Values data available in SAP. These include KALNR (Cost Estimate Number for Cost Est. w/o Qty Structure), BDATJ (Posting Date YYYY), POPER (Posting period), UNTPER (Value Structure Type).. 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 CKMLCR 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
BDATJPosting Date YYYY BDATJNUMC4GJAHRGJAHRBDTJ
POPERPosting period POPERNUMC3POPERPOPR
UNTPERValue Structure Type CK_UNTPERNUMC3CK_UNTPER
CURTPCurrency Type and Valuation View CURTPCHAR2CURTP
PEINHPrice unit CK_PEINH_1DEC5PACK3
VPRSVPrice control indicator VPRSVCHAR1VPRSV
STPRSStandard price CK_STPRS_1CURR11(2) WERT11
PVPRSPeriodic unit price CK_PVPRS_1CURR11(2) WERT11
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SALK3Value of total valuated stock CK_SALK3_1CURR15(2) WERTV8
SALKVValue based on the periodic unit price (only with pr.ctrl S) CK_SALKV_1CURR15(2) WERTV8
ZUUMB_ORevaluation Amount CK_ZUUMB_1CURR15(2) WERTV8
ABPRD_OBeginning Inventory: Single-Level Price Differences CK_ABPRDCURR15(2) WERTV8
ABKDM_OBeginning Inventory: Single-Level Exchange Rate Differences CK_ABKDMCURR15(2) WERTV8
ZUPRD_OReceipts: Single-level price differences CK_ZUABW_1CURR15(2) WERTV8
ZUKDM_OReceipts: Single-level exchange rate differences CK_ZUKDMCURR15(2) WERTV8
VPPRD_OOther receipts/issues: Single-level price differences CK_VPPRDCURR15(2) WERTV8
VPKDM_OOther receipts/issues:Single-level exchange rate differences CK_VPKDMCURR15(2) WERTV8
VPPBPRD_OInputs: Price Differences from Subsequent Adjustments CK_VPPBPRDCURR15(2) WERTV8
VPPBKDM_OInputs: Exchange Rate Differences from Sub. Adjustments CK_VPPBKDMCURR15(2) WERTV8
VNPRD_O1-Level Price Differences from Issues not Affecting the Pric CK_VNPRDCURR15(2) WERTV8
VNKDM_OOutward movement not affecting price: 1-lvl exch.rate diff. CK_VNKDMCURR15(2) WERTV8
EKPRD_OReceipts: Price Differences from Purchase Orders (From-Val.) CK_EKPRDCURR15(2) WERTV8
EKKDM_OReceipts: Exchange Rate Differences from POs (From-Value) CK_EKKDMCURR15(2) WERTV8
PBPRD_OReceipts: Price differences from adjustments (from value) CK_PBPRDCURR15(2) WERTV8
PBKDM_OReceipts: Exchange Rate Differences from Adjustments CK_PBKDMCURR15(2) WERTV8
VNPRD_EASingle-level adjustment to consumption from price difference CK_VNPRDEACURR15(2) WERTV8
VNKDM_EASingle-level adjustment to consumption from ExRt differences CK_VNKDMEACURR15(2) WERTV8
EBPRD_EASingle-Level Adjustm. to End. Inv. Due to Price Differences CK_EBPRDEACURR15(2) WERTV8
EBKDM_EASingle-level Adjustment to Ending Inv. Due to Exch.Rate Diff CK_EBKDMEACURR15(2) WERTV8
ZUUMB_ARevaluation Amount (Not Allocated) CK_ZUUMB_ACURR15(2) WERTV8
ZUPRD_AReceipts: Single-Level Price Differences (Not Allocated) CK_ZUABW_ACURR15(2) WERTV8
ZUKDM_AReceipts: Single-Level Exch Rate Differences (Not Allocated) CK_ZUKDM_ACURR15(2) WERTV8
EKPRD_AReceipts: Price Differences Settled from POs (From-Value) CK_EKPRD_ACURR15(2) WERTV8
EKKDM_AReceipts: Settld Exch.Rate Differences from POs (From-Value) CK_EKKDM_ACURR15(2) WERTV8
PBPRD_AReceipts: Pr. Diff. Settled from Sub. Adjust. (from value) CK_PBPRD_ACURR15(2) WERTV8
PBKDM_AReceipts: ExRtDiff. settled frm sub.adjustments (from value) CK_PBKDM_ACURR15(2) WERTV8
ABPRD_MOBeginning Inventory: Price Differences from Lower Levels CK_ABPRDMOCURR15(2) WERTV8
ABKDM_MOBeginning Inventory: Exch.Rate Differences from Lower Levels CK_ABKDMMOCURR15(2) WERTV8
ZUPRD_MOReceipts: Price Differences from Lower Levels CK_ZUPRDMOCURR15(2) WERTV8
ZUKDM_MOReceipts: Exchange rate differences from lower level CK_ZUKDMMOCURR15(2) WERTV8
VNPRD_MAMultilevel adjustment to consumption from price differences CK_VNPRDMACURR15(2) WERTV8
VNKDM_MAMultilevel adjustment to consumption from exch. rt. diff. CK_VNKDMMACURR15(2) WERTV8
EBPRD_MAMultilevel Adjustment to End. Inv. Due to Price Differences CK_EBPRDMACURR15(2) WERTV8
EBKDM_MAMultilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. CK_EBKDMMACURR15(2) WERTV8
ABSALK3Beginning Inventory Value at Time of Period Closing Program CKML_ABSALK3CURR15(2) WERTV8
ZUKDM_OSTReceipts: Non-Inventory Relevant Exchange Rate Differences CK_ZUKDM_OSTCURR15(2) WERTV8
EKKDM_OSTReceipts: Non Inv.-Rel.ERDs from Purchase Orders (Fr.Value) CK_EKKDM_OSTCURR15(2) WERTV8
PBKDM_OSTReceipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr. Value) CK_PBKDM_OSTCURR15(2) WERTV8
VPKDM_OSTOther Receipts/Withdrawals: Non Inventory-Rel. ERDs CK_VPKDM_OSTCURR15(2) WERTV8
VPPBKDM_OSTReceipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr.Value) CK_VPPBKDM_OSTCURR15(2) WERTV8
VNKDM_OSTNon Inventory-Relevant ERDs from non Price-Affecting Issues CK_VNKDM_OSTCURR15(2) WERTV8

Key field Non-key field



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

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

SELECT SINGLE *
FROM CKMLCR
INTO CORRESPONDING FIELDS OF WA_CKMLCR
WHERE...

How to access SAP table CKMLCR

Within an ECC or HANA version of SAP you can also view further information about CKMLCR 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!