SAP Table VBKAKOM_UPD

Communication Structure for Changing Sales Activities

VBKAKOM_UPD (Communication Structure for Changing 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 VBKAKOM_UPD to other SAP tables.

VBKAKOM_UPD table fields

Field Data element Checktable Datatype Length Decimals
REFOBJECTLOGSYS Logical system LOGSYS CHAR 10 0
REFOBJECTTYPE Object Type SWO_OBJTYP CHAR 10 0
REFOBJECTKEY Object key SWO_TYPEID CHAR 70 0
VBELN SD document no. of a sales activity in sales support CAS_VBELN CHAR 10 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
PARVW_PARNR Partner Function PARVW TPAR CHAR 2 0
PARNR Number of contact person PARNR KNVK NUMC 10 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 TVC4 CHAR 3 0
KTAFK Type of follow-up activity KTAFK TVKK CHAR 4 0
KTADA Date of follow-up sales activity KTADA DATS 8 0
KTEXT Short text for a sales activity KTEXT_CAS CHAR 40 0
KTEXT_MC_LANGU Language Key for Short Text KTEXT_CAS_MC_LANG LANG 1 0
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
TXT_KONSE Text entered in document TXT_KONSE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DIRECTION Direction of sales activity: Inbound / outbound ACT_DIRECTION CHAR 1 0
0 Inbound sales activity
1 Outbound sales activity
NULL No entry

VBKAKOM_UPD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBKAKOM_UPD KTA01 * TVCA Sales Activity Description 01 MANDT
VBKAKOM_UPD KTA01 VBKAKOM_UPD KTA01 TVCA Sales Activity Description 01 KTA01
VBKAKOM_UPD KTA02 * TVCB Sales Activity Description 02 MANDT
VBKAKOM_UPD KTA02 VBKAKOM_UPD KTA02 TVCB Sales Activity Description 02 KTA02
VBKAKOM_UPD KTA03 * TVCC Sales Activity Description 03 MANDT
VBKAKOM_UPD KTA03 VBKAKOM_UPD KTA03 TVCC Sales Activity Description 03 KTA03
VBKAKOM_UPD KTA04 * TVCD Sales Activity Description 04 MANDT
VBKAKOM_UPD KTA04 VBKAKOM_UPD KTA04 TVCD Sales Activity Description 04 KTA04
VBKAKOM_UPD KTA05 VBKAKOM_UPD KTA05 TVCE Sales Activity Description 05 KTA05
VBKAKOM_UPD KTA05 * TVCE Sales Activity Description 05 MANDT
VBKAKOM_UPD KTA06 * TVCF Sales Activity Description 06 MANDT
VBKAKOM_UPD KTA06 VBKAKOM_UPD KTA06 TVCF Sales Activity Description 06 KTA06
VBKAKOM_UPD KTA07 * TVCG Sales Activity Description 07 MANDT
VBKAKOM_UPD KTA07 VBKAKOM_UPD KTA07 TVCG Sales Activity Description 07 KTA07
VBKAKOM_UPD KTA08 * TVCH Sales Activity Description 08 MANDT
VBKAKOM_UPD KTA08 VBKAKOM_UPD KTA08 TVCH Sales Activity Description 08 KTA08
VBKAKOM_UPD KTA09 * TVCI Sales Activity Description 09 MANDT
VBKAKOM_UPD KTA09 VBKAKOM_UPD KTA09 TVCI Sales Activity Description 09 KTA09
VBKAKOM_UPD KTA10 * TVCJ Sales Activity Description 010 MANDT
VBKAKOM_UPD KTA10 VBKAKOM_UPD KTA10 TVCJ Sales Activity Description 010 KTA10
VBKAKOM_UPD KTAEB * TVC4 Sales Activity Outcome Analysis MANDT
VBKAKOM_UPD KTAEB VBKAKOM_UPD KTAEB TVC4 Sales Activity Outcome Analysis KTAEB
VBKAKOM_UPD KTAER VBKAKOM_UPD KTAER TVC1 Sales Activity Outcome KTAER
VBKAKOM_UPD KTAER * TVC1 Sales Activity Outcome MANDT
VBKAKOM_UPD KTAFK * TVKK Sales Activity Types MANDT
VBKAKOM_UPD KTAFK VBKAKOM_UPD KTAFK TVKK Sales Activity Types KTAAR
VBKAKOM_UPD KTAGR * TVC2 Reasons for Sales Activities MANDT
VBKAKOM_UPD KTAGR VBKAKOM_UPD KTAGR TVC2 Reasons for Sales Activities KTAGR
VBKAKOM_UPD KTAST * TVC3 Sales Activity Status MANDT
VBKAKOM_UPD KTAST VBKAKOM_UPD KTAST TVC3 Sales Activity Status KTAST
VBKAKOM_UPD PARNR * KNVK Customer Master Contact Partner MANDT
VBKAKOM_UPD PARNR VBKAKOM_UPD PARNR KNVK Customer Master Contact Partner PARNR
VBKAKOM_UPD PARVW_PARNR * TPAR Business Partner: Functions MANDT
VBKAKOM_UPD PARVW_PARNR VBKAKOM_UPD PARVW_PARNR TPAR Business Partner: Functions PARVW
VBKAKOM_UPD VKBUR * TVBUR Organizational Unit: Sales Offices MANDT
VBKAKOM_UPD VKBUR VBKAKOM_UPD VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
VBKAKOM_UPD VKGRP * TVKGR Organizational Unit: Sales Groups MANDT
VBKAKOM_UPD VKGRP VBKAKOM_UPD VKGRP TVKGR Organizational Unit: Sales Groups VKGRP