V_VAKPA_LI

supplier sub view for V_VAKPA | view: V_VAKPA_LI_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
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_LI.AUART == TVAK.AUART
  • V_VAKPA_LI.MANDT == TVAK.MANDT
Vendor - Document Vendor
  • Account Number of Supplier
  • Client
  • V_VAKPA_LI.KUNDE == LFA1.LIFNR
  • V_VAKPA_LI.MANDT == LFA1.MANDT
Customer - Document Customer
  • Customer Number
  • Client
  • V_VAKPA_LI.KUNNR == KNA1.KUNNR
  • V_VAKPA_LI.MANDT == KNA1.MANDT
Partner function - Document partner
  • Client
  • Partner Function
  • V_VAKPA_LI.MANDT == TPAR.MANDT
  • V_VAKPA_LI.PARVW == TPAR.PARVW
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • V_VAKPA_LI.MANDT == TVTA.MANDT
  • V_VAKPA_LI.SPART == TVTA.SPART
  • V_VAKPA_LI.VKORG == TVTA.VKORG
  • V_VAKPA_LI.VTWEG == TVTA.VTWEG
Sales group
  • Client
  • Sales office
  • Sales group
  • V_VAKPA_LI.MANDT == TVBVK.MANDT
  • V_VAKPA_LI.VKBUR == TVBVK.VKBUR
  • V_VAKPA_LI.VKGRP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • V_VAKPA_LI.MANDT == TVKO.MANDT
  • V_VAKPA_LI.VKORG == TVKO.VKORG
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • V_VAKPA_LI.MANDT == TVKOV.MANDT
  • V_VAKPA_LI.VKORG == TVKOV.VKORG
  • V_VAKPA_LI.VTWEG == TVKOV.VTWEG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • Sales office
  • V_VAKPA_LI.MANDT == TVKBZ.MANDT
  • V_VAKPA_LI.SPART == TVKBZ.SPART
  • V_VAKPA_LI.VKORG == TVKBZ.VKORG
  • V_VAKPA_LI.VTWEG == TVKBZ.VTWEG
  • V_VAKPA_LI.VKBUR == TVKBZ.VKBUR