I_UtilsInstKeyDateAnalysisC

Key Date - Based Installation Analysis | view: IEINSTKEYDTEANLY | TRAN | Extraction: Not supported | Component: Master Data
Tables used: ADCP, ADRC, IFLOT, ILOA, EVER, EVERH, EANL, EANLH, EVBS
Column Name Description
UtilitiesInstallation FK Installation
Column Name Description
Column Name Description
Column Name Description
Column Name Description
UtilsInstallationIsSuspended Installation Is Not Assigned to a Contract Show values
UtilsInstDvceAllctnIsNotAllwd Device allocation is not possible Show values
Column Name Description Domain name
UtilitiesContract Contract VERTRAG
CityName City TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
AuthorizationGroup Authorization Group BEGRU
NumberOfUtilitiesInstallation Number of Installations
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.COMPANYCODE == T001.BUKRS
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == T001.MANDT
Country key
  • Country/Region Key
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.COUNTRY == T005.LAND1
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == T005.MANDT
Industry
  • Client
  • ?
  • Industry
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TB038A.CLIENT
  • I_UTILSINSTKEYDATEANALYSISC.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
  • I_UTILSINSTKEYDATEANALYSISC.INDUSTRYSECTOR == TB038A.IND_SECTOR
Reason for blocking meter reading
  • Reason for blocking meter reading
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.METERREADINGBLOCKINGREASON == TE119.ABLSPERR
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TE119.MANDT
Meter Reading Unit
  • Meter Reading Unit
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.METERREADINGUNIT == TE422.TERMSCHL
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TE422.MANDT
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.COUNTRY == T005S.LAND1
  • I_UTILSINSTKEYDATEANALYSISC.REGION == T005S.BLAND
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == T005S.MANDT
Billing Class
  • Client
  • Billing Class
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == EAKLASSE.MANDT
  • I_UTILSINSTKEYDATEANALYSISC.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
Installation type
  • Client
  • Installation type
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TE439.MANDT
  • I_UTILSINSTKEYDATEANALYSISC.UTILITIESINSTALLATIONTYPE == TE439.ANLART
Premise
  • Client
  • Premise
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == EVBS.MANDT
  • I_UTILSINSTKEYDATEANALYSISC.UTILITIESPREMISE == EVBS.VSTELLE
Rate Category
  • Client
  • Rate Category
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == ETTA.MANDT
  • I_UTILSINSTKEYDATEANALYSISC.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Service Type
  • Client
  • Service Type
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TECDE.MANDT
  • I_UTILSINSTKEYDATEANALYSISC.UTILITIESSRVCPROVIDERROLE == TECDE.SERVICE
Deregulation status
  • Client
  • Deregulation status
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TEDEREGSTAT.MANDT
  • I_UTILSINSTKEYDATEANALYSISC.UTILSINSTDEREGULATIONSTS == TEDEREGSTAT.DEREGSTAT
Reason for guarantee of supply
  • Reason for guarantee of supply
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.UTILSINSTGUAROFSUPREASON == TE759.NODISCONCT
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TE759.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Division
  • Client
  • I_UTILSINSTKEYDATEANALYSISC.DIVISION == TESPT.SPARTE
  • I_UTILSINSTKEYDATEANALYSISC.MANDT == TESPT.MANDT