SAP ABAP Table DBERCHV (Consumption History)

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	DBERCHV	Table Relationship Diagram
Short Description	Consumption History

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	LFDNR	☑	LFDNR	LFDNR	CHAR	3	0	Sequence Number
4	ERCHV_ORIG	☐	ORIG_KZ	ORIG_KZ	CHAR	1	0	Indicator: Origin of ERCHV
5	.INCLUDE	☐				0	0	Substructure: Consumption History Lines
6	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
7	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
8	LOGIKZW	☐	LOGIKZW	LOGIKZW	NUMC	18	0	Logical register number
9	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
10	PREISTYP	☐	PREISTYP	PREISTYP	CHAR	1	0	Price category
11	PREIS	☐	E_PREIS	E_PREIS	CHAR	10	0	Price	*
12	MASSBILL	☐	E_MASSBILL	MEINS	UNIT	3	0	Unit of measurement for billing	*
13	ISTABLART	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type	*
14	ISTABLARTVA	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type	*
15	ABLESGR	☐	ABLESGR	ABLESGR	CHAR	2	0	Meter reading reason	*
16	ABLESGRV	☐	ABLESGRV	ABLESGR	CHAR	2	0	Previous meter reading reason	*
17	OPERAND	☐	E_OPERAND	E_OPERAND	CHAR	10	0	Operand	*
18	STTARIF	☐	STTARIF	STTARIFNR	CHAR	10	0	Statistical rate
19	BRENNWTA	☐	BRENNWTA	BRENNWT	DEC	8	6	Calorific value to be billed
20	ZUSTZAHL	☐	E_ZUSZAHL	E_ZUSZAHL	DEC	9	6	Fixed Volume Correction Factor
21	ARTMENGE	☐	ARTMENGE	ARTMENGE	CHAR	1	0	Classification of billed quantity for statistics
22	UMFAKTOR	☐	UMFAKTOR	UMFAKTOR	DEC	17	12	Gas Conversion Factor
23	NETTOBTR	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
24	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency	TCURC
25	ABLBELNR	☐	ABLBELNR	ABLBELNR	CHAR	20	0	Internal ID for meter reading document	*
26	BELZEILE	☐	BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
27	ERCHV_BW_REL	☐	ERCHV_BW_REL	KENNZX	CHAR	1	0	Not Relevant for Consumption History in BW
28	.INCLUDE	☐				0	0
29	SUBINST	☐	SUBINST	ANLAGE	CHAR	10	0	Secondary Installation: Key	*
30	SUBABRDATS	☐	SUBABRDATS	DATUM	DATS	8	0	Scheduled Billing Date of Secondary Installation
31	SUBABRVORG	☐	SUBABRVORG	ABRVORG	CHAR	2	0	Billing Transaction for Secondary Installation
32	.INCLUDE	☐				0	0	Structure for Numeric Fields in ERCHV
33	EZ_ZWSTAND	☐	EZ_ZWSTAND	EZ_ZWSTAND	FLTP	16	16	Meter Reading Recorded
34	EZ_ZWSTNDAB	☐	EZ_ZWSTNDAB	EZ_ZWSTNDAB	FLTP	16	16	Billed Meter Reading
35	EZ_ZWSTVOR	☐	EZ_ZWSTVOR	EZ_ZWSTVOR	FLTP	16	16	Previous Meter Reading
36	EZ_ABRMENGE	☐	EZ_ABRMENGE	EZ_ABRMENGE	FLTP	16	16	Billing Quantity
37	EZ_ZWSTDIFF	☐	EZ_ZWSTDIFF	EZ_ZWSTDIFF	FLTP	16	16	Meter Reading Difference

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DBERCHV	TWAERS	TCURC	WAERS	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in