SAP ABAP Table CRM_ISU_IL_BI_CONS_OVERVIEW2 (Consumption Overview for Customer Fact Sheet 2)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-IC-IO (Application Component) Utilities Industry: Identification, Overviews
     ⤷ CRM_IU_IL_FCS (Package) Utilities Implementation of Generic Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_ISU_IL_BI_CONS_OVERVIEW2	Table Relationship Diagram
Short Description	Consumption Overview for Customer Fact Sheet 2

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	.INCLUDE	☐				0	0	Print Document for Bill Correction
2	OPBEL	☐	CRM_ISU_E_PRINTDOC	CRM_ISU_E_PRINTDOC	CHAR	12	0	Print Document Number of Invoicing Document
3	DRUCKDAT	☐	CRM_ISU_DRUCKDAT	DATUM	DATS	8	0	Print Date
4	FAEDN	☐	CRM_ISU_FAEDN_KK	DATUM	DATS	8	0	Due Date for Net Payment
5	BUDAT	☐	CRM_ISU_BUDAT	DATUM	DATS	8	0	Posting Date in Document
6	FICA_V	☐	CRM_ISU_FICA_V	CRM_ISU_KENNZX	CHAR	1	0	FI-CA Document Posted
7	TOTAL_AMNT	☐	CRM_ISU_BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency (With +/- Sign)
8	TOTAL_WAER	☐	CRM_ISU_BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	*
9	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
10	VKONT	☐	CRM_ISU_VKONT_KK	CRM_ISU_VKONT_KK	CHAR	12	0	Contract Account Number
11	ABRVORG	☐	CRM_ISU_ABRVORG	CRM_ISU_ABRVORG	CHAR	2	0	Billing Transaction
12	BILLING_PERIOD	☐	CRM_ISU_E_BILLING_PERIOD	CRM_ISU_E_BILLING_PERIOD	CHAR	10	0	Billing Period (such as January 2002)
13	OSB_GROUP	☐	CRM_ISU_E_OSB_GROUP		CHAR	3	0	On-Site Billing Group
14	STOKZ	☐	CRM_ISU_STOKZ	CRM_ISU_KENNZX	CHAR	1	0	Document Has Been Reversed
15	TOBRELEASD	☐	CRM_ISU_TOBRELEASD	CRM_ISU_KENNZX	CHAR	1	0	Indicator: Document Not Released Yet
16	SIMULATED	☐	CRM_ISU_SIMULATED	CRM_ISU_KENNZX	CHAR	1	0	Indicator: Invoicing Generates a Simulated Document
17	INVOICED	☐	CRM_ISU_INVOICED	CRM_ISU_KENNZX	CHAR	1	0	Indicator: Document Posted
18	ERGRD	☐	CRM_ISU_ERGRD	CRM_ISU_ERGRD	CHAR	2	0	Reason for Creating Print Document
19	AMNT_WAER	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
20	STO_BUDAT	☐	CRM_ISU_STO_BUDAT	DATUM	DATS	8	0	Reversal Date of Original Document (Reversal Only)
21	STO_OPBEL	☐	CRM_ISU_STO_OPBEL	CRM_ISU_E_PRINTDOC	CHAR	12	0	Document Number of Original Document (Only for Reversal)
22	ICREASON	☐	CRM_ISU_BCREASON	CRM_ISU_BCREASON	CHAR	2	0	Reason for Reversal
23	TARIFTYP	☐	CRM_ISU_TARIFTYP	CRM_ISU_TARIFTYP	CHAR	10	0	Rate Category
24	TARIF	☐	CRM_ISU_TARIF	CHAR10	CHAR	10	0	Rate
25	ZWKENN	☐	CRM_ISU_E_ZWKENN	CRM_ISU_E_ZWKENN	CHAR	2	0	Register Identification
26	KENNZIFF	☐	CRM_ISU_KENNZIFF	CHAR15	CHAR	15	0	Code for Identifying Register
27	ABRECHNUNGSTAGE	☐	CRM_ISU_ABRECHNUNGSTAGE	CRM_ISU_LFDNR4	NUMC	4	0	Billing Period in Days
28	ANPASSUNGSSTORNO	☐	CRM_ISU_ANPASSUNGSSTORNO	CRM_ISU_ANPASSUNGSSTORNO	CHAR	2	0	Billing Documents in Print Document are Reversed for Adjust.
29	ABLESEGR_TXT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
30	VERTRAGSPARTE_TXT	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
31	I_ZWSTAND_C	☐			CHAR	36	0
32	I_ZWSTNDAB_C	☐			CHAR	36	0
33	I_ZWSTVOR_C	☐			CHAR	36	0
34	I_ABRMENGE_C	☐			CHAR	36	0
35	I_ABRMENGEVOR_C	☐			CHAR	36	0
36	I_ZWSTDIFF_C	☐			CHAR	36	0
37	.INCLUDE	☐				0	0	Document Lines: Internal
38	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
39	BELNR	☐	CRM_ISU_E_BELNR	CRM_ISU_E_BELNR	CHAR	12	0	Billing Document Number
40	LFDNR	☐	CRM_ISU_ERCHVLFDNR		CHAR	6	0	Internal Sequence Number
41	VERTRAG	☐	CRM_ISU_VERTRAG	CRM_ISU_VERTRAG	CHAR	10	0	Contract
42	ANLAGE	☐	CRM_ISU_ANLAGE	CRM_ISU_ANLAGE	CHAR	10	0	Installation
43	SPARTE	☐	CRM_ISU_SPARTE	CRM_ISU_SPART	CHAR	2	0	Division
44	PERIOD	☐	CRM_ISU_E_ZUORDJM	CRM_ISU_JJJJMM	CHAR	6	0	Allocation Year and Month
45	GERAET	☐	CRM_ISU_GERAET	GERNR	CHAR	18	0	Device
46	EQUNR	☐	CRM_ISU_EQUNR	CRM_ISU_EQUNR	CHAR	18	0	Equipment Number
47	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
48	ZWNUMMER	☐	CRM_ISU_E_ZWNUMMER	CRM_ISU_LFDNR3	NUMC	3	0	Register
49	ABRFAKT	☐	CRM_ISU_ABRFAKT	CRM_ISU_ABRFAKT	DEC	12	5	Billing Factor
50	ZWFAKT	☐	CRM_ISU_E_ZWFAKT	CRM_ISU_E_ZWFAKT	DEC	12	5	Register Factor
51	TEMP_AREA	☐	CRM_ISU_TEMP_AREA	CRM_ISU_TEMP_AREA	CHAR	8	0	Temperature Area
52	GEWKEY	☐	CRM_ISU_GEWKEY	CRM_ISU_GEWKEY	CHAR	8	0	Weighting Keys
53	ERCHV_ORIG	☐	CRM_ISU_ORIG_KZ	CRM_ISU_ORIG_KZ	CHAR	1	0	Indicator: Origin of ERCHV
54	LSNO	☐	CRM_ISU_ISU2A_LSNO	NUMC3	NUMC	3	0	Logical Schema Step Number
55	.INCLUDE	☐				0	0	Substructure for Consumption History Lines
56	AB	☐	CRM_ISU_ABZEITSCH	DATUM	DATS	8	0	Date From Which Time Slice Is Valid
57	BIS	☐	CRM_ISU_BISZEITSCH	DATUM	DATS	8	0	Date, Until Which a Time Slice is Valid
58	LOGIKZW	☐	CRM_ISU_LOGIKZW	CRM_ISU_LOGIKZW	NUMC	18	0	Logical Register Number
59	TIMTYP	☐	CRM_ISU_TIMTYP	CRM_ISU_TIMTYP	CHAR	1	0	Time Category (Days or Months)
60	PREISTYP	☐	CRM_ISU_PREISTYP	CRM_ISU_PREISTYP	CHAR	1	0	Price Category
61	PREIS	☐	CRM_ISU_E_PREIS	CRM_ISU_E_PREIS	CHAR	10	0	Price
62	MASSBILL	☐	CRM_ISU_E_MASSBILL	CRM_ISU_E_MASSBILL	UNIT	3	0	Unit of Measurement for Billing
63	ISTABLART	☐	CRM_ISU_ISTABLART	CRM_ISU_ISTABLART	CHAR	2	0	Meter Reading Type
64	ISTABLARTVA	☐	CRM_ISU_ISTABLART	CRM_ISU_ISTABLART	CHAR	2	0	Meter Reading Type
65	ABLESGR	☐	CRM_ISU_ABLESGR	CRM_ISU_ABLESGR	CHAR	2	0	Meter Reading Reason
66	ABLESGRV	☐	CRM_ISU_ABLESGRV	CRM_ISU_ABLESGR	CHAR	2	0	Reason for Previous Meter Reading
67	OPERAND	☐	CRM_ISU_E_OPERAND	CRM_ISU_E_OPERAND	CHAR	10	0	Operand
68	STTARIF	☐	CRM_ISU_STTARIF	CRM_ISU_STTARIFNR	CHAR	10	0	Statistical Rate
69	BRENNWTA	☐	CRM_ISU_BRENNWTA	CRM_ISU_BRENNWT	DEC	8	6	Calorific Value to be Billed
70	ZUSTZAHL	☐	CRM_ISU_E_ZUSZAHL	CRM_ISU_E_ZUSZAHL	DEC	9	6	Fixed Volume Correction Factor
71	ARTMENGE	☐	CRM_ISU_ARTMENGE	CRM_ISU_ARTMENGE	CHAR	1	0	Classification of Billed Quantity for Statistics
72	UMFAKTOR	☐	CRM_ISU_UMFAKTOR	CRM_ISU_UMFAKTOR	DEC	17	12	Conversion Factor for Gas
73	NETTOBTR	☐	CRM_ISU_NETTOBTR	WRTV7	CURR	13	2	Net Amount of Bill Line
74	TWAERS	☐	CRM_ISU_TWAERS	WAERS	CUKY	5	0	Transaction Currency	*
75	ABLBELNR	☐	CRM_ISU_ABLBELNR	CRM_ISU_ABLBELNR	CHAR	20	0	Internal ID of Meter Reading Document
76	BELZEILE	☐	CRM_ISU_BELZEILE	CRM_ISU_LFDNR6	NUMC	6	0	Billing Line Item for Billing Documents
77	ERCHV_BW_REL	☐	CRM_ISU_ERCHV_BW_REL	CRM_ISU_KENNZX	CHAR	1	0	Not Relevant for Consumption History in BW
78	.INCLUDE	☐				0	0	Substructure for Numerical Fields ERCHV
79	I_ZWSTAND	☐	CRM_ISU_I_ZWSTAND	CRM_ISU_I_ZWSTAND	DEC	31	14	Meter Reading Taken
80	I_ZWSTNDAB	☐	CRM_ISU_I_ZWSTNDAB	CRM_ISU_I_ZWSTAND	DEC	31	14	Billed Meter Reading
81	I_ZWSTVOR	☐	CRM_ISU_I_ZWSTVOR	CRM_ISU_I_ZWSTAND	DEC	31	14	Previous Meter Reading
82	I_ABRMENGE	☐	CRM_ISU_I_ABRMENGE	CRM_ISU_I_ZWSTAND	DEC	31	14	Billing Quantity for Internal Billing Format
83	I_ABRMENGEVOR	☐	CRM_ISU_I_ABRMENGEVOR	CRM_ISU_I_ZWSTAND	DEC	31	14	Billing Quantity in Previous Internal Billing Format
84	I_ZWSTDIFF	☐	CRM_ISU_I_ZWSTDIFF	CRM_ISU_I_ZWSTAND	DEC	31	14	Counter Reading Difference in Internal Format

History

Last changed by/on	SAP	20130604
SAP Release Created in	400