CRMS4_IU_P_PRMFTS_SHLP

Premise free text search search help | view: CRMS4IUVPPRMFTSH | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: ADCPADRCIFLOTILOAEVBS
Column Name Description
UtilitiesPremise Premise
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
StreetName Street TEXT60
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode City postal code CHAR10
UtilitiesConnectionObject Connection Object CHAR30
Master Data Relations Join Conditions
Address Number
  • Client
  • Address Number
  • ?
  • ?
  • CRMS4_IU_P_PRMFTS_SHLP.MANDT == ADRC.CLIENT
  • CRMS4_IU_P_PRMFTS_SHLP.ADDRESSID == ADRC.ADDRNUMBER
  • CRMS4_IU_P_PRMFTS_SHLP.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_IU_P_PRMFTS_SHLP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Country key
  • Client
  • Country/Region Key
  • CRMS4_IU_P_PRMFTS_SHLP.MANDT == T005.MANDT
  • CRMS4_IU_P_PRMFTS_SHLP.COUNTRY == T005.LAND1