SAP ABAP Table CRM_ISU_IL_BI_CONS_OVERVIEW_UI (Sequence No. + Attributes of Consumption Overview from IS-U)

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_OVERVIEW_UI	Table Relationship Diagram
Short Description	Sequence No. + Attributes of Consumption Overview from IS-U

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


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