SAP table ETRG (Billing Order)

SAP table ETRG has 4 primary key fields being MANDT,ANLAGE,ABRDATS,ABRVORG.

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 T000 MANDT
ANLAGE Installation CHAR 10 0 EANL ANLAGE
ABRDATS Scheduled Billing Date DATS 8 0 ABRDATS
ABRVORG Billing Transaction CHAR 2 0 ABRVORG
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 CHAR 4 0 T001 BUKRS
SPARTE Division CHAR 2 0 TSPA SPARTE
PORTION Portion CHAR 8 0 TE420 PORTION
ABRVORG2 Billing Transaction CHAR 2 0 ABRVORG
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 CHAR 1 0 TRIGSTAT
1 Not billable
2 Billable
ABLEINH Meter reading unit CHAR 8 0 TE422 ABLEINH
ADATSOLL Scheduled meter reading date DATS 8 0 ADATSOLL
ABRDATSU Scheduled billing date for suppressed billing order DATS 8 0 ABRDATSU
ABRVORGU Billing Transaction for a Suppressed Billing Order CHAR 2 0 ABRVORGU
BEGEND Start of period-end billing period DATS 8 0 BEGEND
SC_BELNR Number of billing document in adjustment reversal CHAR 12 0 SC_BELNR
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
ENDPRIO Priority of Period-End Billing CHAR 1 0 ENDPRIO
ABSCHLPAN Adjust budget billing plan CHAR 1 0 ABSCHLPAN
ZUORDDAT Allocation date for billing DATS 8 0 E_ZUORDDATABR
MEM_OPBEL Reversed invoicing document no. for new billing/invoicing CHAR 12 0 MEM_OPBEL
MEM_BUDAT Posting Date in the Document DATS 8 0 MEM_BUDAT
ADATSOLLU Scheduled MR date of suppressed meter reading order DATS 8 0 ADATSOLLU
ESTINBILL Meter Reading Results are Estimated in Billing CHAR 2 0 ESTINBILL
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 CHAR 2 0 ESTINBILLU
ESTINBILL_SAV Original Value from ESTINBILL CHAR 2 0 ESTINBILL_SAV
ESTINBILL_USAV ESTINBILL_SAV of a Suppressed Billing Order CHAR 2 0 ESTINBILL_USAV
OSB_GROUP On-Site Billing Group CHAR 3 0 E_OSB_GROUP
MAINDOCNO Billing Document Number of Primary Installation CHAR 12 0 MAINDOCNO
WAIT_BI Billing Sequence Control CHAR 2 0 WAIT_BI
Order Can Be Billed
0 Order Can Be Billed if Activated
1 Order Cannot Be Billed; Not Activated
VKONTO Contract Account Number CHAR 12 0 VKONT_KK
MDUSREQUESTID MDUS Request ID CHAR 22 0 EMDUSDRQHEAD E_MDUSREQUESTID
MDUSRQSTAT MDUS Status of Billing Order CHAR 2 0 E_MDUSRQSTAT
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
COLOGRP_INST Colocation group for Installation CHAR 12 0 E_COLOGRP_INST
BILLG_ERR Indicator: Incorrect Billing CHAR 1 0 E_BILLING_ERROR

ETRG foreign key relationships

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