SAP Table ETRG

Billing Order

ETRG (Billing Order) 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 ETRG to other SAP tables.

ETRG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ANLAGE Installation ANLAGE EANL CHAR 10 0
ABRDATS Scheduled Billing Date ABRDATS DATS 8 0
ABRVORG Billing Transaction ABRVORG CHAR 2 0
01 Periodic Billing (01)
02 Interim Billing (02)
03 Final Billing for Move-Out (03)
04 Period-End Billing (04)
05 Service Territory Transfer (05)
06 Manual Credit Memo/Backbilling (06)
07 Contract Change (07)
08 Customer change (08)
BUKRS Company Code BUKRS T001 CHAR 4 0
SPARTE Division SPARTE TSPA CHAR 2 0
PORTION Portion PORTION TE420 CHAR 8 0
ABRVORG2 Billing Transaction ABRVORG CHAR 2 0
01 Periodic Billing (01)
02 Interim Billing (02)
03 Final Billing for Move-Out (03)
04 Period-End Billing (04)
05 Service Territory Transfer (05)
06 Manual Credit Memo/Backbilling (06)
07 Contract Change (07)
08 Customer change (08)
TRIGSTAT Status of Billing Order TRIGSTAT CHAR 1 0
1 Not billable
2 Billable
ABLEINH Meter reading unit ABLEINH TE422 CHAR 8 0
ADATSOLL Scheduled meter reading date ADATSOLL DATS 8 0
ABRDATSU Scheduled billing date for suppressed billing order ABRDATSU DATS 8 0
ABRVORGU Billing Transaction for a Suppressed Billing Order ABRVORGU CHAR 2 0
01 Periodic Billing (01)
02 Interim Billing (02)
03 Final Billing for Move-Out (03)
04 Period-End Billing (04)
05 Service Territory Transfer (05)
06 Manual Credit Memo/Backbilling (06)
07 Contract Change (07)
08 Customer change (08)
BEGEND Start of period-end billing period BEGEND DATS 8 0
SC_BELNR Number of billing document in adjustment reversal SC_BELNR CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
ENDPRIO Priority of Period-End Billing ENDPRIO CHAR 1 0
NULL Field inactive
X Field active
ABSCHLPAN Adjust budget billing plan ABSCHLPAN CHAR 1 0
NULL Field inactive
X Field active
ZUORDDAT Allocation date for billing E_ZUORDDATABR DATS 8 0
MEM_OPBEL Reversed invoicing document no. for new billing/invoicing MEM_OPBEL CHAR 12 0
MEM_BUDAT Posting Date in the Document MEM_BUDAT DATS 8 0
ADATSOLLU Scheduled MR date of suppressed meter reading order ADATSOLLU DATS 8 0
ESTINBILL Meter Reading Results are Estimated in Billing ESTINBILL CHAR 2 0
01 Billing Estimates Value from Meter Reading Unit
02 Billing Estimates Value Changed by Mass Report
03 Billing Estimates Value Changed by Individual Report
04 Billing Does Not Estimate Value Deleted by Individual Report
ESTINBILLU ESTINBILL of a Suppressed Billing Order ESTINBILLU CHAR 2 0
01 Billing Estimates Value from Meter Reading Unit
02 Billing Estimates Value Changed by Mass Report
03 Billing Estimates Value Changed by Individual Report
04 Billing Does Not Estimate Value Deleted by Individual Report
ESTINBILL_SAV Original Value from ESTINBILL ESTINBILL_SAV CHAR 2 0
01 Billing Estimates Value from Meter Reading Unit
02 Billing Estimates Value Changed by Mass Report
03 Billing Estimates Value Changed by Individual Report
04 Billing Does Not Estimate Value Deleted by Individual Report
ESTINBILL_USAV ESTINBILL_SAV of a Suppressed Billing Order ESTINBILL_USAV CHAR 2 0
01 Billing Estimates Value from Meter Reading Unit
02 Billing Estimates Value Changed by Mass Report
03 Billing Estimates Value Changed by Individual Report
04 Billing Does Not Estimate Value Deleted by Individual Report
OSB_GROUP On-Site Billing Group E_OSB_GROUP CHAR 3 0
MAINDOCNO Billing Document Number of Primary Installation MAINDOCNO CHAR 12 0
WAIT_BI Billing Sequence Control WAIT_BI CHAR 2 0
NULL Order Can Be Billed
0 Order Can Be Billed if Activated
1 Order Cannot Be Billed; Not Activated
VKONTO Contract Account Number VKONT_KK CHAR 12 0
MDUSREQUESTID MDUS Request ID E_MDUSREQUESTID EMDUSDRQHEAD CHAR 22 0
MDUSRQSTAT MDUS Status of Billing Order E_MDUSRQSTAT CHAR 2 0
NULL Request Not Required
01 Request Must Be Created
02 Request Sent
03 Request Confirmed Successfully
04 Request Confirmed with Errors
05 Request Billed with Errors

ETRG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ETRG ABLEINH ETRG ABLEINH TE422 Schedule Master Data for Meter Reading Unit TERMSCHL
ETRG ABLEINH ETRG MANDT TE422 Schedule Master Data for Meter Reading Unit MANDT
ETRG ANLAGE ETRG MANDT EANL Installation .INCLUDE
ETRG ANLAGE ETRG ANLAGE EANL Installation MANDT
ETRG BUKRS ETRG MANDT T001 Company Codes MANDT
ETRG BUKRS ETRG BUKRS T001 Company Codes BUKRS
ETRG MANDT ETRG MANDT T000 Clients MANDT
ETRG MDUSREQUESTID ETRG MANDT EMDUSDRQHEAD Table of MDUS Request Data MANDT
ETRG MDUSREQUESTID ETRG MDUSREQUESTID EMDUSDRQHEAD Table of MDUS Request Data MDUSREQUESTID
ETRG PORTION ETRG MANDT TE420 Sch. Mast. Data: Portion MANDT
ETRG PORTION ETRG PORTION TE420 Sch. Mast. Data: Portion TERMSCHL
ETRG SPARTE ETRG MANDT TSPA Organizational Unit: Sales Divisions MANDT
ETRG SPARTE ETRG SPARTE TSPA Organizational Unit: Sales Divisions SPART