P_Bpcontacts_Telephone

Telephone Number of Contacts | view: P_MD_BPC_TEL | Extraction: Not supported | Component: Business Partners
Tables used: ADR2
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
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • P_BPCONTACTS_TELEPHONE.[column in domain "AD_NATION"] == ADRC.NATION
  • P_BPCONTACTS_TELEPHONE.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_BPCONTACTS_TELEPHONE.ADDRESSID == ADRC.ADDRNUMBER
  • P_BPCONTACTS_TELEPHONE.MANDT == ADRC.CLIENT
Person number
  • ?
  • ?
  • Person Number
  • Client
  • P_BPCONTACTS_TELEPHONE.[column in domain "AD_NATION"] == ADRP.NATION
  • P_BPCONTACTS_TELEPHONE.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • P_BPCONTACTS_TELEPHONE.PERSON == ADRP.PERSNUMBER
  • P_BPCONTACTS_TELEPHONE.MANDT == ADRP.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Client
  • P_BPCONTACTS_TELEPHONE.PHONECOUNTRY == T005.LAND1
  • P_BPCONTACTS_TELEPHONE.MANDT == T005.MANDT