SAP ABAP Table BIW_ISU_ESTA (BW Extract Structure for IS-U Sales Statistics)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	BIW_ISU_ESTA	Table Relationship Diagram
Short Description	BW Extract Structure for IS-U Sales Statistics

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	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
2	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
3	FIKEY	☐	FIKEY_KK	FIKEY_KK	CHAR	12	0	Reconciliation Key for General Ledger	*
4	BILLINGRUNNO	☐	BILLINGRUNNO	E_BELNR	CHAR	12	0	Number of Billing Run
5	SIMRUNID	☐	SIMRUNID	SIMRUNID	CHAR	8	0	Simulation Period ID	*
6	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
7	XCANC	☐	XCANC	KENNZX	CHAR	1	0	Reversal Transaction: Document Was Reversed
8	.INCLUDE	☐				0	0	BW IS-U Sales Statistics: Transfer Structure - Doc. Header
9	BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
12	GPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
13	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
14	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
15	ABWVK	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	*
16	ABRVORG	☐	ABRVORG	ABRVORG	CHAR	2	0	Billing Transaction
17	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
18	HVORG	☐	HVORG_KK	HVORG_KK	CHAR	4	0	Main Transaction for Line Item	TFKHVO
19	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
20	PORTION	☐	PORTION	PORTION	CHAR	8	0	Portion	TE420
21	KONZVER	☐	KONZVER	KONZVER	CHAR	10	0	Franchise contract	*
22	ABLEINH	☐	ABLEINHEIT	ABLEINHEIT	CHAR	8	0	Meter reading unit	*
23	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	*
24	ZUORDDAA	☐	E_ZUORDDATABR	DATUM	DATS	8	0	Allocation date for billing
25	THGDAT	☐	THGDATUM	DATUM	DATS	8	0	Gas allocation date
26	ANZTAGE	☐	E_ANZTAGE		INT4	10	0	Number of contract days billed
27	ANZVERTR	☐	E_ANZVERTR	DEC3_3V	DEC	6	3	Number of billed contracts
28	CNTINVDOC	☐	E_CNTINVDOC	DEC3_3V	DEC	6	3	Number of Invoicing Documents
29	CNTBILLDOC	☐	E_CNTBILLDOC	DEC3_3V	DEC	6	3	Number of Billing Documents
30	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
31	.INCLUDE	☐				0	0	BW IS-U Sales Statistics: Transfer Structure - Doc. Lines
32	BELZEILE	☐	BELZEILE	LFDNR6	NUMC	6	0	Billing line item for billing documents
33	BELZART	☐	BELZART	BELZART	CHAR	6	0	Line Item Type	TE835
34	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
35	BRANCHE	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
36	TVORG	☐	TVORG_KK	TVORG_KK	CHAR	4	0	Subtransaction for Document Item	TFKTVO
37	SAISON	☐	SAISON	E_OPERAND	CHAR	10	0	Season	*
38	FRAN_TYPE	☐	FRAN_TYPE	FRAN_TYPE	CHAR	1	0	Franchise Fee Category
39	KONZIGR	☐	KONZIGR	KONZIGR	CHAR	10	0	Franchise fee group	TE241
40	OUCONTRACT	☐	OUCONTRACT	VERTRAG	CHAR	10	0	Master Agreement for Individual Contract	*
41	TARIFTYP	☐	TARIFTYP	TARIFTYP	CHAR	10	0	Rate category	ETTA
42	STATTART	☐	STATTART	TARIFART	CHAR	8	0	Rate type for statistical analysis	TE069
43	TARIFNR	☐	TARIFNR	TARIFNR	CHAR	10	0	Rate key	ETRF
44	KONDIGR	☐	KONDIGR	KONDIGR	CHAR	10	0	Rate fact group	TE067
45	STTARIF	☐	STTARIF	STTARIFNR	CHAR	10	0	Statistical rate
46	TEMP_AREA	☐	TEMP_AREA	TEMP_AREA	CHAR	8	0	Temperature area	*
47	DRCKSTUF	☐	DRCKSTUF	DRCKSTUF	CHAR	2	0	Gas pressure level
48	VBRMONAT	☐	CONS_MONTH	BUPER	ACCP	6	0	Consumption Month
49	INTLENGTH	☐	INTLENGTH_MSIM	INTLENGTH_MSIM	CHAR	1	0	Time Period for Update to Business Warehouse
50	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
51	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
52	DIFFKZ	☐	DIFFKZ	KENNZX	CHAR	1	0	Indicator: difference line item for discount statistics
53	BUCHREL	☐	BUCHREL	KENNZX	CHAR	1	0	Billing Line Item Relevant to Posting
54	STGRQNT	☐	STGRQNT	STGRQNT	CHAR	6	0	Quantity statistics group	TE540
55	STGRAMT	☐	STGRAMT	STGRAMT	CHAR	6	0	Amount statistics group	TE541
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	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
60	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
61	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
62	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
63	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
64	MASSBILL	☐	E_MASSBILL	MEINS	UNIT	3	0	Unit of measurement for billing	*
65	BETRAG	☐	NETTOBTR	WRTV7	CURR	13	2	Net amount of billing line item
66	MENGE	☐	E_BILLQUANT	MENGV9	QUAN	17	3	Billing quantity: energy
67	.INCLUDE	☐				0	0	BW IS-U Sales Stats: Transfer Structure - Additional Fields
68	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	EANL
69	ANLART	☐	ANLART	ANLART	CHAR	4	0	Installation type	TE439
70	SPEBENE	☐	SPEBENE	SPEBENE	CHAR	2	0	Voltage Level	TE369
71	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
72	STAGRUVER	☐	E_STGRUV	E_STGRUV	CHAR	2	0	Statistics group for contract	*
73	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
74	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
75	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
76	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
77	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
78	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
79	REGPOLIT	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	*
80	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
81	SERVICEID	☐	SERVICE_PROV	SERVICE_PROV	CHAR	10	0	Service Provider	*
82	SALESEMPLOYEE	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
83	SALESPARTNER	☐	ESALESPARTNER	KUNNR	CHAR	10	0	Sales partners	*
84	SALESDOCUMENT	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
85	CONTRACTCLASS	☐	CONTRACTCLASS	ECONTRACTCLASS	CHAR	4	0	Contract Class	*
86	RULEGR	☐	RULEGR	RULEGR	CHAR	10	0	Rule Group for Outline Agreements	*
87	.INCLUDE	☐				0	0	BW IS-U Sales Statistics:Transfer Struc. of Print Doc. Lines
88	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
89	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
90	STPRZ	☐	STEUERSATZ	CHAR8	CHAR	8	0	Tax rate in output format
91	SBASW	☐	SBASW_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
92	SBETW	☐	SBETW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
93	TXDAT	☐	TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
94	PERIOD	☐	PERIOD_KK	JAMON_XPO	CHAR	7	0	Fiscal Year/Period
95	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_ISU_ESTA	AKLASSE	EAKLASSE	AKLASSE
2	BIW_ISU_ESTA	ANLAGE	EANL	MANDT
3	BIW_ISU_ESTA	ANLART	TE439	ANLART
4	BIW_ISU_ESTA	BELZART	TE835	BELZART
5	BIW_ISU_ESTA	BRANCHE	TB023	IND_SECTOR
6	BIW_ISU_ESTA	BUKRS	T001	BUKRS
7	BIW_ISU_ESTA	BUPLA	J_1BBRANCH	BRANCH	REF
8	BIW_ISU_ESTA	GSBER	TGSB	GSBER
9	BIW_ISU_ESTA	HVORG	TFKHVO	HVORG	KEY
10	BIW_ISU_ESTA	KOFIZ	TE097	KOFIZ	KEY
11	BIW_ISU_ESTA	KONDIGR	TE067	KONDIGR
12	BIW_ISU_ESTA	KONZIGR	TE241	KONZIGR
13	BIW_ISU_ESTA	PERIV	T009	PERIV	REF
14	BIW_ISU_ESTA	PORTION	TE420	TERMSCHL
15	BIW_ISU_ESTA	SPARTE	TSPA	SPART
16	BIW_ISU_ESTA	SPEBENE	TE369	SPEBENE
17	BIW_ISU_ESTA	STATTART	TE069	TARIFART
18	BIW_ISU_ESTA	STGRAMT	TE541	STGRAMT
19	BIW_ISU_ESTA	STGRQNT	TE540	STGRQNT
20	BIW_ISU_ESTA	TARIFNR	ETRF	TARIFNR
21	BIW_ISU_ESTA	TARIFTYP	ETTA	TARIFTYP
22	BIW_ISU_ESTA	TVORG	TFKTVO	TVORG

History

Last changed by/on	SAP	20130529
SAP Release Created in