VAPMA

Sales Index: Order Items by Material | view | #index | Component: Sales
Column Name Description
MANDT FK Client
MATNR FK Material Number
VKORG FK Sales Organization
TRVOG Transaction Group Show values
AUDAT Document Date (Date Received/Sent)
VTWEG FK Distribution Channel
SPART FK Division
AUART FK Sales Document Type
KUNNR FK Sold-to Party
VKBUR FK Sales office
VKGRP FK Sales group
BSTNK Customer Reference
ERNAM Name of Person Responsible for Creating the Object
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
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 Address number of the sold-to party ADRNR
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR
Master Data Relations Join Conditions
Sales Document Type
  • VAPMA.MANDT == TVAK.MANDT
  • VAPMA.AUART == TVAK.AUART
Sold-to Party
  • VAPMA.MANDT == KNA1.MANDT
  • VAPMA.KUNNR == KNA1.KUNNR
Client VAPMA.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • VAPMA.MATNR == MARA.MATNR
  • VAPMA.MANDT == MARA.MANDT
Division
  • VAPMA.MANDT == TSPA.MANDT
  • VAPMA.SPART == TSPA.SPART
Sales office
  • Sales office
  • Client
  • VAPMA.VKBUR == TVBUR.VKBUR
  • VAPMA.MANDT == TVBUR.MANDT
Sales group
  • VAPMA.MANDT == TVKGR.MANDT
  • VAPMA.VKGRP == TVKGR.VKGRP
Sales Organization
  • VAPMA.MANDT == TVKO.MANDT
  • VAPMA.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • VAPMA.VTWEG == TVTW.VTWEG
  • VAPMA.MANDT == TVTW.MANDT
Plant
  • VAPMA.MANDT == T001W.MANDT
  • VAPMA.WERKS == T001W.WERKS