DBERCHZ - Individual Line Items

Individual Line Items information is stored in SAP table DBERCHZ.
It is part of development package EE20 in software component IS-U-BI. This development package consists of objects that can be grouped under "IS-U: Billing".

Fields for table DBERCHZ

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BELNR	Billing Document Number	X	E_BELNR	CHAR	24
BELZEILE	Billing line item for billing documents	X	BELZEILE	NUMC	12
.INCLUDE				ERCHZ_I	0
CSNO	Sequence number of schema step during billing		CSNO	NUMC	12
BELZART	Line Item Type		BELZART	CHAR	12	TE835
ABSLKZ	Billing Line Item for Budget Billing Amount Determination		ABSLKZ	CHAR	2
DIFFKZ	Indicator: difference line item for discount statistics		DIFFKZ	CHAR	2
BUCHREL	Billing Line Item Relevant to Posting		BUCHREL	CHAR	2
MENGESTREL	Quantity (billed value) is statistically relevant		MENGESTREL	CHAR	2
BETRSTREL	Amount of billing line item is statistically relevant		BETRSTREL	CHAR	2
STGRQNT	Quantity statistics group		STGRQNT	CHAR	12	*
STGRAMT	Amount statistics group		STGRAMT	CHAR	12	*
PRINTREL	Billing Line Is Print-Relevant		PRINTREL	CHAR	2
BRUTTOZEILE	Blling line item is a gross line item		BRUTTOZEILE	CHAR	2
AKLASSE	Billing Class		AKLASSE	CHAR	8	*
BRANCHE	Industry sector		BU_INDSECT	CHAR	20	TB023
TVORG	Subtransaction for Document Item		TVORG_KK	CHAR	8	TFKTVO
GEGEN_TVORG	Offsetting trans. for sub-transaction of billing line item		GEGEN_TVORG	CHAR	8	TFKTVO
LINESORT	Presorting of billing line items in billing schema		LINESORT	CHAR	8	TE530
AB	Date from which time slice is valid		ABZEITSCH	DATS	16
BIS	Date at Which a Time Slice Expires		BISZEITSCH	DATS	16
TIMTYPZA	Time category (days or months) for billing line item		TIMTYPZA	CHAR	2
SCHEMANR	Number of the billing schema		SCHEMANR	CHAR	20	*
SNO	Sequence number of schema step in billing schema		SNO	NUMC	8
PROGRAMM	Variant program		E_PROGRAMM	CHAR	16	*
EQUNR	Equipment Number		EQUNR	CHAR	36	*
GERAET	Device		GERAET	CHAR	36
MATNR	Material Number		MATNR	CHAR	80	*
INDEXNR	Consecutive number of register relationship		INDEXNR	NUMC	24
MASSBILL	Unit of measurement for billing		E_MASSBILL	UNIT	6	T006
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
ERMWSKZ	Indicator: Tax Determination Code		ERMWSKZ	CHAR	4	*
NETTOBTR	Net amount of billing line item		NETTOBTR	CURR	7
TWAERS	Transaction Currency		TWAERS	CUKY	10	TCURC
SAISON	Season		SAISON	CHAR	20	*
PREISTUF	Price level		PREISTUF	CHAR	20	TE471
PREISTYP	Price category		PREISTYP	CHAR	2
PREIS	Price		E_PREIS	CHAR	20	*
PREISZUS	Indicator: Price Summary		PREISZUS	CHAR	8
VONZONE	From-block		VONZONE	NUMC	20
BISZONE	To-block		BISZONE	NUMC	20
PREISBTR	Price amount		PRSBTR	DEC	9
MNGBASIS	Quantity base for amount		MNGBASIS	DEC	3
TIMBASIS	Time Basis		TIMBASIS	CHAR	6
TIMTYP	Time category (days or months)		TIMTYP	CHAR	2
PREIGKL	Price adjustment clause		PREIGKL	CHAR	20	*
URPREIS	Base price to which the price adjustment clause relates		URPREIS	DEC	9
PREIADD	Price to be added for price adjustment		PREIADD	DEC	9
PREIFAKT	Price adjustment factor		PREIFAKT	DEC	7
OPMULT	Addition first		OPMULT	CHAR	2
FRAN_TYPE	Franchise Fee Category		FRAN_TYPE	CHAR	2
KONZIGR	Franchise fee group		KONZIGR	CHAR	20	TE241
ABLESGR	Meter reading reason		ABLESGR	CHAR	4	TE609
ABLESGRV	Previous meter reading reason		ABLESGRV	CHAR	4	TE609
ATIM	Meter reading time (relevant to billing)		ATIM	CHAR	8
ATIMVA	Time of day of previous meter reading		ATIMVA	CHAR	8
ADATMAX	Date of maximum meter reading		ADATMAX	DATS	16
ATIMMAX	Time of maximum meter reading		ATIMMAX	CHAR	8
TARIFTYP	Rate category		TARIFTYP	CHAR	20
TARIFNR	Rate key		TARIFNR	CHAR	20
KONDIGR	Rate fact group		KONDIGR	CHAR	20	TE067
STTARIF	Statistical rate		STTARIF	CHAR	20
GEWKEY	Weighting key		GEWKEY	CHAR	16	TE266
GEWANTZ	Numerator of weighting portion		GEWANTZ	DEC	9
GEWANTN	Denominator of weighting portion		GEWANTN	DEC	9
LEUCHTNR	External lighting number		LEUCHTNR	CHAR	20
BETRART	Operation Type for Lighting Unit		BETRART	CHAR	8	TE497
WDHFAKT	Repetition factor for reference values		WDHFAKT	INT4	4
TEMP_AREA	Temperature area		TEMP_AREA	CHAR	16	TE307
DRCKSTUF	Gas pressure level		DRCKSTUF	CHAR	4	*
THGDATUM	Gas allocation date		THGDATUM	DATS	16
SPGRUND	Disconnection reason		SPGRUND	CHAR	4	*
ABGGRND1	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND2	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND3	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND4	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND5	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND6	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND7	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND8	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND9	Reason for proration		ABGGRND	CHAR	8	*
ABGGRND10	Reason for proration		ABGGRND	CHAR	8	*
EIN01	Input operand		EINOPERAND	CHAR	20	*
EIN02	Input operand		EINOPERAND	CHAR	20	*
EIN03	Input operand		EINOPERAND	CHAR	20	*
EIN04	Input operand		EINOPERAND	CHAR	20	*
EIN05	Input operand		EINOPERAND	CHAR	20	*
EIN06	Input operand		EINOPERAND	CHAR	20	*
EIN07	Input operand		EINOPERAND	CHAR	20	*
EIN08	Input operand		EINOPERAND	CHAR	20	*
EIN09	Input operand		EINOPERAND	CHAR	20	*
EIN10	Input operand		EINOPERAND	CHAR	20	*
AUS01	Output operand		AUSOPERAND	CHAR	20	*
AUS02	Output operand		AUSOPERAND	CHAR	20	*
AUS03	Output operand		AUSOPERAND	CHAR	20	*
AUS04	Output operand		AUSOPERAND	CHAR	20	*
AUS05	Output operand		AUSOPERAND	CHAR	20	*
MASS1	Unit of Measurement		E_MASS	UNIT	6	T006
MASS2	Unit of Measurement		E_MASS	UNIT	6	T006
MASS3	Unit of Measurement		E_MASS	UNIT	6	T006
MASS4	Unit of Measurement		E_MASS	UNIT	6	T006
MASS5	Unit of Measurement		E_MASS	UNIT	6	T006
MASS6	Unit of Measurement		E_MASS	UNIT	6	T006
DATUM1	Date		DATUM	DATS	16
DATUM2	Date		DATUM	DATS	16
TEXTNR	Text Number		TEXTNR	NUMC	16
TEXTSP	Language key in text processing		TEXTSP	LANG	2	T002
RABZUS	Discount key		RABZUS	CHAR	20	*
BACKCANC01	Indicator: reverse backbilling		BACKCANC01	CHAR	8	*
BACKCANC02	Indicator: reverse backbilling		BACKCANC02	CHAR	8	*
BACKCANC03	Indicator: reverse backbilling		BACKCANC03	CHAR	8	*
BACKCANC04	Indicator: reverse backbilling		BACKCANC04	CHAR	8	*
BACKCANC05	Indicator: reverse backbilling		BACKCANC05	CHAR	8	*
BACKCANC	Indicator: Reverse Backbilling		BACKCANC	CHAR	8	*
BACKEXEC	Indicator: allocate backbilling		BACKEXEC	CHAR	8	*
BACKDOCNO	Number of a billing document		BACKDOCNO	CHAR	24
BACKDOCLINE	Billing line item for billing documents		BACKDOCLINE	NUMC	12
LRATESTEP	Logical Number of Rate Step		LRATESTEP	NUMC	20
TXDAT_KK	Decisive Date for Calculating Taxes		TXDAT_KK	DATS	16
REGRELSORT	Sort help for register relationships during bill printout		REGRELSORT	NUMC	4
SC_BELNR	Number of billing document in adjustment reversal		SC_BELNR	CHAR	24
PEB	Indicator: billing line item relates to period-end billing		PEB	CHAR	2
OPLFDNR	Consecutive number of an operand		OPLFDNR	NUMC	8
STAFO	Update Group for statistics update		STAFO	CHAR	12	*
ARTMENGE	Classification of billed quantity for statistics		ARTMENGE	CHAR	2
STATTART	Rate type for statistical analysis		STATTART	CHAR	16	TE069
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
KOSTL	Cost Center		KOSTL	CHAR	20	CSKS
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
AUFNR	Order Number		AUFNR	CHAR	24	AUFK
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
PAOBJNR_S	Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth		RKEOBJNR_S	NUMC	20
GSBER	Business Area		GSBER	CHAR	8	TGSB
APERIODIC	Non-Periodic Posting		APERIODIC	CHAR	2
ABLBELNR	Internal ID for meter reading document		ABLBELNR	CHAR	40	*
LOGIKZW	Logical register number		LOGIKZW	NUMC	36
ISTABLART	Meter reading type		ISTABLART	CHAR	4
ISTABLARTVA	Meter reading type of previous meter reading		ISTABLARTVA	CHAR	4
EXTPKZ	Simulation Indicator for Meter Reading Results		EXTPKZ	CHAR	2
BEGPROG	Start of forecast period		BEGPROG	DATS	16
ENDEPROG	End of forecast period		ENDEPROG	DATS	16
REFBELZEILE	Reference billing line item for billing documents		REFBELZEILE	NUMC	12
SPERRUNG	Time slice is in a disconnection period		SPERRUNG	CHAR	2
TIMECONTRL	Period control		TIMECONTRL	CHAR	4	*
TCNUMTOR	Numerator of the time portion in a time slice		TCNUMTOR	DEC	5
TCDENOMTOR	Denominator of the time portion in a time slice		TCDENOMTOR	DEC	5
TIMTYPQUOT	Time category of meter for time portion of a time slice		TIMTYPQUOT	CHAR	2
NETTOFRMD	Amount in foreign currency with +/- sign		NETTOFRMD	CURR	7
WAERSF	Currency key for amount		WAERSF	CUKY	10	*
UMRECHDAT	Conversion Date for Foreign Currency Amount		UMRECHDAT	DATS	16
UMRECHKURS	Exchange rate btwn net amount and foreign currency amount		UMRECHKURS	DEC	5
AKTIV	Meter reading active		E_AKTIV	CHAR	2
REFBELZONE	Ref. billing line item for documents resulting from blocking		REFBELZONE	NUMC	12
ABLHINW	Note from meter reader		ABLHINW	CHAR	8	*
KONZVER	Franchise contract		KONZVER	CHAR	20
REFBILLDOCNO	Reference Document Number		REFBILLDOCNO	CHAR	24
PERTYP	Category of the internal billing period		BILLPERTYP	CHAR	4
.INCLUDE				CI_ERCHZ	0
.INCLUDE				ERCHZ_D	0
V_ZWSTAND	Places Before Decimal Point in Meter Reading		V_ZWSTAND	DEC	9
N_ZWSTAND	Places After Decimal Point in the Meter Reading		N_ZWSTAND	DEC	8
V_ZWSTNDAB	Predecimal Places in Billed Meter Reading		V_ZWSTNDAB	DEC	9
N_ZWSTNDAB	Decimal Places in the Billed Meter Reading		N_ZWSTNDAB	DEC	8
V_ZWSTVOR	Predecimal places in previous meter reading result		V_ZWSTVOR	DEC	9
N_ZWSTVOR	Decimal places in previous meter reading		N_ZWSTVOR	DEC	8
V_ABRMENGE	Places before decimal point in billing quantity		V_ABRMENGE	DEC	9
N_ABRMENGE	Places after decimal point in billing quantity		N_ABRMENGE	DEC	8
V_ZAHL1	Pre-decimal places in a number		V_ZAHL	DEC	9
N_ZAHL1	Decimal places in a number		N_ZAHL	DEC	8
V_ZAHL2	Pre-decimal places in a number		V_ZAHL	DEC	9
N_ZAHL2	Decimal places in a number		N_ZAHL	DEC	8
V_ZAHL3	Pre-decimal places in a number		V_ZAHL	DEC	9
N_ZAHL3	Decimal places in a number		N_ZAHL	DEC	8
V_ZAHL4	Pre-decimal places in a number		V_ZAHL	DEC	9
N_ZAHL4	Decimal places in a number		N_ZAHL	DEC	8
V_ZAHL5	Pre-decimal places in a number		V_ZAHL	DEC	9
N_ZAHL5	Decimal places in a number		N_ZAHL	DEC	8
V_ZAHL6	Pre-decimal places in a number		V_ZAHL	DEC	9
N_ZAHL6	Decimal places in a number		N_ZAHL	DEC	8
V_ZWSTDIFF	Pre-decimal places for the meter reading difference		V_ZWSTDIFF	DEC	9
N_ZWSTDIFF	Decimal places for the meter reading difference		N_ZWSTDIFF	DEC	8
.INCLUDE				COLOGRP_INST_L_I	0
COLOGRP_INST_L	Colocation group for Installation		E_COLOGRP_INST	CHAR	24