I_BPContactToFuncAndDept

Business Partner Contact To Function and Department | view: IBPCNTCTFUNCDEPT | ATTR | Extraction: Not supported | Component: SAP Business Partner
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
ContactPersonFunctionName Function name of partner TEXT40
ContactPersonDepartmentName Department at business partner TEXT40
ContactPersonRemarkText Notes for Partner TEXT40
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
Partner's Authority
  • Partner's Authority
  • Client
  • I_BPCONTACTTOFUNCANDDEPT.CONTACTPERSONAUTHORITYTYPE == TB914.PAAUTH
  • I_BPCONTACTTOFUNCANDDEPT.MANDT == TB914.CLIENT
Department
  • Department
  • Client
  • I_BPCONTACTTOFUNCANDDEPT.CONTACTPERSONDEPARTMENT == TB910.ABTNR
  • I_BPCONTACTTOFUNCANDDEPT.MANDT == TB910.CLIENT
Function of partner
  • Function of partner
  • Client
  • I_BPCONTACTTOFUNCANDDEPT.CONTACTPERSONFUNCTION == TB912.PAFKT
  • I_BPCONTACTTOFUNCANDDEPT.MANDT == TB912.CLIENT
VIP Partner
  • VIP Partner
  • Client
  • I_BPCONTACTTOFUNCANDDEPT.CONTACTPERSONVIPTYPE == TB916.PAVIP
  • I_BPCONTACTTOFUNCANDDEPT.MANDT == TB916.CLIENT
Business Partner Relationship Category
  • Client
  • Business Partner Relationship Category
  • ?
  • I_BPCONTACTTOFUNCANDDEPT.MANDT == TBZ9.CLIENT
  • I_BPCONTACTTOFUNCANDDEPT.RELATIONSHIPCATEGORY == TBZ9.RELTYP
  • I_BPCONTACTTOFUNCANDDEPT.[column in domain "BU_XRF"] == TBZ9.XRF
BP Relationship Number
  • Business Partner Number
  • Validity Date (Valid To)
  • Business Partner Number
  • BP Relationship Number
  • Client
  • I_BPCONTACTTOFUNCANDDEPT.BUSINESSPARTNERPERSON == BUT050.PARTNER2
  • I_BPCONTACTTOFUNCANDDEPT.VALIDITYENDDATE == BUT050.DATE_TO
  • I_BPCONTACTTOFUNCANDDEPT.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • I_BPCONTACTTOFUNCANDDEPT.RELATIONSHIPNUMBER == BUT050.RELNR
  • I_BPCONTACTTOFUNCANDDEPT.MANDT == BUT050.CLIENT