VAKPA

Sales Index: Orders by Partner Function | view | #masterdata | Component: Sales
Column Name Description
MANDT FK Client
KUNDE Partner number (KUNNR, LIFNR, or PERNR)
PARVW FK Partner Function
VKORG FK Sales Organization
TRVOG Transaction Group Show values
AUDAT Document Date (Date Received/Sent)
VKBUR FK Sales office
VKGRP FK Sales group
VTWEG FK Distribution Channel
SPART FK Division
AUART FK Sales Document Type
BSTNK Customer Reference
KUNNR FK Sold-to Party
ERNAM Name of Person Responsible for Creating the Object
VBELN Sales and Distribution Document Number
Column Name Description
Column Name Description
Column Name Description
AUDAT Document Date (Date Received/Sent)
DATAB Quotation or contract valid from
DATBI Quotation or contract valid to
Column Name Description
TRVOG Transaction Group Show values
Column Name Description Domain name
ADRNR_AG Address number of the sold-to party ADRNR
ADRNR Address ADRNR
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR
Master Data Relations Join Conditions
Sales Document Type
  • VAKPA.MANDT == TVAK.MANDT
  • VAKPA.AUART == TVAK.AUART
Sold-to Party
  • VAKPA.MANDT == KNA1.MANDT
  • VAKPA.KUNNR == KNA1.KUNNR
Client VAKPA.MANDT == T000.MANDT
Partner Function
  • Partner Function
  • Client
  • VAKPA.PARVW == TPAR.PARVW
  • VAKPA.MANDT == TPAR.MANDT
Division
  • VAKPA.MANDT == TSPA.MANDT
  • VAKPA.SPART == TSPA.SPART
Sales office
  • Sales office
  • Client
  • VAKPA.VKBUR == TVBUR.VKBUR
  • VAKPA.MANDT == TVBUR.MANDT
Sales group
  • VAKPA.MANDT == TVKGR.MANDT
  • VAKPA.VKGRP == TVKGR.VKGRP
Sales Organization
  • VAKPA.MANDT == TVKO.MANDT
  • VAKPA.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • VAKPA.VTWEG == TVTW.VTWEG
  • VAKPA.MANDT == TVTW.MANDT