SAP ABAP Table ISU_IL_BI_CONS_OVERVIEW (Consumption Overview: Customer Fact Sheet)

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	ISU_IL_BI_CONS_OVERVIEW	Table Relationship Diagram
Short Description	Consumption Overview: Customer Fact Sheet

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	ISU_IL_BI_ERDK	☐	ISU_IL_BI_ERDK		STRU	0	0
2	OPBEL	☐	E_PRINTDOC	E_PRINTDOC	CHAR	12	0	Number of print document
3	DRUCKDAT	☐	DRUCKDAT	DATUM	DATS	8	0	Print Date
4	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
5	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
6	FICA_V	☐	FICA_V	KENNZX	CHAR	1	0	FI-CA Document Posted
7	TOTAL_AMNT	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
8	TOTAL_WAER	☐	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency
9	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
10	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number
11	ABRVORG	☐	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
12	BILLING_PERIOD	☐	E_BILLING_PERIOD	E_BILLING_PERIOD	CHAR	10	0	Billing Key Date (For Example January 2002)
13	OSB_GROUP	☐	E_OSB_GROUP		CHAR	3	0	On-Site Billing Group
14	STOKZ	☐	STOKZ	KENNZX	CHAR	1	0	Document Has Been Reversed
15	TOBRELEASD	☐	TOBRELEASD	KENNZX	CHAR	1	0	Indicator: document not released yet
16	SIMULATED	☐	SIMULATED	KENNZX	CHAR	1	0	Indicator: invoicing generates a simulated document
17	INVOICED	☐	INVOICED	KENNZX	CHAR	1	0	Indicator: document posted
18	ERGRD	☐	ERGRD	ERGRD	CHAR	2	0	Reason for creating print document
19	AMNT_WAER	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
20	STO_BUDAT	☐	STO_BUDAT	DATUM	DATS	8	0	Reversal Date of Original Document (Reversal Only)
21	STO_OPBEL	☐	STO_OPBEL	E_PRINTDOC	CHAR	12	0	Document Number of Original Document (Only for Reversal)
22	ICREASON	☐	BCREASON	BCREASON	CHAR	2	0	Reason for Reversal
23	TARIFTYP	☐	TARIFTYP	TARIFTYP	CHAR	10	0	Rate category	*
24	TARIF	☐	TARIF	CHAR10	CHAR	10	0	Rate
25	ZWKENN	☐	E_ZWKENN	E_ZWKENN	CHAR	2	0	Register identification	*
26	KENNZIFF	☐	KENNZIFF	CHAR15	CHAR	15	0	Code for Identifying a Register
27	ABRECHNUNGSTAGE	☐	ABRECHNUNGSTAGE	LFDNR4	NUMC	4	0	Billing Period in Days
28	ANPASSUNGSSTORNO	☐	ANPASSUNGSSTORNO	ANPASSUNGSSTORNO	CHAR	2	0	Billing documents in print document are reversed for adjust.
29	ERCHV	☐	ERCHV		STRU	0	0
30	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
31	BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
32	LFDNR	☐	ERCHVLFDNR		CHAR	6	0	Internal Consecutive Number
33	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract
34	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation
35	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division
36	PERIOD	☐	E_ZUORDJM	JJJJMM	CHAR	6	0	Allocation year and month
37	GERAET	☐	GERAET	GERNR	CHAR	18	0	Device
38	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number
39	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
40	ZWNUMMER	☐	E_ZWNUMMER	LFDNR3	NUMC	3	0	Register
41	ABRFAKT	☐	ABRFAKT	ABRFAKT	DEC	12	5	Billing factor
42	ZWFAKT	☐	E_ZWFAKT	E_ZWFAKT	DEC	12	5	Register factor
43	TEMP_AREA	☐	TEMP_AREA	TEMP_AREA	CHAR	8	0	Temperature area
44	GEWKEY	☐	GEWKEY	GEWKEY	CHAR	8	0	Weighting key
45	ERCHV_ORIG	☐	ORIG_KZ	ORIG_KZ	CHAR	1	0	Indicator: Origin of ERCHV
46	LSNO	☐	ISU2A_LSNO	NUMC3	NUMC	3	0	Logical Schema Step Number
47	.INCLUDE	☐				0	0	Substructure: Consumption History Lines
48	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
49	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
50	LOGIKZW	☐	LOGIKZW	LOGIKZW	NUMC	18	0	Logical register number
51	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
52	PREISTYP	☐	PREISTYP	PREISTYP	CHAR	1	0	Price category
53	PREIS	☐	E_PREIS	E_PREIS	CHAR	10	0	Price
54	MASSBILL	☐	E_MASSBILL	MEINS	UNIT	3	0	Unit of measurement for billing
55	ISTABLART	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type
56	ISTABLARTVA	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type
57	ABLESGR	☐	ABLESGR	ABLESGR	CHAR	2	0	Meter reading reason
58	ABLESGRV	☐	ABLESGRV	ABLESGR	CHAR	2	0	Previous meter reading reason
59	OPERAND	☐	E_OPERAND	E_OPERAND	CHAR	10	0	Operand
60	STTARIF	☐	STTARIF	STTARIFNR	CHAR	10	0	Statistical rate
61	BRENNWTA	☐	BRENNWTA	BRENNWT	DEC	8	6	Calorific value to be billed
62	ZUSTZAHL	☐	E_ZUSZAHL	E_ZUSZAHL	DEC	9	6	Fixed Volume Correction Factor
63	ARTMENGE	☐	ARTMENGE	ARTMENGE	CHAR	1	0	Classification of billed quantity for statistics
64	UMFAKTOR	☐	UMFAKTOR	UMFAKTOR	DEC	17	12	Gas Conversion Factor
65	NETTOBTR	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
66	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency
67	ABLBELNR	☐	ABLBELNR	ABLBELNR	CHAR	20	0	Internal ID for meter reading document
68	BELZEILE	☐	BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
69	ERCHV_BW_REL	☐	ERCHV_BW_REL	KENNZX	CHAR	1	0	Not Relevant for Consumption History in BW
70	.INCLUDE	☐				0	0
71	SUBINST	☐	SUBINST	ANLAGE	CHAR	10	0	Secondary Installation: Key
72	SUBABRDATS	☐	SUBABRDATS	DATUM	DATS	8	0	Scheduled Billing Date of Secondary Installation
73	SUBABRVORG	☐	SUBABRVORG	ABRVORG	CHAR	2	0	Billing Transaction for Secondary Installation
74	.INCLUDE	☐				0	0	Substructure: Numeric Fields ERCHV
75	I_ZWSTAND	☐	I_ZWSTAND	I_ZWSTAND	DEC	31	14	Meter reading recorded
76	I_ZWSTNDAB	☐	I_ZWSTNDAB	I_ZWSTAND	DEC	31	14	Billed meter reading
77	I_ZWSTVOR	☐	I_ZWSTVOR	I_ZWSTAND	DEC	31	14	Previous meter reading
78	I_ABRMENGE	☐	I_ABRMENGE	I_ABRMENGE	DEC	31	14	Billing quantity for internal billing format
79	I_ABRMENGEVOR	☐	I_ABRMENGEVOR	I_ABRMENGE	DEC	31	14	Billing Quantity: Internal Format of Previous Billing
80	I_ZWSTDIFF	☐	I_ZWSTDIFF	I_ZWSTDIFF	DEC	31	14	Meter reading difference in internal format
81	ALPHNUM	☐	ALPHNUM	KENNZX	CHAR	1	0	Entry with Alphanumeric Key

History

Last changed by/on	SAP	20110901
SAP Release Created in	472