SAP ABAP Table ERCHZ_I_REA16X (Substructure for Individual Line Items)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-BI (Application Component) Contract Billing
     ⤷ EE20 (Package) IS-U: Billing

Basic Data

Table Category	INTTAB	Structure
Structure	ERCHZ_I_REA16X	Table Relationship Diagram
Short Description	Substructure for Individual Line Items

Delivery and Maintenance

Pool/cluster
Delivery Class
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	CSNO	☐	CSNO	LFDSCHEM	NUMC	6	0	Sequence number of schema step during billing
2	BELZART	☐	BELZART	BELZART	CHAR	6	0	Line Item Type	TE835
3	ABSLKZ	☐	ABSLKZ	KENNZX	CHAR	1	0	Billing Line Item for Budget Billing Amount Determination
4	DIFFKZ	☐	DIFFKZ	KENNZX	CHAR	1	0	Indicator: difference line item for discount statistics
5	BUCHREL	☐	BUCHREL	KENNZX	CHAR	1	0	Billing Line Item Relevant to Posting
6	MENGESTREL	☐	MENGESTREL	MENGREL	CHAR	1	0	Quantity (billed value) is statistically relevant
7	BETRSTREL	☐	BETRSTREL	KENNZX	CHAR	1	0	Amount of billing line item is statistically relevant
8	PRINTREL	☐	PRINTREL	KENNZX	CHAR	1	0	Billing Line Is Print-Relevant
9	BRUTTOZEILE	☐	BRUTTOZEILE	KENNZX	CHAR	1	0	Blling line item is a gross line item
10	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	*
11	BRANCHE	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
12	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	*
13	GEGEN_TVORG	☐	GEGEN_TVORG	TVORG_KK	CHAR	4	0	Offsetting trans. for sub-transaction of billing line item	TFKTVO
14	LINESORT	☐	LINESORT	LINESORT	CHAR	4	0	Presorting of billing line items in billing schema	TE530
15	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
16	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
17	ZEITANT	☐	E_ZEITANT	E_ZEITANT	DEC	8	4	Time portion, billing period in days or months
18	TIMTYPZA	☐	TIMTYPZA	TIMTYP	CHAR	1	0	Time category (days or months) for billing line item
19	SCHEMANR	☐	SCHEMANR	SCHEMANR	CHAR	10	0	Number of the billing schema	*
20	SNO	☐	SNO	LFDNR4	NUMC	4	0	Sequence number of schema step in billing schema
21	PROGRAMM	☐	E_PROGRAMM	E_PROGRAMM	CHAR	8	0	Variant program	*
22	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
23	GERAET	☐	GERAET	GERNR	CHAR	18	0	Device
24	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
25	ZWNUMMER	☐	E_ZWNUMMER	LFDNR3	NUMC	3	0	Register
26	INDEXNR	☐	INDEXNR	INDEXNR	NUMC	12	0	Consecutive number of register relationship
27	MASSBILL	☐	E_MASSBILL	MEINS	UNIT	3	0	Unit of measurement for billing	T006
28	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
29	ERMWSKZ	☐	ERMWSKZ	ERMWSKZ	CHAR	2	0	Indicator: Tax Determination Code	*
30	NETTOBTR	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
31	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency	TCURC
32	SAISON	☐	SAISON	E_OPERAND	CHAR	10	0	Season	*
33	PREISTUF	☐	PREISTUF	PREISTUF	CHAR	10	0	Price level	TE471
34	PREISTYP	☐	PREISTYP	PREISTYP	CHAR	1	0	Price category
35	PREIS	☐	E_PREIS	E_PREIS	CHAR	10	0	Price	*
36	PREISZUS	☐	PREISZUS	KENNZ4	CHAR	4	0	Indicator: Price Summary
37	VONZONE	☐	VONZONE	E_ZONE	NUMC	10	0	From-block
38	BISZONE	☐	BISZONE	E_ZONE	NUMC	10	0	To-block
39	ZONENNR	☐	E_ZONENNR	E_ZONENNR	NUMC	3	0	Number of price block or price scale
40	PREISBTR	☐	PRSBTR	PRSBTR	DEC	17	8	Price amount
41	MNGBASIS	☐	MNGBASIS	MNGBASIS	DEC	5	2	Quantity base for amount
42	TIMBASIS	☐	TIMBASIS	TIMBASIS	CHAR	3	0	Time Basis
43	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
44	PREIGKL	☐	PREIGKL	PREIGKL	CHAR	10	0	Price adjustment clause	*
45	URPREIS	☐	URPREIS	PRSBTR	DEC	17	8	Base price to which the price adjustment clause relates
46	PREIADD	☐	PREIADD	PRSBTR	DEC	17	8	Price to be added for price adjustment
47	PREIFAKT	☐	PREIFAKT	PREIFAKT	DEC	12	7	Price adjustment factor
48	OPMULT	☐	OPMULT	KENZX	CHAR	1	0	Addition first
49	FRAN_TYPE	☐	FRAN_TYPE	FRAN_TYPE	CHAR	1	0	Franchise Fee Category
50	KONZIGR	☐	KONZIGR	KONZIGR	CHAR	10	0	Franchise fee group	TE241
51	ABLESGR	☐	ABLESGR	ABLESGR	CHAR	2	0	Meter reading reason	TE609
52	ABLESGRV	☐	ABLESGRV	ABLESGR	CHAR	2	0	Previous meter reading reason	TE609
53	ATIM	☐	ATIM	HHMM	CHAR	4	0	Meter reading time (relevant to billing)
54	ATIMVA	☐	ATIMVA	HHMM	CHAR	4	0	Time of day of previous meter reading
55	ADATMAX	☐	ADATMAX	DATUM	DATS	8	0	Date of maximum meter reading
56	ATIMMAX	☐	ATIMMAX	HHMM	CHAR	4	0	Time of maximum meter reading
57	TARIFTYP	☐	TARIFTYP	TARIFTYP	CHAR	10	0	Rate category	*
58	TARIFNR	☐	TARIFNR	TARIFNR	CHAR	10	0	Rate key	*
59	KONDIGR	☐	KONDIGR	KONDIGR	CHAR	10	0	Rate fact group	TE067
60	STTARIF	☐	STTARIF	STTARIFNR	CHAR	10	0	Statistical rate
61	GEWKEY	☐	GEWKEY	GEWKEY	CHAR	8	0	Weighting key	TE266
62	GEWANTZ	☐	GEWANTZ	GEWANTZ	DEC	17	0	Numerator of weighting portion
63	GEWANTN	☐	GEWANTN	GEWANTN	DEC	17	0	Denominator of weighting portion
64	LEUCHTNR	☐	LEUCHTNR	LEUCHTNR	CHAR	10	0	External lighting number
65	BETRART	☐	BETRART	BETRART	CHAR	4	0	Operation Type for Lighting Unit	TE497
66	WDHFAKT	☐	WDHFAKT	E_FAKTOR	INT4	10	0	Repetition factor for reference values
67	TEMP_AREA	☐	TEMP_AREA	TEMP_AREA	CHAR	8	0	Temperature area	TE307
68	DRCKSTUF	☐	DRCKSTUF	DRCKSTUF	CHAR	2	0	Gas pressure level
69	THGDATUM	☐	THGDATUM	DATUM	DATS	8	0	Gas allocation date
70	ZUORDDAT	☐	E_ZUORDDAT	DATUM	DATS	8	0	Meter reading allocation date
71	SPGRUND	☐	SPGRUND	SPGRUND	CHAR	2	0	Disconnection reason
72	ABGGRND1	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
73	ABGGRND2	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
74	ABGGRND3	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
75	ABGGRND4	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
76	ABGGRND5	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
77	ABGGRND6	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
78	ABGGRND7	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
79	ABGGRND8	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
80	ABGGRND9	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
81	ABGGRND10	☐	ABGGRND	ABGGRND	CHAR	4	0	Reason for proration	*
82	EIN01	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
83	EIN02	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
84	EIN03	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
85	EIN04	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
86	EIN05	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
87	EIN06	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
88	EIN07	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
89	EIN08	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
90	EIN09	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
91	EIN10	☐	EINOPERAND	E_OPERAND	CHAR	10	0	Input operand	*
92	AUS01	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
93	AUS02	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
94	AUS03	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
95	AUS04	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
96	AUS05	☐	AUSOPERAND	E_OPERAND	CHAR	10	0	Output operand	*
97	MASS1	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
98	MASS2	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
99	MASS3	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
100	MASS4	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
101	MASS5	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
102	MASS6	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
103	DATUM1	☐	DATUM	DATUM	DATS	8	0	Date
104	DATUM2	☐	DATUM	DATUM	DATS	8	0	Date
105	TEXTNR	☐	TEXTNR	NUM08	NUMC	8	0	Text Number
106	TEXTSP	☐	TEXTSP	SPRAS	LANG	1	0	Language key in text processing	T002
107	RABZUS	☐	RABZUS	RABZUS	CHAR	10	0	Discount key	*
108	BACKCANC01	☐	BACKCANC01	BACKGROUP	CHAR	4	0	Indicator: reverse backbilling	*
109	BACKCANC02	☐	BACKCANC02	BACKGROUP	CHAR	4	0	Indicator: reverse backbilling	*
110	BACKCANC03	☐	BACKCANC03	BACKGROUP	CHAR	4	0	Indicator: reverse backbilling	*
111	BACKCANC04	☐	BACKCANC04	BACKGROUP	CHAR	4	0	Indicator: reverse backbilling	*
112	BACKCANC05	☐	BACKCANC05	BACKGROUP	CHAR	4	0	Indicator: reverse backbilling	*
113	BACKCANC	☐	BACKCANC	BACKGROUP	CHAR	4	0	Indicator: Reverse Backbilling	*
114	BACKEXEC	☐	BACKEXEC	BACKGROUP	CHAR	4	0	Indicator: allocate backbilling	*
115	BACKDOCNO	☐	BACKDOCNO	E_BELNR	CHAR	12	0	Number of a billing document
116	BACKDOCLINE	☐	BACKDOCLINE	LFDNR6	NUMC	6	0	Billing line item for billing documents
117	LRATESTEP	☐	LRATESTEP	LRATESTEP	NUMC	10	0	Logical Number of Rate Step
118	TXDAT_KK	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
119	REGRELSORT	☐	REGRELSORT	REGRELSORT	NUMC	2	0	Sort help for register relationships during bill printout
120	SC_BELNR	☐	SC_BELNR	E_BELNR	CHAR	12	0	Number of billing document in adjustment reversal
121	PEB	☐	PEB	KENNZX	CHAR	1	0	Indicator: billing line item relates to period-end billing
122	OPLFDNR	☐	OPLFDNR	LFDNR4	NUMC	4	0	Consecutive number of an operand
123	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
124	ARTMENGE	☐	ARTMENGE	ARTMENGE	CHAR	1	0	Classification of billed quantity for statistics
125	STATTART	☐	STATTART	TARIFART	CHAR	8	0	Rate type for statistical analysis	TE069
126	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
127	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
128	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
129	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
130	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
131	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
132	APERIODIC	☐	APERIODIC	KENNZX	CHAR	1	0	Non-Periodic Posting
133	ABLBELNR	☐	ABLBELNR	ABLBELNR	CHAR	20	0	Internal ID for meter reading document	*
134	LOGIKZW	☐	LOGIKZW	LOGIKZW	NUMC	18	0	Logical register number
135	ISTABLART	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type	*
136	ISTABLARTVA	☐	ISTABLARTVA	ISTABLART	CHAR	2	0	Meter reading type of previous meter reading	*
137	EXTPKZ	☐	EXTPKZ	ORIGIN_ESTIM	CHAR	1	0	Simulation indicator for meter reading results
138	REFBELZEILE	☐	REFBELZEILE	LFDNR6	NUMC	6	0	Reference billing line item for billing documents
139	SPERRUNG	☐	SPERRUNG	KENNZX	CHAR	1	0	Time slice is in a disconnection period
140	TIMECONTRL	☐	TIMECONTRL	TIMECONTRL	CHAR	2	0	Period control	*
141	TCNUMTOR	☐	TCNUMTOR	TCNUMTOR	DEC	8	4	Numerator of the time portion in a time slice
142	TCDENOMTOR	☐	TCDENOMTOR	TCDENOMTOR	DEC	8	4	Denominator of the time portion in a time slice
143	TIMTYPQUOT	☐	TIMTYPQUOT	TIMTYP	CHAR	1	0	Time category of meter for time portion of a time slice
144	NETTOFRMD	☐	NETTOFRMD	WRTV7	CURR	13	2	Amount in foreign currency with +/- sign
145	WAERSF	☐	WAERSF	WAERS	CUKY	5	0	Currency key for amount	*
146	UMRECHDAT	☐	UMRECHDAT	UMRECHDAT	DATS	8	0	Conversion Date for Foreign Currency Amount
147	UMRECHKURS	☐	UMRECHKURS	KURSF	DEC	9	5	Exchange rate btwn net amount and foreign currency amount
148	AKTIV	☐	E_AKTIV	E_AKTIV	CHAR	1	0	Meter reading active
149	REFBELZONE	☐	REFBELZONE	LFDNR6	NUMC	6	0	Ref. billing line item for documents resulting from blocking
150	ABLHINW	☐	ABLHINW	ABLHINW	CHAR	4	0	Note from meter reader	*
151	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ERCHZ_I_REA16X	ABLESGR	TE609	ABLESGR
2	ERCHZ_I_REA16X	ABLESGRV	TE609	ABLESGR
3	ERCHZ_I_REA16X	AUFNR	AUFK	AUFNR
4	ERCHZ_I_REA16X	BELZART	TE835	BELZART	KEY
5	ERCHZ_I_REA16X	BETRART	TE497	BETRART	KEY
6	ERCHZ_I_REA16X	BRANCHE	TB023	IND_SECTOR
7	ERCHZ_I_REA16X	GEGEN_TVORG	TFKTVO	TVORG
8	ERCHZ_I_REA16X	GEWKEY	TE266	GEWKEY	KEY
9	ERCHZ_I_REA16X	GSBER	TGSB	GSBER
10	ERCHZ_I_REA16X	KONDIGR	TE067	KONDIGR	KEY
11	ERCHZ_I_REA16X	KONZIGR	TE241	KONZIGR	KEY
12	ERCHZ_I_REA16X	KOSTL	CSKS	KOSTL
13	ERCHZ_I_REA16X	LINESORT	TE530	LINESORT	KEY
14	ERCHZ_I_REA16X	MASS1	T006	MSEHI	KEY
15	ERCHZ_I_REA16X	MASS2	T006	MSEHI	KEY
16	ERCHZ_I_REA16X	MASS3	T006	MSEHI	KEY
17	ERCHZ_I_REA16X	MASS4	T006	MSEHI	KEY
18	ERCHZ_I_REA16X	MASS5	T006	MSEHI	KEY
19	ERCHZ_I_REA16X	MASS6	T006	MSEHI	KEY
20	ERCHZ_I_REA16X	MASSBILL	T006	MSEHI	KEY
21	ERCHZ_I_REA16X	PRCTR	CEPC	PRCTR
22	ERCHZ_I_REA16X	PREISTUF	TE471	PREISTUF	KEY
23	ERCHZ_I_REA16X	PS_PSP_PNR	PRPS	PSPNR
24	ERCHZ_I_REA16X	STATTART	TE069	TARIFART
25	ERCHZ_I_REA16X	TEMP_AREA	TE307	TEMP_AREA	KEY
26	ERCHZ_I_REA16X	TEXTSP	T002	SPRAS
27	ERCHZ_I_REA16X	TWAERS	TCURC	WAERS	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in