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
⤷ 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 |