SAP ABAP Table MCVU_ESTA (IS-U Sales Statistics: LIS Initial Interface)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IS-ST (Application Component) Statistics
     ⤷ EE70 (Package) IS-U: Statistics

Basic Data

Table Category	INTTAB	Structure
Structure	MCVU_ESTA	Table Relationship Diagram
Short Description	IS-U Sales Statistics: LIS Initial Interface

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	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
2	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
3	FIKEY	☐	FIKEY_KK	FIKEY_KK	CHAR	12	0	Reconciliation Key for General Ledger	*
4	OPBEL	☐	E_PRINTDOC	E_PRINTDOC	CHAR	12	0	Number of print document	*
5	XCANC	☐	XCANC	KENNZX	CHAR	1	0	Reversal Transaction: Document Was Reversed
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	INTOPBEL	☐	INTOPBEL	E_PRINTDOC	CHAR	12	0	Number of Print Document Used to Reverse Document	*
8	.INCLUDE	☐				0	0	IS-U Sales Statistics: Transfer Struc. - Doc. Header
9	BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
10	BILLRUNNO	☐	BILLINGRUNNO	E_BELNR	CHAR	12	0	Number of Billing Run
11	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
12	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
13	GPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
14	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
15	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
16	BELEGDAT	☐	BELEGDAT	DATUM	DATS	8	0	Creation date of billing document
17	ABWVK	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	*
18	ABRVORG	☐	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
19	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
20	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
21	PORTION	☐	PORTION	PORTION	CHAR	8	0	Portion	TE420
22	KONZVER	☐	KONZVER	KONZVER	CHAR	10	0	Franchise contract	*
23	ABLEINH	☐	ABLEINHEIT	ABLEINHEIT	CHAR	8	0	Meter reading unit	TE422
24	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	KONTOKLASSE
25	ZUORDDAA	☐	E_ZUORDDATABR	DATUM	DATS	8	0	Allocation date for billing
26	THGDAT	☐	THGDATUM	DATUM	DATS	8	0	Gas allocation date
27	.INCLUDE	☐				0	0
28	.INCLUDE	☐				0	0	IS-U Sales Statistics: Transfer Struc. - Doc. Lines
29	BELZEILE	☐	BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
30	BELZART	☐	BELZART	BELZART	CHAR	6	0	Line Item Type	TE835
31	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
32	BRANCHE	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
33	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
34	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
35	GERAET	☐	GERAET	GERNR	CHAR	18	0	Device
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
37	SAISON	☐	SAISON	E_OPERAND	CHAR	10	0	Season	*
38	VONZONE	☐	VONZONE	E_ZONE	NUMC	10	0	From-block
39	BISZONE	☐	BISZONE	E_ZONE	NUMC	10	0	To-block
40	ZONENNR	☐	E_ZONENNR	E_ZONENNR	NUMC	3	0	Number of price block or price scale
41	FRAN_TYPE	☐	FRAN_TYPE	FRAN_TYPE	CHAR	1	0	Franchise Fee Category
42	KONZIGR	☐	KONZIGR	KONZIGR	CHAR	10	0	Franchise fee group	TE241
43	TARIFTYP	☐	TARIFTYP	TARIFTYP	CHAR	10	0	Rate category	ETTA
44	STATTART	☐	STATTART	TARIFART	CHAR	8	0	Rate type for statistical analysis	TE069
45	TARIFNR	☐	TARIFNR	TARIFNR	CHAR	10	0	Rate key	ETRF
46	KONDIGR	☐	KONDIGR	KONDIGR	CHAR	10	0	Rate fact group	TE067
47	STTARIF	☐	STTARIF	STTARIFNR	CHAR	10	0	Statistical rate
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	ZUORDDAT	☐	E_ZUORDDAT	DATUM	DATS	8	0	Meter reading allocation date
51	DIFFKZ	☐	DIFFKZ	KENNZX	CHAR	1	0	Indicator: difference line item for discount statistics
52	BUCHREL	☐	BUCHREL	KENNZX	CHAR	1	0	Billing Line Item Relevant to Posting
53	STGRQNT	☐	STGRQNT	STGRQNT	CHAR	6	0	Quantity statistics group	TE540
54	STGRAMT	☐	STGRAMT	STGRAMT	CHAR	6	0	Amount statistics group	TE541
55	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency	TCURC
56	ARTMENGE	☐	ARTMENGE	ARTMENGE	CHAR	1	0	Classification of billed quantity for statistics
57	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
58	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
59	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
60	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
61	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
62	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
63	PAOBJNR_S	☐	RKEOBJNR_S	RKEOBJNR	NUMC	10	0	Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth
64	.INCLUDE	☐				0	0
65	.INCLUDE	☐				0	0	IS-U Sales Statistics: Key Figures
66	NETTOBTR	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
67	ARBEITBTR	☐	E_NETTOBTR	WRTV7	CURR	13	2	Net amount: energy
68	LEISTBTR	☐	D_NETTOBTR	WRTV7	CURR	13	2	Net amount: demand
69	PAUSCHBTR	☐	F_NETTOBTR	WRTV7	CURR	13	2	Net amount: flat rate
70	MIETEBTR	☐	R_NETTOBTR	WRTV7	CURR	13	2	Net amount: rental price
71	SONSTBTR	☐	S_NETTOBTR	WRTV7	CURR	13	2	Net amount: other (amount without price reference)
72	I_ABRMENGE	☐	E_BILLQUANT	MENGV9	QUAN	17	3	Billing quantity: energy
73	I_LEIMENGE	☐	D_BILLQUANT	QKUMMENGE	QUAN	17	3	Billing quantity: demand
74	MASSBILL	☐	E_MASSBILL	MEINS	UNIT	3	0	Unit of measurement for billing	*
75	D_MASSBILL	☐	D_MASSBILL	MEINS	UNIT	3	0	Billing unit of measurement: demand	*
76	.INCLUDE	☐				0	0	IS-U Sales Statistics: Transfer Struc. - Conn. Obj. Address
77	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
78	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
79	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
80	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
81	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
82	REGPOLIT	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	TE227
83	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
84	.INCLUDE	☐				0	0	Cust.-Defined Data from Address
85	DUMMYFIELD	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
86	.INCLUDE	☐				0	0
87	.INCLUDE	☐				0	0	IS-U Sales Stats: Transfer Struc. - Additional Fields
88	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	EANL
89	ANLART	☐	ANLART	ANLART	CHAR	4	0	Installation type	TE439
90	SPEBENE	☐	SPEBENE	SPEBENE	CHAR	2	0	Voltage Level	TE369
91	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
92	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCVU_ESTA	ABLEINH	TE422	TERMSCHL
2	MCVU_ESTA	AKLASSE	EAKLASSE	AKLASSE
3	MCVU_ESTA	ANLAGE	EANL	MANDT
4	MCVU_ESTA	ANLART	TE439	ANLART
5	MCVU_ESTA	BELZART	TE835	BELZART
6	MCVU_ESTA	BRANCHE	TB023	IND_SECTOR
7	MCVU_ESTA	BUKRS	T001	BUKRS
8	MCVU_ESTA	CITYP_CODE	ADRCITYPRT	CITYP_CODE
9	MCVU_ESTA	CITY_CODE	ADRCITY	CITY_CODE
10	MCVU_ESTA	COUNTRY	T005	LAND1
11	MCVU_ESTA	EQUNR	EQUI	EQUNR
12	MCVU_ESTA	GSBER	TGSB	GSBER
13	MCVU_ESTA	HVORG	TFKHVO	HVORG	KEY
14	MCVU_ESTA	KOFIZ	TE097	KOFIZ	KEY
15	MCVU_ESTA	KONDIGR	TE067	KONDIGR
16	MCVU_ESTA	KONZIGR	TE241	KONZIGR
17	MCVU_ESTA	KTOKLASSE	KONTOKLASSE	KTOKL
18	MCVU_ESTA	MATNR	MARA	MATNR
19	MCVU_ESTA	PORTION	TE420	TERMSCHL
20	MCVU_ESTA	PRCTR	CEPC	PRCTR
21	MCVU_ESTA	REGIOGROUP	ADRREGGRP	REGIOGROUP
22	MCVU_ESTA	REGION	T005S	BLAND
23	MCVU_ESTA	REGPOLIT	TE227	REGPOLIT
24	MCVU_ESTA	SPARTE	TSPA	SPART
25	MCVU_ESTA	SPEBENE	TE369	SPEBENE
26	MCVU_ESTA	STATTART	TE069	TARIFART
27	MCVU_ESTA	STGRAMT	TE541	STGRAMT
28	MCVU_ESTA	STGRQNT	TE540	STGRQNT
29	MCVU_ESTA	STREETCODE	ADRSTREET	STRT_CODE
30	MCVU_ESTA	TARIFNR	ETRF	TARIFNR
31	MCVU_ESTA	TARIFTYP	ETTA	TARIFTYP
32	MCVU_ESTA	TVORG	TFKTVO	TVORG
33	MCVU_ESTA	TWAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in