SAP ABAP Table DBERCHZ (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	TRANSP	Transparent table
Transparent table	DBERCHZ	Table Relationship Diagram
Short Description	Individual Line Items

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in