I_EmployeeWorkplaceAddress

Employee Workplace Address | view: IEMPLOYEEWPADDR | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: /SHCM/HRP5092USR21ADCPADR2ADR3ADR6BUT000MOM052
Column Name Description
PersonnelNumber Object ID
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate null
ValidityEndDate null
Column Name Description
Column Name Description Domain name
Employee Identification Number CHAR60
EmployeeInternalID Business Partner Number BU_PARTNER
FullName Full Name TEXT80
BusinessPartnerUUID Business Partner GUID SYSUUID
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
NormalizedPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
MblNormalizedPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
DefaultEmailAddress E-Mail Address AD_SMTPADR
Building Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
Master Data Relations Join Conditions
Address key
  • Client
  • ?
  • ?
  • Address Number
  • I_EMPLOYEEWORKPLACEADDRESS.MANDT == ADRC.CLIENT
  • I_EMPLOYEEWORKPLACEADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_EMPLOYEEWORKPLACEADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_EMPLOYEEWORKPLACEADDRESS.ADDRESSID == ADRC.ADDRNUMBER
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_EMPLOYEEWORKPLACEADDRESS.MANDT == T005.MANDT
  • I_EMPLOYEEWORKPLACEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEWORKPLACEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_EMPLOYEEWORKPLACEADDRESS.MANDT == T005.MANDT
  • I_EMPLOYEEWORKPLACEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_EMPLOYEEWORKPLACEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Address key assignment to users
  • User ID
  • Client
  • I_EMPLOYEEWORKPLACEADDRESS.USERID == USR02.BNAME
  • I_EMPLOYEEWORKPLACEADDRESS.MANDT == USR02.MANDT