SAP Table MCVU_ESTA
IS-U Sales Statistics: LIS Initial Interface
MCVU_ESTA (IS-U Sales Statistics: LIS Initial Interface) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MCVU_ESTA to other SAP tables.
MCVU_ESTA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STAFO | Update group for statistics update | STAFO | CHAR | 6 | 0 | |||||||||||||||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||||||||||||||
| FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | 0 | |||||||||||||||||||
| OPBEL | Number of print document | E_PRINTDOC | CHAR | 12 | 0 | |||||||||||||||||||
| XCANC | Reversal Transaction: Document Was Reversed | XCANC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||||||
| INTOPBEL | Number of Print Document Used to Reverse Document | INTOPBEL | CHAR | 12 | 0 | |||||||||||||||||||
| BELNR | Number of a billing document | E_BELNR | CHAR | 12 | 0 | |||||||||||||||||||
| BILLRUNNO | Number of Billing Run | BILLINGRUNNO | CHAR | 12 | 0 | |||||||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||
| SPARTE | Division | SPARTE | TSPA | CHAR | 2 | 0 | ||||||||||||||||||
| GPARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||||||||||||||
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | 0 | |||||||||||||||||||
| VERTRAG | Contract | VERTRAG | CHAR | 10 | 0 | |||||||||||||||||||
| BELEGDAT | Creation date of billing document | BELEGDAT | DATS | 8 | 0 | |||||||||||||||||||
| ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | 0 | |||||||||||||||||||
| ABRVORG | Billing Transaction | ABRVORG | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||
| HVORG | Main Transaction for Line Item | HVORG_KK | TFKHVO | CHAR | 4 | 0 | ||||||||||||||||||
| KOFIZ | Account determination ID for IS-U contracts | E_KOFIZ | TE097 | CHAR | 2 | 0 | ||||||||||||||||||
| PORTION | Portion | PORTION | TE420 | CHAR | 8 | 0 | ||||||||||||||||||
| KONZVER | Franchise contract | KONZVER | CHAR | 10 | 0 | |||||||||||||||||||
| ABLEINH | Meter Reading Unit | ABLEINHEIT | TE422 | CHAR | 8 | 0 | ||||||||||||||||||
| KTOKLASSE | Account class | KTOKLASSE | KONTOKLASSE | CHAR | 4 | 0 | ||||||||||||||||||
| ZUORDDAA | Allocation date for billing | E_ZUORDDATABR | DATS | 8 | 0 | |||||||||||||||||||
| THGDAT | Gas allocation date | THGDATUM | DATS | 8 | 0 | |||||||||||||||||||
| BELZEILE | Billing line item for billing documents | BELZEILE | NUMC | 6 | 0 | |||||||||||||||||||
| BELZART | Line Item Type | BELZART | TE835 | CHAR | 6 | 0 | ||||||||||||||||||
| AKLASSE | Billing class | AKLASSE | EAKLASSE | CHAR | 4 | 0 | ||||||||||||||||||
| BRANCHE | Industry sector | BU_INDSECT | TB023 | CHAR | 10 | 0 | ||||||||||||||||||
| TVORG | Subtransaction for Document Item | TVORG_KK | TFKTVO | CHAR | 4 | 0 | ||||||||||||||||||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||||||||||||||
| GERAET | Device | GERAET | CHAR | 18 | 0 | |||||||||||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||
| SAISON | Season | SAISON | CHAR | 10 | 0 | |||||||||||||||||||
| VONZONE | From-block | VONZONE | NUMC | 10 | 0 | |||||||||||||||||||
| BISZONE | To-block | BISZONE | NUMC | 10 | 0 | |||||||||||||||||||
| ZONENNR | Number of price block or price scale | E_ZONENNR | NUMC | 3 | 0 | |||||||||||||||||||
| FRAN_TYPE | Franchise Fee Category | FRAN_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| KONZIGR | Franchise fee group | KONZIGR | TE241 | CHAR | 10 | 0 | ||||||||||||||||||
| TARIFTYP | Rate category | TARIFTYP | ETTA | CHAR | 10 | 0 | ||||||||||||||||||
| STATTART | Rate type for statistical analysis | STATTART | TE069 | CHAR | 8 | 0 | ||||||||||||||||||
| TARIFNR | Rate key | TARIFNR | ETRF | CHAR | 10 | 0 | ||||||||||||||||||
| KONDIGR | Rate fact group | KONDIGR | TE067 | CHAR | 10 | 0 | ||||||||||||||||||
| STTARIF | Statistical rate | STTARIF | CHAR | 10 | 0 | |||||||||||||||||||
| AB | Date from which time slice is valid | ABZEITSCH | DATS | 8 | 0 | |||||||||||||||||||
| BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | 0 | |||||||||||||||||||
| ZUORDDAT | Meter reading allocation date | E_ZUORDDAT | DATS | 8 | 0 | |||||||||||||||||||
| DIFFKZ | Indicator: difference line item for discount statistics | DIFFKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| BUCHREL | Billing Line Item Relevant to Posting | BUCHREL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| STGRQNT | Quantity statistics group | STGRQNT | TE540 | CHAR | 6 | 0 | ||||||||||||||||||
| STGRAMT | Amount statistics group | STGRAMT | TE541 | CHAR | 6 | 0 | ||||||||||||||||||
| TWAERS | Transaction Currency | TWAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||||
| ARTMENGE | Classification of billed quantity for statistics | ARTMENGE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||||||||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||||||||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||||||||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | 0 | |||||||||||||||||||
| AUFNR | Order Number | AUFNR | CHAR | 12 | 0 | |||||||||||||||||||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | 0 | |||||||||||||||||||
| PAOBJNR_S | Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth | RKEOBJNR_S | NUMC | 10 | 0 | |||||||||||||||||||
| NETTOBTR | Net amount of billing line item | NETTOBTR | CURR | 13 | 2 | |||||||||||||||||||
| ARBEITBTR | Net amount: energy | E_NETTOBTR | CURR | 13 | 2 | |||||||||||||||||||
| LEISTBTR | Net amount: demand | D_NETTOBTR | CURR | 13 | 2 | |||||||||||||||||||
| PAUSCHBTR | Net amount: flat rate | F_NETTOBTR | CURR | 13 | 2 | |||||||||||||||||||
| MIETEBTR | Net amount: rental price | R_NETTOBTR | CURR | 13 | 2 | |||||||||||||||||||
| SONSTBTR | Net amount: other (amount without price reference) | S_NETTOBTR | CURR | 13 | 2 | |||||||||||||||||||
| I_ABRMENGE | Billing quantity: energy | E_BILLQUANT | QUAN | 17 | 3 | |||||||||||||||||||
| I_LEIMENGE | Billing quantity: demand | D_BILLQUANT | QUAN | 17 | 3 | |||||||||||||||||||
| MASSBILL | Unit of measurement for billing | E_MASSBILL | UNIT | 3 | 0 | |||||||||||||||||||
| D_MASSBILL | Billing unit of measurement: demand | D_MASSBILL | UNIT | 3 | 0 | |||||||||||||||||||
| CITY_CODE | City code for city/street file | AD_CITYNUM | ADRCITY | CHAR | 12 | 0 | ||||||||||||||||||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | ADRCITYPRT | CHAR | 8 | 0 | ||||||||||||||||||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | ADRSTREET | CHAR | 12 | 0 | ||||||||||||||||||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||||||||||||
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||||||||||||
| REGPOLIT | Political regional structure element | REGPOLIT | TE227 | CHAR | 8 | 0 | ||||||||||||||||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 | 0 | ||||||||||||||||||
| DUMMYFIELD | Indicators | KENNZX | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| ANLAGE | Installation | ANLAGE | EANL | CHAR | 10 | 0 | ||||||||||||||||||
| ANLART | Installation type | ANLART | TE439 | CHAR | 4 | 0 | ||||||||||||||||||
| SPEBENE | Voltage Level | SPEBENE | TE369 | CHAR | 2 | 0 | ||||||||||||||||||
| EIGENVERBR | Plant or company consumption | EIGENVERBR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
MCVU_ESTA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MCVU_ESTA | ABLEINH | SY | MANDT | TE422 | Schedule Master Data for Meter Reading Unit | MANDT |
| MCVU_ESTA | ABLEINH | MCVU_ESTA | ABLEINH | TE422 | Schedule Master Data for Meter Reading Unit | TERMSCHL |
| MCVU_ESTA | AKLASSE | SY | MANDT | EAKLASSE | IS-U Billing Classes | MANDT |
| MCVU_ESTA | AKLASSE | MCVU_ESTA | AKLASSE | EAKLASSE | IS-U Billing Classes | AKLASSE |
| MCVU_ESTA | ANLAGE | SY | MANDT | EANL | Installation | .INCLUDE |
| MCVU_ESTA | ANLAGE | MCVU_ESTA | ANLAGE | EANL | Installation | MANDT |
| MCVU_ESTA | ANLART | SY | MANDT | TE439 | Installation Type | MANDT |
| MCVU_ESTA | ANLART | MCVU_ESTA | ANLART | TE439 | Installation Type | ANLART |
| MCVU_ESTA | BELZART | SY | MANDT | TE835 | Line Item Type | MANDT |
| MCVU_ESTA | BELZART | MCVU_ESTA | BELZART | TE835 | Line Item Type | BELZART |
| MCVU_ESTA | BRANCHE | SY | MANDT | TB023 | BP industries (Obsolete ==> TB038A) | CLIENT |
| MCVU_ESTA | BRANCHE | MCVU_ESTA | BRANCHE | TB023 | BP industries (Obsolete ==> TB038A) | IND_SECTOR |
| MCVU_ESTA | BUKRS | SY | MANDT | T001 | Company Codes | MANDT |
| MCVU_ESTA | BUKRS | MCVU_ESTA | BUKRS | T001 | Company Codes | BUKRS |
| MCVU_ESTA | CITYP_CODE | MCVU_ESTA | CITY_CODE | ADRCITYPRT | Postal districts | CITY_CODE |
| MCVU_ESTA | CITYP_CODE | MCVU_ESTA | CITYP_CODE | ADRCITYPRT | Postal districts | CITYP_CODE |
| MCVU_ESTA | CITYP_CODE | SY | MANDT | ADRCITYPRT | Postal districts | CLIENT |
| MCVU_ESTA | CITYP_CODE | MCVU_ESTA | COUNTRY | ADRCITYPRT | Postal districts | COUNTRY |
| MCVU_ESTA | CITY_CODE | SY | MANDT | ADRCITY | Postal cities | CLIENT |
| MCVU_ESTA | CITY_CODE | MCVU_ESTA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| MCVU_ESTA | CITY_CODE | MCVU_ESTA | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| MCVU_ESTA | COUNTRY | SY | MANDT | T005 | Countries | MANDT |
| MCVU_ESTA | COUNTRY | MCVU_ESTA | COUNTRY | T005 | Countries | LAND1 |
| MCVU_ESTA | EQUNR | MCVU_ESTA | EQUNR | EQUI | Equipment master data | EQUNR |
| MCVU_ESTA | EQUNR | SY | MANDT | EQUI | Equipment master data | MANDT |
| MCVU_ESTA | GSBER | SY | MANDT | TGSB | Business Areas | MANDT |
| MCVU_ESTA | GSBER | MCVU_ESTA | GSBER | TGSB | Business Areas | GSBER |
| MCVU_ESTA | HVORG | 'R' | TFKHVO | Main transactions in contract accts receivable and payable | APPLK | |
| MCVU_ESTA | HVORG | MCVU_ESTA | HVORG | TFKHVO | Main transactions in contract accts receivable and payable | HVORG |
| MCVU_ESTA | HVORG | SY | MANDT | TFKHVO | Main transactions in contract accts receivable and payable | MANDT |
| MCVU_ESTA | KOFIZ | MCVU_ESTA | KOFIZ | TE097 | Account Determ. IDs | KOFIZ |
| MCVU_ESTA | KOFIZ | SY | MANDT | TE097 | Account Determ. IDs | MANDT |
| MCVU_ESTA | KOFIZ | MCVU_ESTA | BUKRS | TE097 | Account Determ. IDs | BUKRS |
| MCVU_ESTA | KOFIZ | MCVU_ESTA | SPARTE | TE097 | Account Determ. IDs | SPARTE |
| MCVU_ESTA | KONDIGR | MCVU_ESTA | KONDIGR | TE067 | Fact Groups | KONDIGR |
| MCVU_ESTA | KONDIGR | SY | MANDT | TE067 | Fact Groups | MANDT |
| MCVU_ESTA | KONZIGR | MCVU_ESTA | KONZIGR | TE241 | Franchise Tax Groups | KONZIGR |
| MCVU_ESTA | KONZIGR | SY | MANDT | TE241 | Franchise Tax Groups | MANDT |
| MCVU_ESTA | KTOKLASSE | SY | MANDT | KONTOKLASSE | IS-U Acc. Classes | MANDT |
| MCVU_ESTA | KTOKLASSE | MCVU_ESTA | KTOKLASSE | KONTOKLASSE | IS-U Acc. Classes | KTOKL |
| MCVU_ESTA | MATNR | SY | MANDT | MARA | General Material Data | MANDT |
| MCVU_ESTA | MATNR | MCVU_ESTA | MATNR | MARA | General Material Data | MATNR |
| MCVU_ESTA | PORTION | SY | MANDT | TE420 | Sch. Mast. Data: Portion | MANDT |
| MCVU_ESTA | PORTION | MCVU_ESTA | PORTION | TE420 | Sch. Mast. Data: Portion | TERMSCHL |
| MCVU_ESTA | PRCTR | SYST | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| MCVU_ESTA | PRCTR | MCVU_ESTA | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| MCVU_ESTA | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| MCVU_ESTA | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| MCVU_ESTA | REGIOGROUP | SY | MANDT | ADRREGGRP | Regional structure grouping | CLIENT |
| MCVU_ESTA | REGIOGROUP | MCVU_ESTA | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
| MCVU_ESTA | REGION | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| MCVU_ESTA | REGION | MCVU_ESTA | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| MCVU_ESTA | REGION | MCVU_ESTA | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| MCVU_ESTA | REGPOLIT | SY | MANDT | TE227 | Elements of Political Regional Structure | MANDT |
| MCVU_ESTA | REGPOLIT | MCVU_ESTA | COUNTRY | TE227 | Elements of Political Regional Structure | COUNTRY |
| MCVU_ESTA | REGPOLIT | MCVU_ESTA | REGPOLIT | TE227 | Elements of Political Regional Structure | REGPOLIT |
| MCVU_ESTA | SPARTE | SY | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| MCVU_ESTA | SPARTE | MCVU_ESTA | SPARTE | TSPA | Organizational Unit: Sales Divisions | SPART |
| MCVU_ESTA | SPEBENE | SY | MANDT | TE369 | Voltage Level | MANDT |
| MCVU_ESTA | SPEBENE | MCVU_ESTA | SPEBENE | TE369 | Voltage Level | SPEBENE |
| MCVU_ESTA | STATTART | SY | MANDT | TE069 | Rate Types | MANDT |
| MCVU_ESTA | STATTART | MCVU_ESTA | STATTART | TE069 | Rate Types | TARIFART |
| MCVU_ESTA | STGRAMT | SY | MANDT | TE541 | Amount Statistics Group | MANDT |
| MCVU_ESTA | STGRAMT | MCVU_ESTA | STGRAMT | TE541 | Amount Statistics Group | STGRAMT |
| MCVU_ESTA | STGRQNT | SY | MANDT | TE540 | Quantity Statistics Group | MANDT |
| MCVU_ESTA | STGRQNT | MCVU_ESTA | STGRQNT | TE540 | Quantity Statistics Group | STGRQNT |
| MCVU_ESTA | STREETCODE | MCVU_ESTA | COUNTRY | ADRSTREET | Streets | COUNTRY |
| MCVU_ESTA | STREETCODE | MCVU_ESTA | STREETCODE | ADRSTREET | Streets | STRT_CODE |
| MCVU_ESTA | STREETCODE | SY | MANDT | ADRSTREET | Streets | CLIENT |
| MCVU_ESTA | TARIFNR | SY | MANDT | ETRF | Rate (Head. Data) | MANDT |
| MCVU_ESTA | TARIFNR | MCVU_ESTA | TARIFNR | ETRF | Rate (Head. Data) | TARIFNR |
| MCVU_ESTA | TARIFTYP | SY | MANDT | ETTA | General Rate Category (Header Data) | MANDT |
| MCVU_ESTA | TARIFTYP | MCVU_ESTA | TARIFTYP | ETTA | General Rate Category (Header Data) | TARIFTYP |
| MCVU_ESTA | TVORG | MCVU_ESTA | TVORG | TFKTVO | Sub-transactions in Contract Accounts Receivable and Payable | TVORG |
| MCVU_ESTA | TVORG | SY | MANDT | TFKTVO | Sub-transactions in Contract Accounts Receivable and Payable | MANDT |
| MCVU_ESTA | TVORG | 'R' | TFKTVO | Sub-transactions in Contract Accounts Receivable and Payable | APPLK | |
| MCVU_ESTA | TVORG | MCVU_ESTA | HVORG | TFKTVO | Sub-transactions in Contract Accounts Receivable and Payable | HVORG |
| MCVU_ESTA | TWAERS | SY | MANDT | TCURC | Currency Codes | MANDT |
| MCVU_ESTA | TWAERS | MCVU_ESTA | TWAERS | TCURC | Currency Codes | WAERS |
