A_SalesDocumentProposalItem

Product Proposal for Sales Order Item | view: ASLSDOCPRPSLITM | TRAN | 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
SalesGroup FK Sales group
SalesOffice FK Sales office
SoldToParty FK Customer Number
SalesDocumentType Sales Document Type
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
  • Client
  • Material Number
  • Batch Number
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == MCH1.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.PRODUCT == MCH1.MATNR
  • A_SALESDOCUMENTPROPOSALITEM.BATCH == MCH1.CHARG
Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == TVKOV.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESDOCUMENTPROPOSALITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Sales unit
  • Client
  • Sales unit
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == T006.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.ORDERQUANTITYUNIT == T006.MSEHI
Division
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == TVTA.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESDOCUMENTPROPOSALITEM.SALESORGANIZATION == TVTA.VKORG
  • A_SALESDOCUMENTPROPOSALITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Material Number
  • Client
  • Material Number
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == MARA.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.PRODUCT == MARA.MATNR
Sales group
  • Client
  • Sales office
  • Sales group
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == TVBVK.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.SALESOFFICE == TVBVK.VKBUR
  • A_SALESDOCUMENTPROPOSALITEM.SALESGROUP == TVBVK.VKGRP
Sales office
  • Client
  • Sales office
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == TVBUR.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == TVKO.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.SALESORGANIZATION == TVKO.VKORG
Customer Number
  • Client
  • Customer Number
  • A_SALESDOCUMENTPROPOSALITEM.MANDT == KNA1.MANDT
  • A_SALESDOCUMENTPROPOSALITEM.SOLDTOPARTY == KNA1.KUNNR