v_vapma

view equivalent fot VAPMA | view: V_VAPMA_CDS | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAKVBAPVBPA
Column Name Description
Column Name Description
Column Name Description
Column Name Description
audat Document Date (Date Received/Sent)
datab Valid-From Date (Outline Agreements, Product Proposals)
datbi Valid-To Date (Outline Agreements, Product Proposals)
Column Name Description
trvog Transaction Group Show values
Column Name Description Domain name
bstnk Customer Reference BSTNK
ernam Name of Person Responsible for Creating the Object USNAM
vbeln Sales Document VBELN
posnr Sales Document Item POSNR
werks Plant (Own or External) WERKS
adrnr Address ADRNR
oipbl Business location identifier (IS-Oil MRN) OIF_PBLNR
Master Data Relations Join Conditions
Order type in order header
  • Sales Document Type
  • Client
  • V_VAPMA.AUART == TVAK.AUART
  • V_VAPMA.MANDT == TVAK.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • V_VAPMA.MANDT == KNA1.MANDT
  • V_VAPMA.KUNNR == KNA1.KUNNR
Material: order item
  • Material Number
  • Client
  • V_VAPMA.MATNR == MARA.MATNR
  • V_VAPMA.MANDT == MARA.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • V_VAPMA.SPART == TVTA.SPART
  • V_VAPMA.VTWEG == TVTA.VTWEG
  • V_VAPMA.MANDT == TVTA.MANDT
  • V_VAPMA.VKORG == TVTA.VKORG
Sales group
  • Sales group
  • Client
  • Sales office
  • V_VAPMA.VKGRP == TVBVK.VKGRP
  • V_VAPMA.MANDT == TVBVK.MANDT
  • V_VAPMA.VKBUR == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • V_VAPMA.MANDT == TVKO.MANDT
  • V_VAPMA.VKORG == TVKO.VKORG
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • V_VAPMA.VTWEG == TVKOV.VTWEG
  • V_VAPMA.MANDT == TVKOV.MANDT
  • V_VAPMA.VKORG == TVKOV.VKORG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • Sales office
  • V_VAPMA.SPART == TVKBZ.SPART
  • V_VAPMA.VTWEG == TVKBZ.VTWEG
  • V_VAPMA.MANDT == TVKBZ.MANDT
  • V_VAPMA.VKORG == TVKBZ.VKORG
  • V_VAPMA.VKBUR == TVKBZ.VKBUR