P_EmplPrivCommData

Employee Private Communication Data | view: PEMPLPRVCOMMDATA | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: ADCPADR2ADR6
Column Name Description
AddressID FK Address Number
Person FK Person Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
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
Address key
  • Address Number
  • ?
  • ?
  • Client
  • P_EMPLPRIVCOMMDATA.ADDRESSID == ADRC.ADDRNUMBER
  • P_EMPLPRIVCOMMDATA.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_EMPLPRIVCOMMDATA.[column in domain "AD_NATION"] == ADRC.NATION
  • P_EMPLPRIVCOMMDATA.MANDT == ADRC.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • P_EMPLPRIVCOMMDATA.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • P_EMPLPRIVCOMMDATA.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • P_EMPLPRIVCOMMDATA.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • P_EMPLPRIVCOMMDATA.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • P_EMPLPRIVCOMMDATA.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
  • P_EMPLPRIVCOMMDATA.MANDT == T005.MANDT
Key of person
  • Person Number
  • ?
  • ?
  • Client
  • P_EMPLPRIVCOMMDATA.PERSON == ADRP.PERSNUMBER
  • P_EMPLPRIVCOMMDATA.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • P_EMPLPRIVCOMMDATA.[column in domain "AD_NATION"] == ADRP.NATION
  • P_EMPLPRIVCOMMDATA.MANDT == ADRP.CLIENT