A_CustSalesPartnerFunc

Sales Partner Functions | view: ACUSTPARTNERFUNC | Extraction: Not supported | Component: Business Partners
Tables used: KNA1KNVPTPAR
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
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • ?
  • Client
  • A_CUSTSALESPARTNERFUNC.ADDRESSID == BUT020.ADDRNUMBER
  • A_CUSTSALESPARTNERFUNC.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • A_CUSTSALESPARTNERFUNC.MANDT == BUT020.CLIENT
Customer Number
  • Customer Number
  • Client
  • A_CUSTSALESPARTNERFUNC.CUSTOMER == KNA1.KUNNR
  • A_CUSTSALESPARTNERFUNC.MANDT == KNA1.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • A_CUSTSALESPARTNERFUNC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • A_CUSTSALESPARTNERFUNC.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • A_CUSTSALESPARTNERFUNC.DIVISION == TSPA.SPART
  • A_CUSTSALESPARTNERFUNC.MANDT == TSPA.MANDT
Partner Function
  • Client
  • Partner Function
  • A_CUSTSALESPARTNERFUNC.MANDT == TPAR.MANDT
  • A_CUSTSALESPARTNERFUNC.PARTNERFUNCTION == TPAR.PARVW
Sales Organization
  • Sales Organization
  • Client
  • A_CUSTSALESPARTNERFUNC.SALESORGANIZATION == TVKO.VKORG
  • A_CUSTSALESPARTNERFUNC.MANDT == TVKO.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • A_CUSTSALESPARTNERFUNC.SUPPLIER == LFA1.LIFNR
  • A_CUSTSALESPARTNERFUNC.MANDT == LFA1.MANDT