I_EmplHomeAddress

Obsolete - DONOT USE_Employee Home Address | view: IEMPLHOMEADDRESS | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: BUT020BUT021_FS/SHCM/HRP5092USR21ADCPADR2ADR6ADRC
Column Name Description
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PersonnelNumber Object ID HROBJID
Employee Identification Number CHAR60
StartDate Validity Start of a Business Partner Address TZNTSTMPS
EndDate Validity End of a Business Partner Address TZNTSTMPS
District District TEXT40
PostalCode City postal code CHAR10
CityName City TEXT40
HomeCityName City (different from postal city) TEXT40
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
CareOfName c/o name TEXT40
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
DefaultEmailAddress E-Mail Address AD_SMTPADR
AuthorizationGroup null
Master Data Relations Join Conditions
Address Number
  • ?
  • Client
  • ?
  • Address Number
  • I_EMPLHOMEADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_EMPLHOMEADDRESS.MANDT == ADRC.CLIENT
  • I_EMPLHOMEADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_EMPLHOMEADDRESS.ADDRESSID == ADRC.ADDRNUMBER
Country key
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_EMPLHOMEADDRESS.COUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.MANDT == T005.MANDT
Country key
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_EMPLHOMEADDRESS.COUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.MANDT == T005.MANDT
Business Partner Number
  • Client
  • Business Partner Number
  • I_EMPLHOMEADDRESS.MANDT == BUT000.CLIENT
  • I_EMPLHOMEADDRESS.EMPLOYEEINTERNALID == BUT000.PARTNER
Country key
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_EMPLHOMEADDRESS.COUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_EMPLHOMEADDRESS.MANDT == T005.MANDT
Key of person
  • ?
  • Client
  • Person Number
  • ?
  • I_EMPLHOMEADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • I_EMPLHOMEADDRESS.MANDT == ADRP.CLIENT
  • I_EMPLHOMEADDRESS.PERSON == ADRP.PERSNUMBER
  • I_EMPLHOMEADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
Region code
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • Region (State, Province, County)
  • I_EMPLHOMEADDRESS.COUNTRY == T005S.LAND1
  • I_EMPLHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_EMPLHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005S.LAND1
  • I_EMPLHOMEADDRESS.MANDT == T005S.MANDT
  • I_EMPLHOMEADDRESS.REGION == T005S.BLAND