C_BPContactTelNmbr

C View for BP Contact Telephone number | view: CBPCPTELNUM | Extraction: Not supported | Component: Business Partners
Tables used: ADRT, ADR3, ADR2, ADCP, BUT000, BUT052, BUT000, T005K
Column Name Description
BusinessPartner1 Business Partner Number
BusinessPartner2 Business Partner Number
RelationshipNumber FK BP Relationship Number
ValidityEndDate Validity Date (Valid To)
AddressID FK Address Number
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
ValidityEndDateForEdit Validity Date (Valid To)
Column Name Description
IsDefaultPhoneNumber Standard Sender Address in this Communication Type Show values
CommNumberIsNotUsed Flag: This Communication Number is Not Used Show values
PhoneIsSMSEnabled Truth Value: True/False Show values
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
Column Name Description Domain name
BusinessPartner1ForEdit Business Partner Number BU_PARTNER
BusinessPartner2ForEdit Business Partner Number BU_PARTNER
OrdinalNumberForEdit Sequence Number NUMC3
CountryDialingCode 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
  • Client
  • ?
  • Address Number
  • Address Number
  • ?
  • C_BPCONTACTTELNMBR.MANDT == ADRC.CLIENT
  • C_BPCONTACTTELNMBR.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BPCONTACTTELNMBR.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • C_BPCONTACTTELNMBR.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPCONTACTTELNMBR.[column in domain "AD_NATION"] == ADRC.NATION
Address Number
  • Client
  • ?
  • Address Number
  • Address Number
  • ?
  • C_BPCONTACTTELNMBR.MANDT == ADRC.CLIENT
  • C_BPCONTACTTELNMBR.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BPCONTACTTELNMBR.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • C_BPCONTACTTELNMBR.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPCONTACTTELNMBR.[column in domain "AD_NATION"] == ADRC.NATION
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • C_BPCONTACTTELNMBR.MANDT == T005.MANDT
  • C_BPCONTACTTELNMBR.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
BP Relationship Number
  • Client
  • Validity Date (Valid To)
  • Validity Date (Valid To)
  • Business Partner Number
  • Business Partner Number
  • BP Relationship Number
  • BP Relationship Number
  • Business Partner Number
  • Business Partner Number
  • C_BPCONTACTTELNMBR.MANDT == BUT050.CLIENT
  • C_BPCONTACTTELNMBR.VALIDITYENDDATE == BUT050.DATE_TO
  • C_BPCONTACTTELNMBR.VALIDITYENDDATEFOREDIT == BUT050.DATE_TO
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER1 == BUT050.PARTNER1
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER1FOREDIT == BUT050.PARTNER1
  • C_BPCONTACTTELNMBR.RELATIONSHIPNUMBERFOREDIT == BUT050.RELNR
  • C_BPCONTACTTELNMBR.RELATIONSHIPNUMBER == BUT050.RELNR
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER2 == BUT050.PARTNER2
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER2FOREDIT == BUT050.PARTNER2
BP Relationship Number
  • Client
  • Validity Date (Valid To)
  • Validity Date (Valid To)
  • Business Partner Number
  • Business Partner Number
  • BP Relationship Number
  • BP Relationship Number
  • Business Partner Number
  • Business Partner Number
  • C_BPCONTACTTELNMBR.MANDT == BUT050.CLIENT
  • C_BPCONTACTTELNMBR.VALIDITYENDDATE == BUT050.DATE_TO
  • C_BPCONTACTTELNMBR.VALIDITYENDDATEFOREDIT == BUT050.DATE_TO
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER1 == BUT050.PARTNER1
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER1FOREDIT == BUT050.PARTNER1
  • C_BPCONTACTTELNMBR.RELATIONSHIPNUMBERFOREDIT == BUT050.RELNR
  • C_BPCONTACTTELNMBR.RELATIONSHIPNUMBER == BUT050.RELNR
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER2 == BUT050.PARTNER2
  • C_BPCONTACTTELNMBR.BUSINESSPARTNER2FOREDIT == BUT050.PARTNER2