I_UtilsPremiseKeyDateAnalysis

Key Date-Based Premise Analysis | view: IEPREMISEANLYS | TRAN | Extraction: Not supported | Component: Master Data
Tables used: ADCPADRCEPROPHIFLOTILOAEANLEPROPEVBS
Column Name Description
UtilitiesPremise Premise
Column Name Description
Column Name Description
Column Name Description
UtilitiesAnalysisKeyDate Premise Analysis Key Date
Column Name Description
UtilsPremiseIsMainResidence Main residence Show values
DeletionIndicator Deletion Indicator Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BEGRU
NumberOfPersons Number of persons ANZ_PERS
UtilitiesConnectionObject Connection Object CHAR30
UtilitiesOwner Owner BU_PARTNER
AddressID Address Number AD_ADDRNUM
CityName City TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
PostalCode City postal code CHAR10
LocationSupplement Additional Information on Location LGZUSATZ
Floor Floor in building TEXT10
HouseNumberSupplementText House number supplement TEXT10
RoomNumber Room or Apartment Number TEXT10
StreetSupplement1 Street 3 TEXT40
StreetSupplement2 Street 5 TEXT40
NumberOfUtilitiesPremises Number of Premises
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • I_UTILSPREMISEKEYDATEANALYSIS.MANDT == T005.MANDT
  • I_UTILSPREMISEKEYDATEANALYSIS.COUNTRY == T005.LAND1
Functional location
  • Client
  • Functional location
  • I_UTILSPREMISEKEYDATEANALYSIS.MANDT == IFLOT.MANDT
  • I_UTILSPREMISEKEYDATEANALYSIS.FUNCTIONALLOCATION == IFLOT.TPLNR
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_UTILSPREMISEKEYDATEANALYSIS.MANDT == T005S.MANDT
  • I_UTILSPREMISEKEYDATEANALYSIS.COUNTRY == T005S.LAND1
  • I_UTILSPREMISEKEYDATEANALYSIS.REGION == T005S.BLAND
Type of premise
  • Type of premise
  • Client
  • I_UTILSPREMISEKEYDATEANALYSIS.UTILITIESPREMISETYPE == TE102.VBSART
  • I_UTILSPREMISEKEYDATEANALYSIS.MANDT == TE102.MANDT