I_EmployeeHomeAddress

Employee Home Address | view: IEMPLHOMEADDRSS | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: ADCPADRC/SHCM/HRP5092ADCPBUT020USR21ADCPADR2ADR6
Column Name Description
PersonnelNumber Object ID
ValidityStartDate Validity Start of a Business Partner Address
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
EmployeeInternalID Business Partner Number BU_PARTNER
Employee Identification Number CHAR60
FullName Full Name TEXT80
ValidityEndDate Validity End of a Business Partner Address TZNTSTMPS
CityName City TEXT40
HomeCityName City (different from postal city) TEXT40
District District TEXT40
PostalCode City postal code CHAR10
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
Business Partner Number
  • Business Partner Number
  • Client
  • I_EMPLOYEEHOMEADDRESS.BUSINESSPARTNER == BUT000.PARTNER
  • I_EMPLOYEEHOMEADDRESS.MANDT == BUT000.CLIENT
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • I_EMPLOYEEHOMEADDRESS.MANDT == T005.MANDT
  • I_EMPLOYEEHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESS.COUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • I_EMPLOYEEHOMEADDRESS.MANDT == T005.MANDT
  • I_EMPLOYEEHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESS.COUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • I_EMPLOYEEHOMEADDRESS.MANDT == T005.MANDT
  • I_EMPLOYEEHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESS.COUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Key of person
  • ?
  • Person Number
  • ?
  • Client
  • I_EMPLOYEEHOMEADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_EMPLOYEEHOMEADDRESS.PERSON == ADRP.PERSNUMBER
  • I_EMPLOYEEHOMEADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • I_EMPLOYEEHOMEADDRESS.MANDT == ADRP.CLIENT
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • I_EMPLOYEEHOMEADDRESS.REGION == T005S.BLAND
  • I_EMPLOYEEHOMEADDRESS.MANDT == T005S.MANDT
  • I_EMPLOYEEHOMEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_EMPLOYEEHOMEADDRESS.COUNTRY == T005S.LAND1
  • I_EMPLOYEEHOMEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005S.LAND1