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

Field Description Data Type Length Decimals Checktable Data Element
STAFO Update Group for statistics update CHAR 6 0 STAFO
BUDAT Posting Date in the Document DATS 8 0 BUDAT
FIKEY Reconciliation Key for General Ledger CHAR 12 0 FIKEY_KK
OPBEL Number of print document CHAR 12 0 E_PRINTDOC
XCANC Reversal Transaction: Document Was Reversed CHAR 1 0 XCANC
ERDAT Date on which the record was created DATS 8 0 ERDAT
INTOPBEL Number of Print Document Used to Reverse Document CHAR 12 0 INTOPBEL
BELNR Billing Document Number CHAR 12 0 E_BELNR
BILLRUNNO Number of Billing Run CHAR 12 0 BILLINGRUNNO
BUKRS Company Code CHAR 4 0 T001 BUKRS
SPARTE Division CHAR 2 0 TSPA SPARTE
GPARTNER Business Partner Number CHAR 10 0 BU_PARTNER
VKONT Contract Account Number CHAR 12 0 VKONT_KK
VERTRAG Contract CHAR 10 0 VERTRAG
BELEGDAT Creation Date of Billing Document DATS 8 0 BELEGDAT
ABWVK Alternative Contract Account for Collective Bills CHAR 12 0 * ABWVK_KK
ABRVORG Billing Transaction CHAR 2 0 ABRVORG
01 Periodic Billing (01)
02 Interim Billing (02)
03 Final Billing for Move-Out (03)
04 Period-End Billing (04)
05 Service Territory Transfer (05)
06 Manual Credit Memo/Backbilling (06)
07 Contract Change (07)
08 Customer change (08)
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
KOFIZ Account determination ID for IS-U contracts CHAR 2 0 TE097 E_KOFIZ
PORTION Portion CHAR 8 0 TE420 PORTION
KONZVER Franchise contract CHAR 10 0 KONZVER
ABLEINH Meter Reading Unit CHAR 8 0 TE422 ABLEINHEIT
KTOKLASSE Account Class CHAR 4 0 KONTOKLASSE KTOKLASSE
ZUORDDAA Allocation date for billing DATS 8 0 E_ZUORDDATABR
THGDAT Gas allocation date DATS 8 0 THGDATUM
BELZEILE Billing line item for billing documents NUMC 6 0 BELZEILE
BELZART Line Item Type CHAR 6 0 TE835 BELZART
AKLASSE Billing Class CHAR 4 0 EAKLASSE AKLASSE
BRANCHE Industry sector CHAR 10 0 TB023 BU_INDSECT
TVORG Subtransaction for Document Item CHAR 4 0 TFKTVO TVORG_KK
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
GERAET Device CHAR 18 0 GERAET
MATNR Material Number CHAR 40 0 MARA MATNR
SAISON Season CHAR 10 0 * SAISON
VONZONE From-block NUMC 10 0 VONZONE
BISZONE To-block NUMC 10 0 BISZONE
ZONENNR Number of price block or price scale NUMC 3 0 E_ZONENNR
FRAN_TYPE Franchise Fee Category CHAR 1 0 FRAN_TYPE
No franchise tax
1 franchise tax: customer contribution
2 franchise tax: company contribution
KONZIGR Franchise fee group CHAR 10 0 TE241 KONZIGR
TARIFTYP Rate category CHAR 10 0 ETTA TARIFTYP
STATTART Rate type for statistical analysis CHAR 8 0 TE069 STATTART
TARIFNR Rate key CHAR 10 0 ETRF TARIFNR
KONDIGR Rate fact group CHAR 10 0 TE067 KONDIGR
STTARIF Statistical rate CHAR 10 0 STTARIF
AB Date from which time slice is valid DATS 8 0 ABZEITSCH
BIS Date at Which a Time Slice Expires DATS 8 0 BISZEITSCH
ZUORDDAT Meter reading allocation date DATS 8 0 E_ZUORDDAT
DIFFKZ Indicator: difference line item for discount statistics CHAR 1 0 DIFFKZ
BUCHREL Billing Line Item Relevant to Posting CHAR 1 0 BUCHREL
STGRQNT Quantity statistics group CHAR 6 0 TE540 STGRQNT
STGRAMT Amount statistics group CHAR 6 0 TE541 STGRAMT
TWAERS Transaction Currency CUKY 5 0 TCURC TWAERS
ARTMENGE Classification of billed quantity for statistics CHAR 1 0 ARTMENGE
No special specification
1 Energy
2 Demand
3 Flat rate
4 Rental price
5 Amount without price reference
6 Factor
GSBER Business Area CHAR 4 0 TGSB GSBER
KOSTL Cost Center CHAR 10 0 * KOSTL
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
AUFNR Order Number CHAR 12 0 * AUFNR
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PAOBJNR_S Profitability Segment No. for CO-PA Post. Acc. to Cons. Mth NUMC 10 0 RKEOBJNR_S
NETTOBTR Net amount of billing line item CURR 13 2 NETTOBTR
ARBEITBTR Net amount: energy CURR 13 2 E_NETTOBTR
LEISTBTR Net amount: demand CURR 13 2 D_NETTOBTR
PAUSCHBTR Net amount: flat rate CURR 13 2 F_NETTOBTR
MIETEBTR Net amount: rental price CURR 13 2 R_NETTOBTR
SONSTBTR Net amount: other (amount without price reference) CURR 13 2 S_NETTOBTR
I_ABRMENGE Billing quantity: energy QUAN 17 3 E_BILLQUANT
I_LEIMENGE Billing quantity: demand QUAN 17 3 D_BILLQUANT
MASSBILL Unit of measurement for billing UNIT 3 0 * E_MASSBILL
D_MASSBILL Billing unit of measurement: demand UNIT 3 0 * D_MASSBILL
CITY_CODE City code for city/street file CHAR 12 0 ADRCITY AD_CITYNUM
CITYP_CODE District code for City and Street file CHAR 8 0 ADRCITYPRT AD_CITYPNM
STREETCODE Street Number for City/Street File CHAR 12 0 ADRSTREET AD_STRNUM
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
REGPOLIT Political regional structure element CHAR 8 0 TE227 REGPOLIT
REGIOGROUP Regional structure grouping CHAR 8 0 ADRREGGRP REGIOGROUP
DUMMYFIELD Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
ANLAGE Installation CHAR 10 0 EANL ANLAGE
ANLART Installation type CHAR 4 0 TE439 ANLART
SPEBENE Voltage Level CHAR 2 0 TE369 SPEBENE
EIGENVERBR Plant or company consumption CHAR 1 0 EIGENVERBR
Customer consumption
1 Plant consumption
2 Company consumption

MCVU_ESTA foreign key relationships

Table Field Check Table Check Field
0 MCVU_ESTA ABLEINH TE422 Schedule Master Data for Meter Reading Unit MANDT
1 MCVU_ESTA AKLASSE EAKLASSE IS-U Billing Classes MANDT
1 MCVU_ESTA AKLASSE EAKLASSE IS-U Billing Classes AKLASSE
0 MCVU_ESTA ANLAGE EANL Installation .INCLUDE
0 MCVU_ESTA ANLAGE EANL Installation MANDT
1 MCVU_ESTA ANLART TE439 Installation Type MANDT
1 MCVU_ESTA ANLART TE439 Installation Type ANLART
0 MCVU_ESTA BELZART TE835 Line Item Type MANDT
1 MCVU_ESTA BUKRS T001 Company Codes BUKRS
0 MCVU_ESTA CITYP_CODE ADRCITYPRT Postal districts CLIENT
0 MCVU_ESTA CITYP_CODE ADRCITYPRT Postal districts COUNTRY
0 MCVU_ESTA CITYP_CODE ADRCITYPRT Postal districts CITY_CODE
1 MCVU_ESTA CITY_CODE ADRCITY Postal cities COUNTRY
1 MCVU_ESTA CITY_CODE ADRCITY Postal cities CITY_CODE
0 MCVU_ESTA COUNTRY T005 Countries MANDT
0 MCVU_ESTA COUNTRY T005 Countries LAND1
1 MCVU_ESTA EQUNR EQUI Equipment master data MANDT
0 MCVU_ESTA GSBER TGSB Business Areas MANDT
0 MCVU_ESTA GSBER TGSB Business Areas GSBER
1 MCVU_ESTA HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 MCVU_ESTA HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 MCVU_ESTA KOFIZ TE097 Account Determ. IDs MANDT
0 MCVU_ESTA KOFIZ TE097 Account Determ. IDs BUKRS
0 MCVU_ESTA KOFIZ TE097 Account Determ. IDs KOFIZ
1 MCVU_ESTA KONDIGR TE067 Fact Groups MANDT
1 MCVU_ESTA KONDIGR TE067 Fact Groups KONDIGR
0 MCVU_ESTA KONZIGR TE241 Franchise Tax Groups MANDT
0 MCVU_ESTA KONZIGR TE241 Franchise Tax Groups KONZIGR
1 MCVU_ESTA KTOKLASSE KONTOKLASSE IS-U Account Classes MANDT
1 MCVU_ESTA KTOKLASSE KONTOKLASSE IS-U Account Classes KTOKL
0 MCVU_ESTA MATNR MARA General Material Data MANDT
0 MCVU_ESTA MATNR MARA General Material Data MATNR
1 MCVU_ESTA PORTION TE420 Sch. Mast. Data: Portion MANDT
0 MCVU_ESTA PRCTR CEPC Profit Center Master Data Table PRCTR
0 MCVU_ESTA PRCTR CEPC Profit Center Master Data Table DATBI
0 MCVU_ESTA PRCTR CEPC Profit Center Master Data Table KOKRS
1 MCVU_ESTA REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
0 MCVU_ESTA REGION T005S Taxes: Region (Province) Key LAND1
1 MCVU_ESTA REGPOLIT TE227 Elements of Political Regional Structure MANDT
1 MCVU_ESTA REGPOLIT TE227 Elements of Political Regional Structure COUNTRY
0 MCVU_ESTA SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 MCVU_ESTA SPARTE TSPA Organizational Unit: Sales Divisions SPART
1 MCVU_ESTA SPEBENE TE369 Voltage Level MANDT
1 MCVU_ESTA SPEBENE TE369 Voltage Level SPEBENE
0 MCVU_ESTA STATTART TE069 Rate Types MANDT
1 MCVU_ESTA STGRAMT TE541 Amount Statistics Group MANDT
1 MCVU_ESTA STGRAMT TE541 Amount Statistics Group STGRAMT
0 MCVU_ESTA STGRQNT TE540 Quantity Statistics Group MANDT
0 MCVU_ESTA STGRQNT TE540 Quantity Statistics Group STGRQNT
1 MCVU_ESTA STREETCODE ADRSTREET Streets CLIENT
1 MCVU_ESTA STREETCODE ADRSTREET Streets COUNTRY
1 MCVU_ESTA STREETCODE ADRSTREET Streets STRT_CODE
0 MCVU_ESTA TARIFNR ETRF Rate (Head. Data) MANDT
0 MCVU_ESTA TARIFNR ETRF Rate (Head. Data) TARIFNR
1 MCVU_ESTA TARIFTYP ETTA General Rate Category (Header Data) MANDT
1 MCVU_ESTA TARIFTYP ETTA General Rate Category (Header Data) TARIFTYP
0 MCVU_ESTA TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 MCVU_ESTA TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 MCVU_ESTA TWAERS TCURC Currency Codes MANDT
1 MCVU_ESTA TWAERS TCURC Currency Codes WAERS