1. Home
  2. Resources
  3. SAP Tables
  4. MLBECR - Material Ledger Currency Table for GR/IR relevant transact.

SAP Table MLBECR

Material Ledger Currency Table for GR/IR relevant transact.

MLBECR (Material Ledger Currency Table for GR/IR relevant transact.) 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 MLBECR to other SAP tables.

Source: MLBECR (Material Ledger Currency Table for GR/IR relevant transact.)

MLBECR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MLVNR Material ledger transaction number CK_MLVNR CHAR 12 0
VGABE Type of Transaction in the Object History CKI_VGABE CHAR 1 0
1 Goods Receipt
2 Invoice Receipt
3 Adjustment
4 Down Payment
5 Payments
6 Goods Issue for Stock Transfer
7 Consumption (Subcontracting)
8 Delivery (Stock Transfer)
9 Service Entry Sheet
Q Comparison for Internally Posted Material (Only IS-OIL)
R Return Delivery via Delivery Note
GJAHR Material Document Year MJAHR NUMC 4 0
BELNR Number of Material Document MBLNR CHAR 10 0
BUZEI Item in Material Document MBLPO NUMC 4 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 CUKY 5 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WRBTR Amount or tax amount in the currency of the currency types ACBTR CURR 13 2
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
REEWR Invoice Value Entered (in Local Currency) REEWR CURR 13 2
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
WKURS Exchange Rate WKURS DEC 9 5