SAP table MLBECR (Material Ledger Currency Table for GR/IR relevant transact.)
SAP table MLBECR has 7 primary key fields being MANDT,MLVNR,VGABE,GJAHR,BELNR,BUZEI,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
MANDT
MLVNR
Material Ledger Transaction Number
CHAR
12
0
CK_MLVNR
VGABE
Type of Transaction in the Object History
CHAR
1
0
CKI_VGABE
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
NUMC
4
0
MJAHR
BELNR
Number of Material Document
CHAR
10
0
MBLNR
BUZEI
Item in Material Document
NUMC
4
0
MBLPO
CURTP
Currency Type
CHAR
2
0
FINS_CURTYPE
WAERS
Currency Key
CUKY
5
0
WAERS
SHKZG
Debit/Credit Indicator
CHAR
1
0
SHKZG
H
Credit
S
Debit
WRBTR
Amount or tax amount in the currency of the currency types