1. Home
  2. Resources
  3. SAP Tables
  4. CKMD_MLCR - Structure MLPP for the Display of Material Ledger Document

SAP Table CKMD_MLCR

Structure MLPP for the Display of Material Ledger Document

CKMD_MLCR (Structure MLPP for the Display of Material Ledger Document) 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 CKMD_MLCR to other SAP tables.

Source: CKMD_MLCR (Structure MLPP for the Display of Material Ledger Document)

CKMD_MLCR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BELNR Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
POSNR Item in Material Ledger Document CK_MLPOS NUMC 6 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 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
WAERS Currency Key WAERS TCURC CUKY 5 0
SALK3 Amount by which the total valuated inventory changes CK_SALK3D CURR 15 2
SALK3_OLD Value of total valuated stock CK_SALK3_1 CURR 15 2
SALKV Amount by which the total valuated inventory (info.) changes CK_SALKVD CURR 15 2
SALKV_OLD Value based on the periodic unit price (only with pr.ctrl S) CK_SALKV_1 CURR 15 2
PEINH Price unit CK_PEINH_1 DEC 5 0
PVPRS_OLD Old periodic unit price CK_PVP_OLD CURR 11 2
STPRS_OLD Old standard price CK_STP_OLD CURR 11 2
VPRSV_OLD Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
PVPRS_NEW New periodic unit price CK_PVP_NEW CURR 11 2
STPRS_NEW New standard price CK_STP_NEW CURR 11 2
VPRSV_NEW Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
PEINH_NEW New price unit for the material ledger CK_PEINH_NEW DEC 5 0
MANPAE_V Indicator: price manually overridden CK_MANPAE CHAR 1 0
X Yes
NULL No
SALK3UM Sub. Adjust. to Stock Value due to Change in Per. Unit Price CK_SALUM CURR 15 2
MANPAE_S Indicator: price manually overridden CK_MANPAE CHAR 1 0
X Yes
NULL No
SALK3UMS Sub. Adj. to Inv. Value due to a Change in the Std Price CK_SALUMS CURR 15 2
ERZKALK Price from Standard Cost Estimate CK_ERZKALK CHAR 1 0
X Yes
NULL No
ZUKBEW Indicator: future valuation price activated CK_ZUKBEW CHAR 1 0
X Yes
NULL No
ZUPRD_O Receipts: Single-level price differences CK_ZUABW_1 CURR 15 2
ZUKDM_O Receipts: Single-level exchange rate differences CK_ZUKDM CURR 15 2
ZUUMB_O Revaluation Amount CK_ZUUMB_1 CURR 15 2
ABPRD_O Beginning Inventory: Single-Level Price Differences CK_ABPRD CURR 15 2
ABKDM_O Beginning Inventory: Single-Level Exchange Rate Differences CK_ABKDM CURR 15 2
VPPRD_O Other receipts/issues: Single-level price differences CK_VPPRD CURR 15 2
VPKDM_O Other receipts/issues:Single-level exchange rate differences CK_VPKDM CURR 15 2
VNPRD_O 1-Level Price Differences from Issues not Affecting the Pric CK_VNPRD CURR 15 2
VNKDM_O Outward movement not affecting price: 1-lvl exch.rate diff. CK_VNKDM CURR 15 2
EKPRD_O Receipts: Price Differences from Purchase Orders (From-Val.) CK_EKPRD CURR 15 2
EKKDM_O Receipts: Exchange Rate Differences from POs (From-Value) CK_EKKDM CURR 15 2
PBPRD_O Receipts: Price differences from adjustments (from value) CK_PBPRD CURR 15 2
PBKDM_O Receipts: Exchange Rate Differences from Adjustments CK_PBKDM CURR 15 2
VNPRD_EA Single-level adjustment to consumption from price difference CK_VNPRDEA CURR 15 2
VNKDM_EA Single-level adjustment to consumption from ExRt differences CK_VNKDMEA CURR 15 2
EBPRD_EA Single-Level Adjustm. to End. Inv. Due to Price Differences CK_EBPRDEA CURR 15 2
EBKDM_EA Single-level Adjustment to Ending Inv. Due to Exch.Rate Diff CK_EBKDMEA CURR 15 2
EKPRD_EA Receipts: Price Differences from Purchase Orders (From-Val.) CK_EKPRD CURR 15 2
EKKDM_EA Receipts: Exchange Rate Differences from POs (From-Value) CK_EKKDM CURR 15 2
ZUPRD_A Receipts: Single-level price differences CK_ZUABW_1 CURR 15 2
ZUKDM_A Receipts: Single-level exchange rate differences CK_ZUKDM CURR 15 2
ZUUMB_A Revaluation Amount CK_ZUUMB_1 CURR 15 2
EKPRD_A Receipts: Price Differences from Purchase Orders (From-Val.) CK_EKPRD CURR 15 2
EKKDM_A Receipts: Exchange Rate Differences from POs (From-Value) CK_EKKDM CURR 15 2
PBPRD_A Receipts: Price differences from adjustments (from value) CK_PBPRD CURR 15 2
PBKDM_A Receipts: Exchange Rate Differences from Adjustments CK_PBKDM CURR 15 2
ABPRD_MO Beginning Inventory: Price Differences from Lower Levels CK_ABPRDMO CURR 15 2
ABKDM_MO Beginning Inventory: Exch.Rate Differences from Lower Levels CK_ABKDMMO CURR 15 2
ZUPRD_MO Receipts: Price Differences from Lower Levels CK_ZUPRDMO CURR 15 2
ZUKDM_MO Receipts: Exchange rate differences from lower level CK_ZUKDMMO CURR 15 2
VNPRD_MA Multilevel adjustment to consumption from price differences CK_VNPRDMA CURR 15 2
VNKDM_MA Multilevel adjustment to consumption from exch. rt. diff. CK_VNKDMMA CURR 15 2
EBPRD_MA Multilevel Adjustment to End. Inv. Due to Price Differences CK_EBPRDMA CURR 15 2
EBKDM_MA Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. CK_EBKDMMA CURR 15 2
ZUKDM_OST Receipts: Non-Inventory Relevant Exchange Rate Differences CK_ZUKDM_OST CURR 15 2
EKKDM_OST Receipts: Non Inv.-Rel.ERDs from Purchase Orders (Fr.Value) CK_EKKDM_OST CURR 15 2
PBKDM_OST Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr. Value) CK_PBKDM_OST CURR 15 2
VPKDM_OST Other Receipts/Withdrawals: Non Inventory-Rel. ERDs CK_VPKDM_OST CURR 15 2
VPPBKDM_OST Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr.Value) CK_VPPBKDM_OST CURR 15 2
VNKDM_OST Non Inventory-Relevant ERDs from non Price-Affecting Issues CK_VNKDM_OST CURR 15 2

CKMD_MLCR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CKMD_MLCR MANDT CKMD_MLCR MANDT T000 Clients MANDT
CKMD_MLCR WAERS CKMD_MLCR MANDT TCURC Currency Codes MANDT
CKMD_MLCR WAERS CKMD_MLCR WAERS TCURC Currency Codes WAERS