A_BPContactToFuncAndDept

Function and Department | view: ABUPACONTACTFUNC | Extraction: Not supported | Component: Business Partners
Tables used: BUT051
Column Name Description
RelationshipNumber FK BP Relationship Number
BusinessPartnerCompany Business Partner Number
BusinessPartnerPerson Business Partner Number
ValidityEndDate Validity Date (Valid To)
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
Column Name Description
Column Name Description Domain name
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
FaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Department
  • Client
  • Department
  • A_BPCONTACTTOFUNCANDDEPT.MANDT == TB910.CLIENT
  • A_BPCONTACTTOFUNCANDDEPT.CONTACTPERSONDEPARTMENT == TB910.ABTNR
Function of partner
  • Client
  • Function of partner
  • A_BPCONTACTTOFUNCANDDEPT.MANDT == TB912.CLIENT
  • A_BPCONTACTTOFUNCANDDEPT.CONTACTPERSONFUNCTION == TB912.PAFKT
Business Partner Relationship Category
  • Client
  • Business Partner Relationship Category
  • ?
  • A_BPCONTACTTOFUNCANDDEPT.MANDT == TBZ9.CLIENT
  • A_BPCONTACTTOFUNCANDDEPT.RELATIONSHIPCATEGORY == TBZ9.RELTYP
  • A_BPCONTACTTOFUNCANDDEPT.[column in domain "BU_XRF"] == TBZ9.XRF
BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • BP Relationship Number
  • Validity Date (Valid To)
  • A_BPCONTACTTOFUNCANDDEPT.MANDT == BUT050.CLIENT
  • A_BPCONTACTTOFUNCANDDEPT.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • A_BPCONTACTTOFUNCANDDEPT.BUSINESSPARTNERPERSON == BUT050.PARTNER2
  • A_BPCONTACTTOFUNCANDDEPT.RELATIONSHIPNUMBER == BUT050.RELNR
  • A_BPCONTACTTOFUNCANDDEPT.VALIDITYENDDATE == BUT050.DATE_TO