DBERCHV - Consumption History

Consumption History information is stored in SAP table DBERCHV.
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 DBERCHV

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
LFDNR	Sequence Number	X	LFDNR	CHAR	6
ERCHV_ORIG	Indicator: Origin of ERCHV		ORIG_KZ	CHAR	2
.INCLUDE				ERCHV_I	0
AB	Date from which time slice is valid		ABZEITSCH	DATS	16
BIS	Date at Which a Time Slice Expires		BISZEITSCH	DATS	16
LOGIKZW	Logical register number		LOGIKZW	NUMC	36
TIMTYP	Time category (days or months)		TIMTYP	CHAR	2
PREISTYP	Price category		PREISTYP	CHAR	2
PREIS	Price		E_PREIS	CHAR	20
MASSBILL	Unit of measurement for billing		E_MASSBILL	UNIT	6	*
ISTABLART	Meter reading type		ISTABLART	CHAR	4
ISTABLARTVA	Meter reading type		ISTABLART	CHAR	4
ABLESGR	Meter reading reason		ABLESGR	CHAR	4	*
ABLESGRV	Previous meter reading reason		ABLESGRV	CHAR	4	*
OPERAND	Operand		E_OPERAND	CHAR	20
STTARIF	Statistical rate		STTARIF	CHAR	20
BRENNWTA	Calorific value to be billed		BRENNWTA	DEC	5
ARTMENGE	Classification of billed quantity for statistics		ARTMENGE	CHAR	2
UMFAKTOR	Gas Conversion Factor		UMFAKTOR	DEC	9
NETTOBTR	Net amount of billing line item		NETTOBTR	CURR	7
TWAERS	Transaction Currency		TWAERS	CUKY	10	TCURC
ABLBELNR	Internal ID for meter reading document		ABLBELNR	CHAR	40	*
BELZEILE	Billing line item for billing documents		BELZEILE	NUMC	12
ERCHV_BW_REL	Not Relevant for Consumption History in BW		ERCHV_BW_REL	CHAR	2
.INCLUDE				CI_ERCHV	0
SUBINST	Secondary Installation: Key		SUBINST	CHAR	20	*
SUBABRDATS	Scheduled Billing Date of Secondary Installation		SUBABRDATS	DATS	16
SUBABRVORG	Billing Transaction for Secondary Installation		SUBABRVORG	CHAR	4
.INCLUDE				ERCHV_D	0
EZ_ZWSTAND	Meter Reading Recorded		EZ_ZWSTAND	FLTP	8
EZ_ZWSTNDAB	Billed Meter Reading		EZ_ZWSTNDAB	FLTP	8
EZ_ZWSTVOR	Previous Meter Reading		EZ_ZWSTVOR	FLTP	8
EZ_ABRMENGE	Billing Quantity		EZ_ABRMENGE	FLTP	8
EZ_ZWSTDIFF	Meter Reading Difference		EZ_ZWSTDIFF	FLTP	8
.INCLUDE				COLOGRP_INST_I	0
COLOGRP_INST	Colocation group for Installation		E_COLOGRP_INST	CHAR	24