I_CustSalesPartnerFunc

Customer Sales Area Partner Function | view: ICUSTPARTNERFUNC | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: KNVPTPAR
Column Name Description
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
BPCustomerNumber Account Number of Supplier LIFNR
CustomerPartnerDescription Customer description of partner (plant, storage location) KNREF
PersonnelNumber Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • ?
  • I_CUSTSALESPARTNERFUNC.ADDRESSID == BUT020.ADDRNUMBER
  • I_CUSTSALESPARTNERFUNC.MANDT == BUT020.CLIENT
  • I_CUSTSALESPARTNERFUNC.[column in domain "BU_PARTNER"] == BUT020.PARTNER
Customer Number
  • Customer Number
  • Client
  • I_CUSTSALESPARTNERFUNC.CUSTOMER == KNA1.KUNNR
  • I_CUSTSALESPARTNERFUNC.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_CUSTSALESPARTNERFUNC.MANDT == TVTW.MANDT
  • I_CUSTSALESPARTNERFUNC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_CUSTSALESPARTNERFUNC.MANDT == TSPA.MANDT
  • I_CUSTSALESPARTNERFUNC.DIVISION == TSPA.SPART
Partner Function
  • Client
  • Partner Function
  • I_CUSTSALESPARTNERFUNC.MANDT == TPAR.MANDT
  • I_CUSTSALESPARTNERFUNC.PARTNERFUNCTION == TPAR.PARVW
Type of partner number
  • Type of partner number
  • Client
  • I_CUSTSALESPARTNERFUNC.PARTNERFUNCTIONTYPE == TVPA.NRART
  • I_CUSTSALESPARTNERFUNC.MANDT == TVPA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_CUSTSALESPARTNERFUNC.MANDT == TVKO.MANDT
  • I_CUSTSALESPARTNERFUNC.SALESORGANIZATION == TVKO.VKORG
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_CUSTSALESPARTNERFUNC.MANDT == LFA1.MANDT
  • I_CUSTSALESPARTNERFUNC.SUPPLIER == LFA1.LIFNR