SAP ABAP Table ETRG (Billing Order)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-DM-MR (Application Component) Meter Reading
     ⤷ EE16 (Package) IS-U: Meter Reading Order Creation

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ETRG	Table Relationship Diagram
Short Description	Billing Order

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ANLAGE	☑	ANLAGE	ANLAGE	CHAR	10	0	Installation	EANL
3	ABRDATS	☑	ABRDATS	DATUM	DATS	8	0	Scheduled Billing Date
4	ABRVORG	☑	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
7	PORTION	☐	PORTION	PORTION	CHAR	8	0	Portion	TE420
8	ABRVORG2	☐	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
9	TRIGSTAT	☐	TRIGSTAT	TRIGSTAT	CHAR	1	0	Status of Billing Order
10	ABLEINH	☐	ABLEINH	ABLEINHEIT	CHAR	8	0	Meter reading unit	TE422
11	ADATSOLL	☐	ADATSOLL	DATUM	DATS	8	0	Scheduled meter reading date
12	ABRDATSU	☐	ABRDATSU	DATUM	DATS	8	0	Scheduled billing date for suppressed billing order
13	ABRVORGU	☐	ABRVORGU	ABRVORG	CHAR	2	0	Billing Transaction for a Suppressed Billing Order
14	BEGEND	☐	BEGEND	DATUM	DATS	8	0	Start of period-end billing period
15	SC_BELNR	☐	SC_BELNR	E_BELNR	CHAR	12	0	Number of billing document in adjustment reversal
16	.INCLUDE	☐				0	0	Creation and Change Data
17	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
18	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
20	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	ENDPRIO	☐	ENDPRIO	KENNZX	CHAR	1	0	Priority of Period-End Billing
22	ABSCHLPAN	☐	ABSCHLPAN	KENNZX	CHAR	1	0	Adjust budget billing plan
23	ZUORDDAT	☐	E_ZUORDDATABR	DATUM	DATS	8	0	Allocation date for billing
24	MEM_OPBEL	☐	MEM_OPBEL	MEM_OPBEL	CHAR	12	0	Reversed invoicing document no. for new billing/invoicing
25	MEM_BUDAT	☐	MEM_BUDAT	DATUM	DATS	8	0	Posting Date in the Document
26	ADATSOLLU	☐	ADATSOLLU	DATUM	DATS	8	0	Scheduled MR date of suppressed meter reading order
27	ESTINBILL	☐	ESTINBILL	ESTINBILL	CHAR	2	0	Meter Reading Results are Estimated in Billing
28	ESTINBILLU	☐	ESTINBILLU	ESTINBILL	CHAR	2	0	ESTINBILL of a Suppressed Billing Order
29	ESTINBILL_SAV	☐	ESTINBILL_SAV	ESTINBILL	CHAR	2	0	Original Value from ESTINBILL
30	ESTINBILL_USAV	☐	ESTINBILL_USAV	ESTINBILL	CHAR	2	0	ESTINBILL_SAV of a Suppressed Billing Order
31	OSB_GROUP	☐	E_OSB_GROUP		CHAR	3	0	On-Site Billing Group
32	MAINDOCNO	☐	MAINDOCNO	E_BELNR	CHAR	12	0	Billing Document Number of Primary Installation
33	WAIT_BI	☐	WAIT_BI	WAIT_BI	CHAR	2	0	Billing Sequence Control

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ETRG	ABLEINH	TE422	TERMSCHL		1	CN
2	ETRG	ANLAGE	EANL	MANDT		1	CN
3	ETRG	BUKRS	T001	BUKRS		1	CN
4	ETRG	MANDT	T000	MANDT
5	ETRG	PORTION	TE420	TERMSCHL		1	CN
6	ETRG	SPARTE	TSPA	SPART		1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in