C_UtilsInstKeyDateAnalysisQ

Key Date Installation Analysis Query | view: CEINSTANLYSQ | Extraction: Not supported | Component: Master Data
Tables used: ADCP, ADRC, TSPA, TSPAT, IFLOT, ILOA, TE422, EVER, EVERH, EANL, EANLH, EVBS, ETTA, ETTAT, EAKLASSE, EAKLASSET, TE439, TE439T, TEDEREGSTAT, TEDEREGSTATT, TE759, TE759T, TE119, TE119T, TECDE, TECDET
Column Name Description
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
DivisionName Division Description TEXT20
UtilitiesBillingClassName Billing Class Name TEXT30
UtilitiesRateCategoryName Name for Rate Category TEXT40
UtilitiesContract Contract VERTRAG
CityName City TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
MeterReadingBlockingReasonName Text (20 Characters) TEXT20
MeterReadingUnitName Meter Reading Unit Name BEZEICHNG
UtilitiesInstallationTypeName Text (30 Characters) TEXT30
UtilitiesSrvcProviderRoleName Text for Service Type TEXT25
UtilsInstDeregulationStsName Text, 40 Characters Long TEXT40
UtilsInstGuarOfSupReasonName Text for reason for guarantee of supply TEXT30
NumberOfUtilitiesInstallation Number of Installations
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • C_UTILSINSTKEYDATEANALYSISQ.COUNTRY == T005.LAND1
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == T005.MANDT
Industry
  • Industry
  • Client
  • ?
  • C_UTILSINSTKEYDATEANALYSISQ.INDUSTRYSECTOR == TB038A.IND_SECTOR
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TB038A.CLIENT
  • C_UTILSINSTKEYDATEANALYSISQ.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
Reason for blocking meter reading
  • Client
  • Reason for blocking meter reading
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TE119.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.METERREADINGBLOCKINGREASON == TE119.ABLSPERR
Meter Reading Unit
  • Client
  • Meter Reading Unit
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TE422.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.METERREADINGUNIT == TE422.TERMSCHL
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_UTILSINSTKEYDATEANALYSISQ.COUNTRY == T005S.LAND1
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == T005S.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.REGION == T005S.BLAND
Billing Class
  • Client
  • Billing Class
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == EAKLASSE.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILITIESBILLINGCLASS == EAKLASSE.AKLASSE
Installation type
  • Client
  • Installation type
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TE439.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILITIESINSTALLATIONTYPE == TE439.ANLART
Premise
  • Client
  • Premise
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == EVBS.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILITIESPREMISE == EVBS.VSTELLE
Rate Category
  • Client
  • Rate Category
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == ETTA.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILITIESRATECATEGORY == ETTA.TARIFTYP
Service Type
  • Client
  • Service Type
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TECDE.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILITIESSRVCPROVIDERROLE == TECDE.SERVICE
Deregulation status
  • Client
  • Deregulation status
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TEDEREGSTAT.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILSINSTDEREGULATIONSTS == TEDEREGSTAT.DEREGSTAT
Reason for guarantee of supply
  • Client
  • Reason for guarantee of supply
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TE759.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.UTILSINSTGUAROFSUPREASON == TE759.NODISCONCT
Other Relations | to Master Data Relations ↑ Join Conditions
Division
  • Client
  • Division
  • C_UTILSINSTKEYDATEANALYSISQ.MANDT == TESPT.MANDT
  • C_UTILSINSTKEYDATEANALYSISQ.DIVISION == TESPT.SPARTE