I_SalesDocumentProposalItem

Product Proposal for Sales Order Item | view: ISDSLSDOCPROPITM | ATTR | Extraction: Not supported | Component: Sales Analytics
Tables used: VBPV_E, KNVV
Column Name Description
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
OrganizationDivision FK Division
SoldToParty FK Customer Number
SalesDocumentType Sales Document Type
Product FK Material Number
Batch FK Batch Number
Column Name Description
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Item proposal quantity
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_SALESDOCUMENTPROPOSALITEM.PRODUCT == MCH1.MATNR
  • I_SALESDOCUMENTPROPOSALITEM.BATCH == MCH1.CHARG
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == MCH1.MANDT
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • I_SALESDOCUMENTPROPOSALITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == TVKOV.MANDT
  • I_SALESDOCUMENTPROPOSALITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Sales unit
  • Client
  • Sales unit
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == T006.MANDT
  • I_SALESDOCUMENTPROPOSALITEM.ORDERQUANTITYUNIT == T006.MSEHI
Division
  • Sales Organization
  • Division
  • Client
  • Distribution Channel
  • I_SALESDOCUMENTPROPOSALITEM.SALESORGANIZATION == TVTA.VKORG
  • I_SALESDOCUMENTPROPOSALITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == TVTA.MANDT
  • I_SALESDOCUMENTPROPOSALITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material Number
  • Material Number
  • Client
  • I_SALESDOCUMENTPROPOSALITEM.PRODUCT == MARA.MATNR
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == MARA.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == TVBVK.MANDT
  • I_SALESDOCUMENTPROPOSALITEM.SALESOFFICE == TVBVK.VKBUR
  • I_SALESDOCUMENTPROPOSALITEM.SALESGROUP == TVBVK.VKGRP
Sales office
  • Client
  • Sales office
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == TVBUR.MANDT
  • I_SALESDOCUMENTPROPOSALITEM.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Sales Organization
  • Client
  • I_SALESDOCUMENTPROPOSALITEM.SALESORGANIZATION == TVKO.VKORG
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == TVKO.MANDT
Customer Number
  • Customer Number
  • Client
  • I_SALESDOCUMENTPROPOSALITEM.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESDOCUMENTPROPOSALITEM.MANDT == KNA1.MANDT