SAP table CKMLCR (Material Ledger: Period Totals Records Values)

SAP table CKMLCR has 6 primary key fields being MANDT,KALNR,BDATJ,POPER,UNTPER,CURTP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CK_KALNR
BDATJ Posting Date YYYY NUMC 4 0 BDATJ
POPER Posting period NUMC 3 0 POPER
UNTPER Value Structure Type NUMC 3 0 CK_UNTPER
CURTP Currency Type CHAR 2 0 FINS_CURTYPE
PEINH Price Unit DEC 5 0 CK_PEINH_1
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
STPRS Standard Price CURR 11 2 CK_STPRS_1
PVPRS Periodic Unit Price CURR 11 2 CK_PVPRS_1
WAERS Currency Key CUKY 5 0 * WAERS
SALK3 Value of Total Valuated Inventory CURR 15 2 CK_SALK3_1
SALKV Value Based on Periodic Unit Price (with Price Ctrl S Only) CURR 15 2 CK_SALKV_1
ZUUMB_O Revaluation Amount CURR 15 2 CK_ZUUMB_1
ABPRD_O Beginning Inventory: Single-Level Price Differences CURR 15 2 CK_ABPRD
ABKDM_O Beginning Inventory: Single-Level Exchange Rate Differences CURR 15 2 CK_ABKDM
ZUPRD_O Receipts: Single-Level Price Differences CURR 15 2 CK_ZUABW_1
ZUKDM_O Receipts: Single-Level Exchange Rate Differences CURR 15 2 CK_ZUKDM
VPPRD_O Other Receipts/Issues: Single-Level Price Differences CURR 15 2 CK_VPPRD
VPKDM_O Other Receipts/Issues:Single-Level Exchange Rate Differences CURR 15 2 CK_VPKDM
VPPBPRD_O Inputs: Price Differences from Subsequent Adjustments CURR 15 2 CK_VPPBPRD
VPPBKDM_O Inputs: Exchange Rate Differences from Sub. Adjustments CURR 15 2 CK_VPPBKDM
VNPRD_O 1-Level Price Differences from Issues Not Affecting the Pric CURR 15 2 CK_VNPRD
VNKDM_O Outward Movement Not Affecting Price: 1-Lvl Exch.Rate Diff. CURR 15 2 CK_VNKDM
EKPRD_O Receipts: Price Differences from Purchase Orders (From-Val.) CURR 15 2 CK_EKPRD
EKKDM_O Receipts: Exchange Rate Differences from POs (From-Value) CURR 15 2 CK_EKKDM
PBPRD_O Receipts: Price Differences from Adjustments (from Value) CURR 15 2 CK_PBPRD
PBKDM_O Receipts: Exchange Rate Differences from Adjustments CURR 15 2 CK_PBKDM
VNPRD_EA Single-Level Adjustment to Consumption from Price Difference CURR 15 2 CK_VNPRDEA
VNKDM_EA Single-Level Adjustment to Consumption from ExRt Differences CURR 15 2 CK_VNKDMEA
EBPRD_EA Single-Level Adjustm. to End. Inv. Due to Price Differences CURR 15 2 CK_EBPRDEA
EBKDM_EA Single-level Adjustment to Ending Inv. Due to Exch.Rate Diff CURR 15 2 CK_EBKDMEA
ZUUMB_A Revaluation Amount (Not Allocated) CURR 15 2 CK_ZUUMB_A
ZUPRD_A Receipts: Single-Level Price Differences (Not Allocated) CURR 15 2 CK_ZUABW_A
ZUKDM_A Receipts: Single-Level Exch Rate Differences (Not Allocated) CURR 15 2 CK_ZUKDM_A
EKPRD_A Receipts: Price Differences Settled from POs (From-Value) CURR 15 2 CK_EKPRD_A
EKKDM_A Receipts: Settld Exch.Rate Differences from POs (From-Value) CURR 15 2 CK_EKKDM_A
PBPRD_A Receipts: Pr. Diff. Settled from Sub. Adjust. (from Value) CURR 15 2 CK_PBPRD_A
PBKDM_A Receipts: ExRtDiff. Settled frm Sub.Adjustments (from Value) CURR 15 2 CK_PBKDM_A
ABPRD_MO Beginning Inventory: Price Differences from Lower Levels CURR 15 2 CK_ABPRDMO
ABKDM_MO Beginning Inventory: Exch.Rate Differences from Lower Levels CURR 15 2 CK_ABKDMMO
ZUPRD_MO Receipts: Price Differences from Lower Levels CURR 15 2 CK_ZUPRDMO
ZUKDM_MO Receipts: Exchange Rate Differences from Lower Level CURR 15 2 CK_ZUKDMMO
VNPRD_MA Multilevel Adjustment to Consumption from Price Differences CURR 15 2 CK_VNPRDMA
VNKDM_MA Multilevel Adjustment to Consumption from Exch. Rt. Diff. CURR 15 2 CK_VNKDMMA
EBPRD_MA Multilevel Adjustment to End. Inv. Due to Price Differences CURR 15 2 CK_EBPRDMA
EBKDM_MA Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. CURR 15 2 CK_EBKDMMA
ABSALK3 Beginning Inventory Value at Time of Period Closing Program CURR 15 2 CKML_ABSALK3
ZUKDM_OST Receipts: Non-Inventory Relevant Exchange Rate Differences CURR 15 2 CK_ZUKDM_OST
EKKDM_OST Receipts: Non Inv.-Rel.ERDs from Purchase Orders (Fr.Value) CURR 15 2 CK_EKKDM_OST
PBKDM_OST Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr. Value) CURR 15 2 CK_PBKDM_OST
VPKDM_OST Other Receipts/Withdrawals: Non Inventory-Rel. ERDs CURR 15 2 CK_VPKDM_OST
VPPBKDM_OST Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr.Value) CURR 15 2 CK_VPPBKDM_OST
VNKDM_OST Non Inventory-Relevant ERDs from non Price-Affecting Issues CURR 15 2 CK_VNKDM_OST
MARKUP_O Intercompany Profit from Update CURR 15 2 CKML_MARKUP
VKSAL Value of Total Valuated Stock at Sales Price CURR 15 2 CK_VKSAL
SDM_VERSION SilentDataMigration: Version Field for ML Tables CHAR 2 0 FINS_ML_SDM_VERSION

CKMLCR foreign key relationships

Table Field Check Table Check Field
0 CKMLCR MANDT T000 Clients MANDT