SAP table CKMD_MLCR (Structure MLPP for the Display of Material Ledger Document)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Number of a Material Ledger Document/Price Change Document CHAR 10 0 CK_BELNR
KJAHR Material Ledger Document/Price Change Document: Storage Year NUMC 4 0 CK_KJAHR
POSNR Item in Material Ledger Document NUMC 6 0 CK_MLPOS
BDATJ Posting Date YYYY NUMC 4 0 BDATJ
POPER Posting period NUMC 3 0 POPER
CURTP Currency type and valuation view CHAR 2 0 CURTP
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 CUKY 5 0 TCURC WAERS
SALK3 Amount by Which the Total Valuated Inventory Changes CURR 15 2 CK_SALK3D
SALK3_OLD Value of Total Valuated Inventory CURR 15 2 CK_SALK3_1
SALKV Amount by Which the Total Valuated Inventory (Info.) Changes CURR 15 2 CK_SALKVD
SALKV_OLD Value Based on Periodic Unit Price (with Price Ctrl S Only) CURR 15 2 CK_SALKV_1
PEINH Price Unit DEC 5 0 CK_PEINH_1
PVPRS_OLD Old Periodic Unit Price CURR 11 2 CK_PVP_OLD
STPRS_OLD Old Standard Price CURR 11 2 CK_STP_OLD
VPRSV_OLD Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
SDM_VERSION SilentDataMigration: Version Field for ML Tables CHAR 2 0 * FINS_ML_SDM_VERSION
BNBTR Delivery costs in local currency CURR 13 2 BNBTR
EXBWR Externally Entered Posting Amount in Local Currency CURR 13 2 EXBWR
VKWRT Value at Sales Prices Including Value-Added Tax CURR 13 2 VKWRT
VKWRA Value at Sales Prices Excluding Value Added Tax CURR 13 2 VKWRA
EXVKW Externally Entered Sales Value in Local Currency CURR 13 2 EXVKW
VKSAL_OLD Value of Total Valuated Stock at Sales Price CURR 13 2 VKSAL
RLDNR Ledger in General Ledger Accounting CHAR 2 0 FINS_LEDGER
EXT_CURTYPE External Currency Type and Valuation View CHAR 2 0 FINS_EXT_CURTYPE
PVPRS_NEW New Periodic Unit Price CURR 11 2 CK_PVP_NEW
STPRS_NEW New Standard Price CURR 11 2 CK_STP_NEW
VPRSV_NEW Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
PEINH_NEW New Price Unit for the Material Ledger DEC 5 0 CK_PEINH_NEW
MANPAE_V Indicator: Price Manually Overridden CHAR 1 0 CK_MANPAE
SALK3UM Sub. Adjust. to Stock Value due to Change in Per. Unit Price CURR 15 2 CK_SALUM
MANPAE_S Indicator: Price Manually Overridden CHAR 1 0 CK_MANPAE
SALK3UMS Sub. Adj. to Inv. Value due to a Change in the Std Price CURR 15 2 CK_SALUMS
ERZKALK Price from Standard Cost Estimate CHAR 1 0 CK_ERZKALK
ZUKBEW Indicator: Future Valuation Price Activated CHAR 1 0 CK_ZUKBEW
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
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
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
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
EKPRD_EA Receipts: Price Differences from Purchase Orders (From-Val.) CURR 15 2 CK_EKPRD
EKKDM_EA Receipts: Exchange Rate Differences from POs (From-Value) CURR 15 2 CK_EKKDM
ZUPRD_A Receipts: Single-Level Price Differences CURR 15 2 CK_ZUABW_1
ZUKDM_A Receipts: Single-Level Exchange Rate Differences CURR 15 2 CK_ZUKDM
ZUUMB_A Revaluation Amount CURR 15 2 CK_ZUUMB_1
EKPRD_A Receipts: Price Differences from Purchase Orders (From-Val.) CURR 15 2 CK_EKPRD
EKKDM_A Receipts: Exchange Rate Differences from POs (From-Value) CURR 15 2 CK_EKKDM
PBPRD_A Receipts: Price Differences from Adjustments (from Value) CURR 15 2 CK_PBPRD
PBKDM_A Receipts: Exchange Rate Differences from Adjustments CURR 15 2 CK_PBKDM
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
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

CKMD_MLCR foreign key relationships

Table Field Check Table Check Field
0 CKMD_MLCR MANDT T000 Clients MANDT
1 CKMD_MLCR WAERS TCURC Currency Codes MANDT
1 CKMD_MLCR WAERS TCURC Currency Codes WAERS