SAP table VBKA (Sales Activities)

SAP table VBKA has 2 primary key fields being MANDT,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
VBELN SD document no. of a sales activity in sales support CHAR 10 0 CAS_VBELN
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
KTAAR Sales Activity Type for Sales Support CHAR 4 0 TVKK KTAAR
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
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
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
VKBUR Sales office CHAR 4 0 TVKBZ VKBUR
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
KTABG Start of sales activity (date) DATS 8 0 KTABG
KTAEN End of sales activity (date) DATS 8 0 KTAEN
KTABT Start of sales activity TIMS 6 0 KTABT
KTAET End of sales activity (time) TIMS 6 0 KTAET
KTAGR Reason for sales activity CHAR 3 0 TVC2 KTAGR
KTAST Status of sales activity CHAR 1 0 TVC3 KTAST
KTAER Outcome of sales activities CHAR 3 0 TVC1 KTAER
KTAEB Analysis of sales activity outcome CHAR 3 0 TVC7 KTAEB
KTARE not used CHAR 8 0 UNUSEDC8
KTAVA not used CHAR 14 0 UNUSEDC14
KTANR Number of the Address List CHAR 10 0 KTANR
KTAFK Type of follow-up activity CHAR 4 0 TVKK KTAFK
KTADA Date of follow-up sales activity DATS 8 0 KTADA
ADRNR Addresses: Address number of company address CHAR 10 0 CADRNR
KTARA Description of where sales activity took place CHAR 20 0 KTARA
VGBEL Document number of the reference document CHAR 10 0 VGBEL
KTEXT Short text for a sales activity CHAR 40 0 KTEXT_CAS
SUBMI Collective Number CHAR 10 0 SUBMI
VBKLA Original system with release and transaction control CHAR 9 0 VBKLA
VBKLT SD document indicator CHAR 1 0 VBKLT
No classification
A Billing request (line item billing)
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
J JIT Scheduling Agt
K Correct consignment issue by external service agent
P Project-Based Services (PBS)
R Order for Billing Between Company Codes (RRICB)
S Solution Order
KTA01 Sales activity description 01 CHAR 2 0 TVCA KTA01
KTA02 Sales activity description 02 CHAR 2 0 TVCB KTA02
KTA03 Sales activity description 03 CHAR 2 0 TVCC KTA03
KTA04 Sales activity description 04 CHAR 2 0 TVCD KTA04
KTA05 Sales activity description 05 CHAR 2 0 TVCE KTA05
KTA06 Sales activity description 06 CHAR 3 0 TVCF KTA06
KTA07 Sales activity description 07 CHAR 3 0 TVCG KTA07
KTA08 Sales activity description 08 CHAR 3 0 TVCH KTA08
KTA09 Sales activity description 09 CHAR 3 0 TVCI KTA09
KTA10 Sales activity description 10 CHAR 3 0 TVCJ KTA10
KUNNR Partner number (KUNNR, LIFNR, or PERNR) CHAR 10 0 KUNDE_D
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
JOBCOUNT Job ID CHAR 8 0 BTCJOBCNT
PARVW Partner Function CHAR 2 0 TPAR PARVW
TXT_KONSE Text entered in document CHAR 1 0 TXT_KONSE
STAFO Update Group for statistics update CHAR 6 0 STAFO
STR_HAS_PRI Flag: Street has priority over PO box CHAR 1 0 AD_STRPRIO
PO box has priority over street
X Street has priority over PO box
DIRECTION Direction of sales activity: Inbound / outbound CHAR 1 0 ACT_DIRECTION
No entry
0 Inbound sales activity
1 Outbound sales activity
KTAAR_CLASS CAS: Classify sales activity types CHAR 1 0 KTAAR_CLASS
No special rule
1 Sales promotion: Direct mailing campaign
2 Sales promotion: Collectively generated partner sls activ.
A Partner sales activity: Sales call
B Partner sales activity: Telephone call
C Partner sales activity: Sales letter
KALE Maintain appointments in calendar CHAR 1 0 KALE
NO
X Yes
KTEXT_MC Short Text for a Sales Activity in Uppercase Letters CHAR 40 0 KTEXT_CAS_MC
KTEXT_MC_LANGU Language Key for Short Text LANG 1 0 KTEXT_CAS_MC_LANG

VBKA foreign key relationships

Table Field Check Table Check Field
0 VBKA KTA01 TVCA Sales Activity Description 01 MANDT
1 VBKA KTA02 TVCB Sales Activity Description 02 MANDT
0 VBKA KTA03 TVCC Sales Activity Description 03 MANDT
1 VBKA KTA04 TVCD Sales Activity Description 04 MANDT
0 VBKA KTA05 TVCE Sales Activity Description 05 MANDT
1 VBKA KTA06 TVCF Sales Activity Description 06 MANDT
0 VBKA KTA07 TVCG Sales Activity Description 07 MANDT
1 VBKA KTA08 TVCH Sales Activity Description 08 MANDT
0 VBKA KTA09 TVCI Sales Activity Description 09 MANDT
1 VBKA KTA10 TVCJ Sales Activity Description 010 MANDT
0 VBKA KTAAR TVKK Sales Activity Types MANDT
1 VBKA KTAEB TVC7 Sales Activities: Assigning Outcome Analysis to Act.Reason MANDT
1 VBKA KTAEB TVC7 Sales Activities: Assigning Outcome Analysis to Act.Reason KTAER
1 VBKA KTAEB TVC7 Sales Activities: Assigning Outcome Analysis to Act.Reason KATEB
0 VBKA KTAER TVC1 Sales Activity Outcome MANDT
1 VBKA KTAFK TVKK Sales Activity Types MANDT
0 VBKA KTAGR TVC2 Reasons for Sales Activities MANDT
1 VBKA KTAST TVC3 Sales Activity Status MANDT
1 VBKA KTAST TVC3 Sales Activity Status KTAST
0 VBKA MANDT T000 Clients MANDT
1 VBKA PARVW TPAR Business Partner: Functions PARVW
0 VBKA SPART TVTA Organizational Unit: Sales Area(s) MANDT
0 VBKA SPART TVTA Organizational Unit: Sales Area(s) VKORG
0 VBKA SPART TVTA Organizational Unit: Sales Area(s) VTWEG
0 VBKA SPART TVTA Organizational Unit: Sales Area(s) SPART
1 VBKA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
1 VBKA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
1 VBKA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
1 VBKA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
0 VBKA VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
1 VBKA VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 VBKA VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 VBKA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
0 VBKA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
0 VBKA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG