v_vakpa

view equivalent to VAKPA | view: V_VAKPA_CDS | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAKVBPAVBAKVBPAVBAKVBPAVBAKVBPAVBAKVBPAVBAKVBPAVBPA2TPARTPARTPARTPARTPAR
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
adrnr_ag Address ADRNR
adrnr Address ADRNR
oipbl Business location identifier (IS-Oil MRN) OIF_PBLNR
Master Data Relations Join Conditions
Order type in order header
  • Client
  • Sales Document Type
  • V_VAKPA.MANDT == TVAK.MANDT
  • V_VAKPA.AUART == TVAK.AUART
Customer - Document Customer
  • Client
  • Customer Number
  • Customer Number
  • V_VAKPA.MANDT == KNA1.MANDT
  • V_VAKPA.KUNDE == KNA1.KUNNR
  • V_VAKPA.KUNNR == KNA1.KUNNR
Customer - Document Customer
  • Client
  • Customer Number
  • Customer Number
  • V_VAKPA.MANDT == KNA1.MANDT
  • V_VAKPA.KUNDE == KNA1.KUNNR
  • V_VAKPA.KUNNR == KNA1.KUNNR
Partner function - Document partner
  • Client
  • Partner Function
  • V_VAKPA.MANDT == TPAR.MANDT
  • V_VAKPA.PARVW == TPAR.PARVW
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • V_VAKPA.MANDT == TVTA.MANDT
  • V_VAKPA.SPART == TVTA.SPART
  • V_VAKPA.VKORG == TVTA.VKORG
  • V_VAKPA.VTWEG == TVTA.VTWEG
Sales group
  • Client
  • Sales office
  • Sales group
  • V_VAKPA.MANDT == TVBVK.MANDT
  • V_VAKPA.VKBUR == TVBVK.VKBUR
  • V_VAKPA.VKGRP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • V_VAKPA.MANDT == TVKO.MANDT
  • V_VAKPA.VKORG == TVKO.VKORG
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • V_VAKPA.MANDT == TVKOV.MANDT
  • V_VAKPA.VKORG == TVKOV.VKORG
  • V_VAKPA.VTWEG == TVKOV.VTWEG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales Organization
  • Sales office
  • Distribution Channel
  • V_VAKPA.MANDT == TVKBZ.MANDT
  • V_VAKPA.SPART == TVKBZ.SPART
  • V_VAKPA.VKORG == TVKBZ.VKORG
  • V_VAKPA.VKBUR == TVKBZ.VKBUR
  • V_VAKPA.VTWEG == TVKBZ.VTWEG