SAP table VBKPA (SD index: Sales activities by partner function)

SAP table VBKPA has 8 primary key fields being MANDT,KUNDE,PARVW,TRVOG,VKORG,KTABG,KTAAR,VBELN.

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
KUNDE Partner number (KUNNR, LIFNR, or PERNR) CHAR 10 0 KUNDE_D
PARVW Partner Function CHAR 2 0 TPAR PARVW
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
VKORG Sales Organization CHAR 4 0 TVKO VKORG
KTABG Start of sales activity (date) DATS 8 0 KTABG
KTAAR Sales Activity Type for Sales Support CHAR 4 0 TVKK KTAAR
VBELN Sales and Distribution Document Number CHAR 10 0 VBKA VBELN

VBKPA foreign key relationships

Table Field Check Table Check Field
0 VBKPA KTAAR TVKK Sales Activity Types MANDT
1 VBKPA MANDT T000 Clients MANDT
0 VBKPA PARVW TPAR Business Partner: Functions PARVW
1 VBKPA VBELN VBKA Sales Activities MANDT
1 VBKPA VBELN VBKA Sales Activities VBELN
0 VBKPA VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 VBKPA VKORG TVKO Organizational Unit: Sales Organizations VKORG