I_EmployeeHomeAddressDetails

Employee Home Address Details | view: IEMPLHOMEADDRD | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: ADCPADRCT005T005T/SHCM/HRP5092BUT020USR21ADR2ADR6
Column Name Description
EmployeeInternalID Business Partner Number
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
PersonnelNumber Object ID HROBJID
Employee Identification Number CHAR60
ValidityEndDate Validity End of a Business Partner Address TZNTSTMPS
CountryName Country/Region Name TEXT50
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
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_EMPLOYEEHOMEADDRESSDETAILS.COUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MANDT == T005.MANDT
Country key
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_EMPLOYEEHOMEADDRESSDETAILS.COUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MANDT == T005.MANDT
Country key
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • I_EMPLOYEEHOMEADDRESSDETAILS.COUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MANDT == T005.MANDT
Key of person
  • ?
  • Person Number
  • Client
  • ?
  • I_EMPLOYEEHOMEADDRESSDETAILS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_EMPLOYEEHOMEADDRESSDETAILS.PERSON == ADRP.PERSNUMBER
  • I_EMPLOYEEHOMEADDRESSDETAILS.MANDT == ADRP.CLIENT
  • I_EMPLOYEEHOMEADDRESSDETAILS.[column in domain "AD_NATION"] == ADRP.NATION
Region code
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • Region (State, Province, County)
  • I_EMPLOYEEHOMEADDRESSDETAILS.COUNTRY == T005S.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MBLPHONEDESTINATIONLOCCOUNTRY == T005S.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.DESTINATIONLOCATIONCOUNTRY == T005S.LAND1
  • I_EMPLOYEEHOMEADDRESSDETAILS.MANDT == T005S.MANDT
  • I_EMPLOYEEHOMEADDRESSDETAILS.REGION == T005S.BLAND