CKMLCR SAP (Material Ledger: Period Totals Records Values) Table details
Dictionary Type: Table
Description: Material Ledger: Period Totals Records Values
Description: Material Ledger: Period Totals Records Values
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
BDATJ | Posting Date YYYY | BDATJ | NUMC | 4 | GJAHR | GJAHR | BDTJ | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
UNTPER | Value Structure Type | CK_UNTPER | NUMC | 3 | CK_UNTPER | ||||
CURTP | Currency Type and Valuation View | CURTP | CHAR | 2 | CURTP | ||||
PEINH | Price unit | CK_PEINH_1 | DEC | 5 | PACK3 | ||||
VPRSV | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
STPRS | Standard price | CK_STPRS_1 | CURR | 11(2) | WERT11 | ||||
PVPRS | Periodic unit price | CK_PVPRS_1 | CURR | 11(2) | WERT11 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SALK3 | Value of total valuated stock | CK_SALK3_1 | CURR | 15(2) | WERTV8 | ||||
SALKV | Value based on the periodic unit price (only with pr.ctrl S) | CK_SALKV_1 | CURR | 15(2) | WERTV8 | ||||
ZUUMB_O | Revaluation Amount | CK_ZUUMB_1 | CURR | 15(2) | WERTV8 | ||||
ABPRD_O | Beginning Inventory: Single-Level Price Differences | CK_ABPRD | CURR | 15(2) | WERTV8 | ||||
ABKDM_O | Beginning Inventory: Single-Level Exchange Rate Differences | CK_ABKDM | CURR | 15(2) | WERTV8 | ||||
ZUPRD_O | Receipts: Single-level price differences | CK_ZUABW_1 | CURR | 15(2) | WERTV8 | ||||
ZUKDM_O | Receipts: Single-level exchange rate differences | CK_ZUKDM | CURR | 15(2) | WERTV8 | ||||
VPPRD_O | Other receipts/issues: Single-level price differences | CK_VPPRD | CURR | 15(2) | WERTV8 | ||||
VPKDM_O | Other receipts/issues:Single-level exchange rate differences | CK_VPKDM | CURR | 15(2) | WERTV8 | ||||
VPPBPRD_O | Inputs: Price Differences from Subsequent Adjustments | CK_VPPBPRD | CURR | 15(2) | WERTV8 | ||||
VPPBKDM_O | Inputs: Exchange Rate Differences from Sub. Adjustments | CK_VPPBKDM | CURR | 15(2) | WERTV8 | ||||
VNPRD_O | 1-Level Price Differences from Issues not Affecting the Pric | CK_VNPRD | CURR | 15(2) | WERTV8 | ||||
VNKDM_O | Outward movement not affecting price: 1-lvl exch.rate diff. | CK_VNKDM | CURR | 15(2) | WERTV8 | ||||
EKPRD_O | Receipts: Price Differences from Purchase Orders (From-Val.) | CK_EKPRD | CURR | 15(2) | WERTV8 | ||||
EKKDM_O | Receipts: Exchange Rate Differences from POs (From-Value) | CK_EKKDM | CURR | 15(2) | WERTV8 | ||||
PBPRD_O | Receipts: Price differences from adjustments (from value) | CK_PBPRD | CURR | 15(2) | WERTV8 | ||||
PBKDM_O | Receipts: Exchange Rate Differences from Adjustments | CK_PBKDM | CURR | 15(2) | WERTV8 | ||||
VNPRD_EA | Single-level adjustment to consumption from price difference | CK_VNPRDEA | CURR | 15(2) | WERTV8 | ||||
VNKDM_EA | Single-level adjustment to consumption from ExRt differences | CK_VNKDMEA | CURR | 15(2) | WERTV8 | ||||
EBPRD_EA | Single-Level Adjustm. to End. Inv. Due to Price Differences | CK_EBPRDEA | CURR | 15(2) | WERTV8 | ||||
EBKDM_EA | Single-level Adjustment to Ending Inv. Due to Exch.Rate Diff | CK_EBKDMEA | CURR | 15(2) | WERTV8 | ||||
ZUUMB_A | Revaluation Amount (Not Allocated) | CK_ZUUMB_A | CURR | 15(2) | WERTV8 | ||||
ZUPRD_A | Receipts: Single-Level Price Differences (Not Allocated) | CK_ZUABW_A | CURR | 15(2) | WERTV8 | ||||
ZUKDM_A | Receipts: Single-Level Exch Rate Differences (Not Allocated) | CK_ZUKDM_A | CURR | 15(2) | WERTV8 | ||||
EKPRD_A | Receipts: Price Differences Settled from POs (From-Value) | CK_EKPRD_A | CURR | 15(2) | WERTV8 | ||||
EKKDM_A | Receipts: Settld Exch.Rate Differences from POs (From-Value) | CK_EKKDM_A | CURR | 15(2) | WERTV8 | ||||
PBPRD_A | Receipts: Pr. Diff. Settled from Sub. Adjust. (from value) | CK_PBPRD_A | CURR | 15(2) | WERTV8 | ||||
PBKDM_A | Receipts: ExRtDiff. settled frm sub.adjustments (from value) | CK_PBKDM_A | CURR | 15(2) | WERTV8 | ||||
ABPRD_MO | Beginning Inventory: Price Differences from Lower Levels | CK_ABPRDMO | CURR | 15(2) | WERTV8 | ||||
ABKDM_MO | Beginning Inventory: Exch.Rate Differences from Lower Levels | CK_ABKDMMO | CURR | 15(2) | WERTV8 | ||||
ZUPRD_MO | Receipts: Price Differences from Lower Levels | CK_ZUPRDMO | CURR | 15(2) | WERTV8 | ||||
ZUKDM_MO | Receipts: Exchange rate differences from lower level | CK_ZUKDMMO | CURR | 15(2) | WERTV8 | ||||
VNPRD_MA | Multilevel adjustment to consumption from price differences | CK_VNPRDMA | CURR | 15(2) | WERTV8 | ||||
VNKDM_MA | Multilevel adjustment to consumption from exch. rt. diff. | CK_VNKDMMA | CURR | 15(2) | WERTV8 | ||||
EBPRD_MA | Multilevel Adjustment to End. Inv. Due to Price Differences | CK_EBPRDMA | CURR | 15(2) | WERTV8 | ||||
EBKDM_MA | Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. | CK_EBKDMMA | CURR | 15(2) | WERTV8 | ||||
ABSALK3 | Beginning Inventory Value at Time of Period Closing Program | CKML_ABSALK3 | CURR | 15(2) | WERTV8 | ||||
ZUKDM_OST | Receipts: Non-Inventory Relevant Exchange Rate Differences | CK_ZUKDM_OST | CURR | 15(2) | WERTV8 | ||||
EKKDM_OST | Receipts: Non Inv.-Rel.ERDs from Purchase Orders (Fr.Value) | CK_EKKDM_OST | CURR | 15(2) | WERTV8 | ||||
PBKDM_OST | Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr. Value) | CK_PBKDM_OST | CURR | 15(2) | WERTV8 | ||||
VPKDM_OST | Other Receipts/Withdrawals: Non Inventory-Rel. ERDs | CK_VPKDM_OST | CURR | 15(2) | WERTV8 | ||||
VPPBKDM_OST | Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr.Value) | CK_VPPBKDM_OST | CURR | 15(2) | WERTV8 | ||||
VNKDM_OST | Non Inventory-Relevant ERDs from non Price-Affecting Issues | CK_VNKDM_OST | CURR | 15(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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects