SAP Table MLCR

Material Ledger Document: Currencies and Values

MLCR (Material Ledger Document: Currencies and Values) 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 MLCR to other SAP tables.

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

MLCR foreign key relationships

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