SAP Table VBKA

Sales Activities

VBKA (Sales Activities) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBKA to other SAP tables.

VBKA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN SD document no. of a sales activity in sales support CAS_VBELN VBUK CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
KTAAR Sales Activity Type for Sales Support KTAAR TVKK CHAR 4 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
TRVOG Transaction group TRVOG CHAR 1 0
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
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
KTABG Start of sales activity (date) KTABG DATS 8 0
KTAEN End of sales activity (date) KTAEN DATS 8 0
KTABT Start of sales activity KTABT TIMS 6 0
KTAET End of sales activity (time) KTAET TIMS 6 0
KTAGR Reason for sales activity KTAGR TVC2 CHAR 3 0
KTAST Status of sales activity KTAST TVC3 CHAR 1 0
KTAER Outcome of sales activities KTAER TVC1 CHAR 3 0
KTAEB Analysis of sales activity outcome KTAEB TVC7 CHAR 3 0
KTARE not used UNUSEDC8 CHAR 8 0
KTAVA not used UNUSEDC14 CHAR 14 0
KTANR Number of the Address List KTANR CHAR 10 0
KTAFK Type of follow-up activity KTAFK TVKK CHAR 4 0
KTADA Date of follow-up sales activity KTADA DATS 8 0
ADRNR Addresses: Address number of company address CADRNR CHAR 10 0
KTARA Description of where sales activity took place KTARA CHAR 20 0
VGBEL Document number of the reference document VGBEL VBUK CHAR 10 0
KTEXT Short text for a sales activity KTEXT_CAS CHAR 40 0
SUBMI Collective Number SUBMI CHAR 10 0
VBKLA Original system with release and transaction control VBKLA CHAR 9 0
VBKLT SD document indicator VBKLT CHAR 1 0
NULL 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
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
KTA01 Sales activity description 01 KTA01 TVCA CHAR 2 0
KTA02 Sales activity description 02 KTA02 TVCB CHAR 2 0
KTA03 Sales activity description 03 KTA03 TVCC CHAR 2 0
KTA04 Sales activity description 04 KTA04 TVCD CHAR 2 0
KTA05 Sales activity description 05 KTA05 TVCE CHAR 2 0
KTA06 Sales activity description 06 KTA06 TVCF CHAR 3 0
KTA07 Sales activity description 07 KTA07 TVCG CHAR 3 0
KTA08 Sales activity description 08 KTA08 TVCH CHAR 3 0
KTA09 Sales activity description 09 KTA09 TVCI CHAR 3 0
KTA10 Sales activity description 10 KTA10 TVCJ CHAR 3 0
KUNNR Partner number (KUNNR, LIFNR, or PERNR) KUNDE_D CHAR 10 0
GBSTK Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
JOBCOUNT Job ID BTCJOBCNT CHAR 8 0
PARVW Partner Function PARVW TPAR CHAR 2 0
TXT_KONSE Text entered in document TXT_KONSE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STAFO Update group for statistics update STAFO CHAR 6 0
STR_HAS_PRI Flag: Street has priority over PO box AD_STRPRIO CHAR 1 0
X Street has priority over PO box
NULL PO box has priority over street
DIRECTION Direction of sales activity: Inbound / outbound ACT_DIRECTION CHAR 1 0
0 Inbound sales activity
1 Outbound sales activity
NULL No entry
KTAAR_CLASS CAS: Classify sales activity types KTAAR_CLASS CHAR 1 0
NULL No special rule
A Partner sales activity: Sales call
B Partner sales activity: Telephone call
C Partner sales activity: Sales letter
1 Sales promotion: Direct mailing campaign
2 Sales promotion: Collectively generated partner sls activ.
KALE Maintain appointments in calendar KALE CHAR 1 0
X Yes
NULL NO
KTEXT_MC Short Text for a Sales Activity in Uppercase Letters KTEXT_CAS_MC CHAR 40 0
KTEXT_MC_LANGU Language Key for Short Text KTEXT_CAS_MC_LANG LANG 1 0

VBKA foreign key relationships

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