SAP table VAPMA (Sales Index: Order Items by Material)

SAP table VAPMA has 15 primary key fields being MANDT,MATNR,VKORG,TRVOG,AUDAT,VTWEG,SPART,AUART,KUNNR,VKBUR,VKGRP,BSTNK,ERNAM,VBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
VKORG Sales Organization CHAR 4 0 TVKO VKORG
TRVOG Transaction Group CHAR 1 0 TRVOG
0 Sales Order
1 Inquiry
2 Quotation
3 Scheduling Agreement
4 Contract
5 Item Proposal
6 Delivery
7 Billing Documents
8 Proforma Invoices
9 Sales Activities
A Sales Promotions
B Customer Independent Requirements
D Shipping Notification
G Rough Goods Receipt
O Cost Accounting: Variance Calculation
P Pre-Billing Document
R Billing Document Request
AUDAT Document Date (Date Received/Sent) DATS 8 0 AUDAT
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
AUART Sales Document Type CHAR 4 0 TVAK AUART
KUNNR Sold-to Party CHAR 10 0 KNA1 KUNAG
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
BSTNK Customer Reference CHAR 20 0 BSTNK
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
WERKS Plant CHAR 4 0 T001W WERKS_D
ADRNR Address number of the sold-to party CHAR 10 0 ADRNR_AG
DATAB Quotation or contract valid from DATS 8 0 DATAB_VI
DATBI Quotation or contract valid to DATS 8 0 DATBI_VI
OIPBL Business location identifier (IS-Oil MRN) CHAR 10 0 OIF_PBLNR

VAPMA foreign key relationships

Table Field Check Table Check Field
0 VAPMA AUART TVAK Sales Document Types MANDT
0 VAPMA AUART TVAK Sales Document Types AUART
1 VAPMA KUNNR KNA1 General Data in Customer Master MANDT
1 VAPMA KUNNR KNA1 General Data in Customer Master KUNNR
0 VAPMA MANDT T000 Clients MANDT
1 VAPMA MATNR MARA General Material Data MANDT
1 VAPMA MATNR MARA General Material Data MATNR
0 VAPMA SPART TSPA Organizational Unit: Sales Divisions MANDT
0 VAPMA SPART TSPA Organizational Unit: Sales Divisions SPART
1 VAPMA VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 VAPMA VKGRP TVKGR Organizational Unit: Sales Groups MANDT
1 VAPMA VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 VAPMA VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 VAPMA VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 VAPMA VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 VAPMA WERKS T001W Plants/Branches WERKS