P_Bpcontacts_Func_Dept

Business Partner Contacts Function And Department | view: P_MD_BPCFUNCDEPT | Extraction: Not supported | Component: Business Partners
Tables used: BUT051
Column Name Description
relnr FK BP Relationship Number
BusinessPartner1 Business Partner Number
BusinessPartner2 Business Partner Number
ContactPersonFunction FK Function of partner
ContactPersonDepartment FK Department
Column Name Description
Column Name Description
Column Name Description
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
  • P_BPCONTACTS_FUNC_DEPT.MANDT == TB910.CLIENT
  • P_BPCONTACTS_FUNC_DEPT.CONTACTPERSONDEPARTMENT == TB910.ABTNR
Function of partner
  • Client
  • Function of partner
  • P_BPCONTACTS_FUNC_DEPT.MANDT == TB912.CLIENT
  • P_BPCONTACTS_FUNC_DEPT.CONTACTPERSONFUNCTION == TB912.PAFKT
BP Relationship Number
  • ?
  • Client
  • Business Partner Number
  • BP Relationship Number
  • Business Partner Number
  • P_BPCONTACTS_FUNC_DEPT.[column in domain "BU_DATTO"] == BUT050.DATE_TO
  • P_BPCONTACTS_FUNC_DEPT.MANDT == BUT050.CLIENT
  • P_BPCONTACTS_FUNC_DEPT.BUSINESSPARTNER1 == BUT050.PARTNER1
  • P_BPCONTACTS_FUNC_DEPT.RELNR == BUT050.RELNR
  • P_BPCONTACTS_FUNC_DEPT.BUSINESSPARTNER2 == BUT050.PARTNER2
Business Partner Relationship Category
  • Business Partner Relationship Category
  • Client
  • ?
  • P_BPCONTACTS_FUNC_DEPT.RELTYP == TBZ9.RELTYP
  • P_BPCONTACTS_FUNC_DEPT.MANDT == TBZ9.CLIENT
  • P_BPCONTACTS_FUNC_DEPT.[column in domain "BU_XRF"] == TBZ9.XRF