V_VAKPA_PE

employee sub view for V_VAKPA | view: V_VAKPA_PE_CDS | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAKVBPATPAR
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
kunde null
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
  • Sales Document Type
  • Client
  • V_VAKPA_PE.AUART == TVAK.AUART
  • V_VAKPA_PE.MANDT == TVAK.MANDT
Customer - Document Customer
  • Customer Number
  • Client
  • V_VAKPA_PE.KUNNR == KNA1.KUNNR
  • V_VAKPA_PE.MANDT == KNA1.MANDT
Partner function - Document partner
  • Client
  • Partner Function
  • V_VAKPA_PE.MANDT == TPAR.MANDT
  • V_VAKPA_PE.PARVW == TPAR.PARVW
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • V_VAKPA_PE.MANDT == TVTA.MANDT
  • V_VAKPA_PE.VTWEG == TVTA.VTWEG
  • V_VAKPA_PE.SPART == TVTA.SPART
  • V_VAKPA_PE.VKORG == TVTA.VKORG
Sales group
  • Client
  • Sales office
  • Sales group
  • V_VAKPA_PE.MANDT == TVBVK.MANDT
  • V_VAKPA_PE.VKBUR == TVBVK.VKBUR
  • V_VAKPA_PE.VKGRP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • V_VAKPA_PE.MANDT == TVKO.MANDT
  • V_VAKPA_PE.VKORG == TVKO.VKORG
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • V_VAKPA_PE.MANDT == TVKOV.MANDT
  • V_VAKPA_PE.VTWEG == TVKOV.VTWEG
  • V_VAKPA_PE.VKORG == TVKOV.VKORG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Distribution Channel
  • Division
  • Sales Organization
  • V_VAKPA_PE.MANDT == TVKBZ.MANDT
  • V_VAKPA_PE.VKBUR == TVKBZ.VKBUR
  • V_VAKPA_PE.VTWEG == TVKBZ.VTWEG
  • V_VAKPA_PE.SPART == TVKBZ.SPART
  • V_VAKPA_PE.VKORG == TVKBZ.VKORG