A_SalesOrderItemPartner

Item Partner | view: ASOIPARTNER | TRAN | Extraction: Not supported | Component: Sales Orders
Column Name Description
SalesOrder Sales Order
SalesOrderItem Sales Order Item
PartnerFunction FK Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
BusinessPartnerAddressUUID GUID of a Business Partner Address SYSUUID
BPRefAddrForDocSpcfcAddrUUID GUID of a Business Partner Address SYSUUID
Master Data Relations Join Conditions
Customer - Document Customer
  • Client
  • Customer Number
  • A_SALESORDERITEMPARTNER.MANDT == KNA1.MANDT
  • A_SALESORDERITEMPARTNER.CUSTOMER == KNA1.KUNNR
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • A_SALESORDERITEMPARTNER.MANDT == TVKOV.MANDT
  • A_SALESORDERITEMPARTNER.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESORDERITEMPARTNER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Division
  • Distribution Channel
  • A_SALESORDERITEMPARTNER.MANDT == TVTA.MANDT
  • A_SALESORDERITEMPARTNER.SALESORGANIZATION == TVTA.VKORG
  • A_SALESORDERITEMPARTNER.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESORDERITEMPARTNER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Partner function - Document partner
  • Client
  • Partner Function
  • A_SALESORDERITEMPARTNER.MANDT == TPAR.MANDT
  • A_SALESORDERITEMPARTNER.PARTNERFUNCTION == TPAR.PARVW
Order type in order header
  • Client
  • Sales Document Type
  • A_SALESORDERITEMPARTNER.MANDT == TVAK.MANDT
  • A_SALESORDERITEMPARTNER.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • A_SALESORDERITEMPARTNER.MANDT == TVKO.MANDT
  • A_SALESORDERITEMPARTNER.SALESORGANIZATION == TVKO.VKORG
Vendor - Document Vendor
  • Client
  • Account Number of Supplier
  • A_SALESORDERITEMPARTNER.MANDT == LFA1.MANDT
  • A_SALESORDERITEMPARTNER.SUPPLIER == LFA1.LIFNR