SAP ABAP Table BIW_ISU_ESTA_SIM (BW Extract Structure for Mass Simulation (Do not Change!))

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_SIM	Table Relationship Diagram
Short Description	BW Extract Structure for Mass Simulation (Do not Change!)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in