SAP ABAP Table VAKPA (Sales Index: Orders by Partner Function)
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 VAKPA   Table Relationship Diagram
Short Description Sales Index: Orders by Partner Function    
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 KUNDE KUNDE_D KUNDE CHAR 10   0   Partner number (KUNNR, LIFNR, or PERNR)  
3 PARVW PARVW PARVW CHAR 2   0   Partner Role TPAR
4 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
5 TRVOG TRVOG TRVOG CHAR 1   0   Transaction group  
6 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
7 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
8 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
9 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
10 SPART SPART SPART CHAR 2   0   Division TSPA
11 AUART AUART AUART CHAR 4   0   Sales Document Type TVAK
12 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
13 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
14 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
15 VBELN VBELN VBELN CHAR 10   0   Sales and Distribution Document Number VBUK
16 ADRNR_AG ADRNR_AG ADRNR CHAR 10   0   Address number of the sold-to party *
17 ADRNR ADRNR ADRNR CHAR 10   0   Address *
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 VAKPA AUART TVAK AUART KEY 1 CN
2 VAKPA KUNNR KNA1 KUNNR KEY 1 CN
3 VAKPA MANDT T000 MANDT KEY 1 CN
4 VAKPA PARVW TPAR PARVW KEY 1 CN
5 VAKPA SPART TSPA SPART KEY 1 CN
6 VAKPA VBELN VBUK VBELN KEY 1 CN
7 VAKPA VKBUR TVBUR VKBUR KEY 1 CN
8 VAKPA VKGRP TVKGR VKGRP KEY 1 CN
9 VAKPA VKORG TVKO VKORG KEY 1 CN
10 VAKPA VTWEG TVTW VTWEG KEY 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 470