SAP Table MLBEH

Material Ledger FS Item Table for GR/IR relevant transaction

MLBEH (Material Ledger FS Item Table for GR/IR relevant transaction) 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 MLBEH to other SAP tables.

MLBEH 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
BEWTP PO history category BEWTP CHAR 1 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
MENGE Quantity MENGE_D QUAN 13 3
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
POPER Posting period POPER NUMC 3 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
XWOFF Calculation of val. open XWOFF CHAR 1 0
X Yes
NULL No
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
KSTAR Cost Element KSTAR CHAR 10 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0