SAP ABAP Table VAPMA (Sales Index: Order Items by Material)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VA (Package) Application development R/3 Sales
Basic Data
Table Category TRANSP    Transparent table 
Transparent table VAPMA   Table Relationship Diagram
Short Description Sales Index: Order Items by Material    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
3 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
4 TRVOG TRVOG TRVOG CHAR 1   0   Transaction group  
5 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
6 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
7 SPART SPART SPART CHAR 2   0   Division TSPA
8 AUART AUART AUART CHAR 4   0   Sales Document Type TVAK
9 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
10 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
11 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
12 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
13 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
14 VBELN VBELN VBELN CHAR 10   0   Sales and Distribution Document Number VBUK
15 POSNR POSNR POSNR NUMC 6   0   Item number of the SD document VBUP
16 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
17 ADRNR ADRNR_AG ADRNR CHAR 10   0   Address number of the sold-to party *
18 DATAB DATAB_VI DATUM DATS 8   0   Quotation or contract valid from  
19 DATBI DATBI_VI DATUM DATS 8   0   Quotation or contract valid to  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VAPMA AUART TVAK AUART KEY 1 CN
2 VAPMA KUNNR KNA1 KUNNR KEY 1 CN
3 VAPMA MANDT T000 MANDT KEY 1 CN
4 VAPMA MATNR MARA MATNR KEY 1 CN
5 VAPMA POSNR VBUP POSNR KEY 1 CN
6 VAPMA SPART TSPA SPART KEY 1 CN
7 VAPMA VBELN VBUK VBELN KEY 1 CN
8 VAPMA VKBUR TVBUR VKBUR KEY 1 CN
9 VAPMA VKGRP TVKGR VKGRP KEY 1 CN
10 VAPMA VKORG TVKO VKORG KEY 1 CN
11 VAPMA VTWEG TVTW VTWEG KEY 1 CN
12 VAPMA WERKS T001W WERKS REF C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in