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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ERCHZ_II_REA16	ABLESGR	TE609	ABLESGR
2	ERCHZ_II_REA16	ABLESGRV	TE609	ABLESGR
3	ERCHZ_II_REA16	ABLHINW	TE259	ABLHINW
4	ERCHZ_II_REA16	AKLASSE	EAKLASSE	AKLASSE
5	ERCHZ_II_REA16	AUFNR	AUFK	AUFNR
6	ERCHZ_II_REA16	BELZART	TE835	BELZART	KEY
7	ERCHZ_II_REA16	BETRART	TE497	BETRART	KEY
8	ERCHZ_II_REA16	BILLTYPE	TEWABILLTYPE	BILLTYPE
9	ERCHZ_II_REA16	BRANCHE	TB038A	IND_SECTOR
10	ERCHZ_II_REA16	EQUNR	EQUI	EQUNR
11	ERCHZ_II_REA16	ERMWSKZ	TE011	ERMWSKZ
12	ERCHZ_II_REA16	GEGEN_TVORG	TFKTVO	TVORG
13	ERCHZ_II_REA16	GEWKEY	TE266	GEWKEY	KEY
14	ERCHZ_II_REA16	GSBER	TGSB	GSBER
15	ERCHZ_II_REA16	KONDIGR	TE067	KONDIGR	KEY
16	ERCHZ_II_REA16	KONZIGR	TE241	KONZIGR	KEY
17	ERCHZ_II_REA16	KOSTL	CSKS	KOSTL
18	ERCHZ_II_REA16	LINESORT	TE530	LINESORT	KEY
19	ERCHZ_II_REA16	LINE_CLASS	TE552	LINE_CLASS
20	ERCHZ_II_REA16	MASS1	T006	MSEHI	KEY
21	ERCHZ_II_REA16	MASS2	T006	MSEHI	KEY
22	ERCHZ_II_REA16	MASS3	T006	MSEHI	KEY
23	ERCHZ_II_REA16	MASS4	T006	MSEHI	KEY
24	ERCHZ_II_REA16	MASS5	T006	MSEHI	KEY
25	ERCHZ_II_REA16	MASS6	T006	MSEHI	KEY
26	ERCHZ_II_REA16	MASSBILL	T006	MSEHI	KEY
27	ERCHZ_II_REA16	MATNR	MARA	MATNR
28	ERCHZ_II_REA16	MWSKZ	T007A	MWSKZ
29	ERCHZ_II_REA16	PRCTR	CEPC	PRCTR
30	ERCHZ_II_REA16	PREIGKL	EPRESCL	PREIGKL
31	ERCHZ_II_REA16	PREISTUF	TE471	PREISTUF	KEY
32	ERCHZ_II_REA16	PROGRAMM	TE313	PROGRAMM
33	ERCHZ_II_REA16	PS_PSP_PNR	PRPS	PSPNR
34	ERCHZ_II_REA16	RABZUS	EDSC	RABZUS
35	ERCHZ_II_REA16	SAISON	TE221	OPERAND
36	ERCHZ_II_REA16	STATTART	TE069	TARIFART
37	ERCHZ_II_REA16	STGRAMT	TE541	STGRAMT
38	ERCHZ_II_REA16	STGRQNT	TE540	STGRQNT
39	ERCHZ_II_REA16	TEMP_AREA	TE307	TEMP_AREA	KEY
40	ERCHZ_II_REA16	TEXTSP	T002	SPRAS
41	ERCHZ_II_REA16	TIMECONTRL	TE432	TIMECONTRL
42	ERCHZ_II_REA16	TVORG	TFKTVO	TVORG
43	ERCHZ_II_REA16	TWAERS	TCURC	WAERS	KEY
44	ERCHZ_II_REA16	WAERSF	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	462