C_BPTelephoneNumber

BP Telephone Number Consumption view | view: CBPTELEPHONENO | Extraction: Not supported | Component: Business Partners
Tables used: T005KADRTADR2BUT020BUT000
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Person FK Person Number
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsDefaultPhoneNumber Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
TelephoneCountryPrefix International Dialling Code for Telephone/Fax CHAR4
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
AddressCommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • C_BPTELEPHONENUMBER.[column in domain "AD_NATION"] == ADRC.NATION
  • C_BPTELEPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BPTELEPHONENUMBER.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPTELEPHONENUMBER.MANDT == ADRC.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • C_BPTELEPHONENUMBER.BUSINESSPARTNER == BUT000.PARTNER
  • C_BPTELEPHONENUMBER.MANDT == BUT000.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Client
  • C_BPTELEPHONENUMBER.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • C_BPTELEPHONENUMBER.MANDT == T005.MANDT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • C_BPTELEPHONENUMBER.[column in domain "AD_NATION"] == ADRP.NATION
  • C_BPTELEPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_BPTELEPHONENUMBER.MANDT == ADRP.CLIENT
  • C_BPTELEPHONENUMBER.PERSON == ADRP.PERSNUMBER