VBPV_E

Selling Recommender: Sales Document: Product Proposal | #transactional | Component: Sales
Column Name Description
MANDT FK Client
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
KUNNR FK Customer Number
AUART Sales Document Type
MATNR FK Material Number
CHARG FK Batch Number
Column Name Description
💲 SD Document Currency (WAERK):
NETWR Net Value of the Order Item in Document Currency
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
PVMNG01 Item proposal quantity
PVMNG02 Item proposal quantity
PVMNG03 Item proposal quantity
PVMNG04 Item proposal quantity
PVMNG05 Item proposal quantity
PVMNG06 Item proposal quantity
PVMNG07 Item proposal quantity
PVMNG08 Item proposal quantity
PVMNG09 Item proposal quantity
PVMNG10 Item proposal quantity
PVMNG11 Item proposal quantity
PVMNG12 Item proposal quantity
Column Name Description
ERDAT Date on which the record was created
Column Name Description
VBTYP SD Document Category Show values
Column Name Description Domain name
PVSRT Sorting indicator for product proposal (source) NUMC2
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Client
  • Batch Number
  • VBPV_E.MATNR == MCH1.MATNR
  • VBPV_E.MANDT == MCH1.MANDT
  • VBPV_E.CHARG == MCH1.CHARG
Customer Number
  • VBPV_E.MANDT == KNA1.MANDT
  • VBPV_E.KUNNR == KNA1.KUNNR
Client VBPV_E.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • VBPV_E.MATNR == MARA.MATNR
  • VBPV_E.MANDT == MARA.MANDT
Source indicator
  • VBPV_E.MANDT == TPVH.MANDT
  • VBPV_E.PVHKN == TPVH.PVHKN
Sales unit
  • VBPV_E.MANDT == T006.MANDT
  • VBPV_E.PVVRKME == T006.MSEHI
Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • VBPV_E.VKORG == TVTA.VKORG
  • VBPV_E.VTWEG == TVTA.VTWEG
  • VBPV_E.SPART == TVTA.SPART
  • VBPV_E.MANDT == TVTA.MANDT
Sales Organization
  • VBPV_E.MANDT == TVKO.MANDT
  • VBPV_E.VKORG == TVKO.VKORG
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • VBPV_E.VKORG == TVKOV.VKORG
  • VBPV_E.MANDT == TVKOV.MANDT
  • VBPV_E.VTWEG == TVKOV.VTWEG
SD Document Currency
  • VBPV_E.MANDT == TCURC.MANDT
  • VBPV_E.WAERK == TCURC.WAERS