I_BusinessPartnerPartFunc

Core view for BP Partner Functions | view: IBUPAPARTFUNC | Extraction: Not supported | Component: Business Partners
Tables used: BUT000KNVPTPARCVI_CUST_LINK
Column Name Description
BusinessPartner Business Partner Number
Customer FK Customer Number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
PartnerCounter Partner counter
PartnerFunction FK Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DefaultPartner Default Partner Show values
Column Name Description Domain name
ContactPerson Number of Contact Person PARNR
BPCustomerNumber Account Number of Supplier LIFNR
CustomerPartnerDescription Customer description of partner (plant, storage location) KNREF
BusinessPartnerUUID Business Partner GUID SYSUUID
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Client
  • ?
  • Business Partner Address Number (from BUT020)
  • I_BUSINESSPARTNERPARTFUNC.MANDT == BUT020.CLIENT
  • I_BUSINESSPARTNERPARTFUNC.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • I_BUSINESSPARTNERPARTFUNC.ADDRESSID == BUT020.ADDRNUMBER
Customer Number
  • Client
  • Customer Number
  • I_BUSINESSPARTNERPARTFUNC.MANDT == KNA1.MANDT
  • I_BUSINESSPARTNERPARTFUNC.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • I_BUSINESSPARTNERPARTFUNC.MANDT == TVTW.MANDT
  • I_BUSINESSPARTNERPARTFUNC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_BUSINESSPARTNERPARTFUNC.MANDT == TSPA.MANDT
  • I_BUSINESSPARTNERPARTFUNC.DIVISION == TSPA.SPART
Partner Function
  • Client
  • Partner Function
  • I_BUSINESSPARTNERPARTFUNC.MANDT == TPAR.MANDT
  • I_BUSINESSPARTNERPARTFUNC.PARTNERFUNCTION == TPAR.PARVW
Type of partner number
  • Client
  • Type of partner number
  • I_BUSINESSPARTNERPARTFUNC.MANDT == TVPA.MANDT
  • I_BUSINESSPARTNERPARTFUNC.PARTNERFUNCTIONTYPE == TVPA.NRART
Sales Organization
  • Client
  • Sales Organization
  • I_BUSINESSPARTNERPARTFUNC.MANDT == TVKO.MANDT
  • I_BUSINESSPARTNERPARTFUNC.SALESORGANIZATION == TVKO.VKORG