SAP Table MRER_ITEM

ERS with HSC: Item Data plus EKRS Table

MRER_ITEM (ERS with HSC: Item Data plus EKRS Table) 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 MRER_ITEM to other SAP tables.

MRER_ITEM table fields

Field Data element Checktable Datatype Length Decimals
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
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
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
LIGHTS Single-Character Indicator CHAR1 CHAR 1 0
STATUS Processing status of goods movement ERS_STATUS CHAR 40 0
ICON Posting type: credit memo, invoice, zero document ICPOSTYP CHAR 40 0
LOG_HANDLE Application Log: Log Handle BALLOGHNDL CHAR 22 0
BLOCK Document Item in Invoice Document RBLGP NUMC 6 0
XBLNR Number of External Delivery Note LFSNR1 CHAR 16 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
LSDAT Delivery note date LSDAT DATS 8 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
PRDAT Date of Price Determination PREDT DATS 8 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Purchase Order Unit of Measure BSTME UNIT 3 0
BPMNG Quantity in purchase order price unit MENGE_BPR QUAN 13 3
BPRME Order Price Unit (Purchasing) BBPRM UNIT 3 0
NETWR Net Order Value in PO Currency BWERT CURR 13 2
KNUMV Number of the document condition KNUMV CHAR 10 0
KPOSN Item in Material Document MBLPO NUMC 4 0
AUFWR Markup in order currency MR_ERS_AUFWR CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
LFGJA Fiscal Year of a Reference Document LFBJA NUMC 4 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
SPTYP Document split for evaluated receipt settlement (ERS) SPTYP CHAR 1 0
NULL Accumulate
X Splitting
HSCKZ Handling Surcharge for Goods Issues HSCKZ CHAR 1 0
X Yes
NULL No
RGJAHR Fiscal Year GJAHR NUMC 4 0
RBELNR Document Number of an Invoice Document RE_BELNR CHAR 10 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
SJAHR Material Document Year MJAHR NUMC 4 0
SMBLN Number of Material Document MBLNR CHAR 10 0
SMBLP Item in Material Document MBLPO NUMC 4 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZLSPR Payment Method DZLSCH CHAR 1 0
ZLSCH Payment Block Key DZLSPR CHAR 1 0
ERSBAI ERS procedure: type of document selection ERS_ERSBA CHAR 2 0
1 Document Selection per Vendor
2 Document Selection per Purchase Order
3 Document Selection per Order Item
4 Document Selection per Delivery Document/Service Entry
6 Document Selection per Transportation Service Provider
7 Document Selection per Shipment Order
5 Document selection per exchange number
PACKNO Package Number of Service PACKNO_EKBE NUMC 10 0
INTROW Line Number of Service INTROW_EKBE NUMC 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
TEXT Message Text NATXT CHAR 73 0
SELFL Single-Character Indicator CHAR1 CHAR 1 0
SPACE_1 Single-Character Indicator CHAR1 CHAR 1 0
SPACE_2 Single-Character Indicator CHAR1 CHAR 1 0
SPACE_3 Single-Character Indicator CHAR1 CHAR 1 0
SPACE_4 Single-Character Indicator CHAR1 CHAR 1 0
EKRS EKRS_TABTYPE TTYP 0 0