SAP Table ERS_ITEM_DATA

Automatic ERS with HSC: item data

ERS_ITEM_DATA (Automatic ERS with HSC: item data) 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 ERS_ITEM_DATA to other SAP tables.

ERS_ITEM_DATA table fields

Field Data element Checktable Datatype Length Decimals
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