A_BPContactWrkPlacePhoneNumber

BP Contact Work Place Phone Number | view: ABPCONTACTPHONE | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR3ADR2ADCPBUT000BUT052BUT000
Column Name Description
BusinessPartnerCompany Business Partner Number
BusinessPartnerPerson Business Partner Number
RelationshipNumber FK BP Relationship Number
AddressID FK Address Number
ValidityEndDate Validity Date (Valid To)
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
Column Name Description
IsDefaultPhoneNumber Standard Sender Address in this Communication Type Show values
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
Column Name Description Domain name
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
AddressCommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • ?
  • Client
  • A_BPCONTACTWRKPLACEPHONENUMBER.ADDRESSID == ADRC.ADDRNUMBER
  • A_BPCONTACTWRKPLACEPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • A_BPCONTACTWRKPLACEPHONENUMBER.[column in domain "AD_NATION"] == ADRC.NATION
  • A_BPCONTACTWRKPLACEPHONENUMBER.MANDT == ADRC.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Client
  • A_BPCONTACTWRKPLACEPHONENUMBER.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • A_BPCONTACTWRKPLACEPHONENUMBER.MANDT == T005.MANDT
BP Relationship Number
  • Validity Date (Valid To)
  • Business Partner Number
  • BP Relationship Number
  • Client
  • Business Partner Number
  • A_BPCONTACTWRKPLACEPHONENUMBER.VALIDITYENDDATE == BUT050.DATE_TO
  • A_BPCONTACTWRKPLACEPHONENUMBER.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • A_BPCONTACTWRKPLACEPHONENUMBER.RELATIONSHIPNUMBER == BUT050.RELNR
  • A_BPCONTACTWRKPLACEPHONENUMBER.MANDT == BUT050.CLIENT
  • A_BPCONTACTWRKPLACEPHONENUMBER.BUSINESSPARTNERPERSON == BUT050.PARTNER2