SAP ABAP Table VBKA (Sales Activities)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VCK (Package) CAS - contacts

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VBKA	Table Relationship Diagram
Short Description	Sales Activities

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	VBELN	☑	CAS_VBELN	VBELN	CHAR	10	0	SD document no. of a sales activity in sales support	VBUK
3	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
4	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
7	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
8	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	KTAAR	☐	KTAAR	KTAAR	CHAR	4	0	Sales Activity Type for Sales Support	TVKK
10	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
11	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
14	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
15	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
16	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
17	KTABG	☐	KTABG	KTABG	DATS	8	0	Start of sales activity (date)
18	KTAEN	☐	KTAEN	KTAEN	DATS	8	0	End of sales activity (date)
19	KTABT	☐	KTABT	KTABT	TIMS	6	0	Start of sales activity
20	KTAET	☐	KTAET	KTAET	TIMS	6	0	End of sales activity (time)
21	KTAGR	☐	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	TVC2
22	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
23	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	TVC1
24	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	TVC7
25	KTARE	☐	UNUSEDC8	CHAR8	CHAR	8	0	not used
26	KTAVA	☐	UNUSEDC14	CHAR14	CHAR	14	0	not used
27	KTANR	☐	KTANR	KTANR	CHAR	10	0	Number of the Address List
28	KTAFK	☐	KTAFK	KTAAR	CHAR	4	0	Type of follow-up activity	TVKK
29	KTADA	☐	KTADA	KTADA	DATS	8	0	Date of follow-up sales activity
30	ADRNR	☐	CADRNR	CADRNR	CHAR	10	0	Addresses: Address number of company address	*
31	KTARA	☐	KTARA	KTARA	CHAR	20	0	Description of where sales activity took place
32	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
33	KTEXT	☐	KTEXT_CAS	TEXT40	CHAR	40	0	Short text for a sales activity
34	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
35	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
36	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
37	KTA01	☐	KTA01	KTA01	CHAR	2	0	Sales activity description 01	TVCA
38	KTA02	☐	KTA02	KTA02	CHAR	2	0	Sales activity description 02	TVCB
39	KTA03	☐	KTA03	KTA03	CHAR	2	0	Sales activity description 03	TVCC
40	KTA04	☐	KTA04	KTA04	CHAR	2	0	Sales activity description 04	TVCD
41	KTA05	☐	KTA05	KTA05	CHAR	2	0	Sales activity description 05	TVCE
42	KTA06	☐	KTA06	KTA06	CHAR	3	0	Sales activity description 06	TVCF
43	KTA07	☐	KTA07	KTA07	CHAR	3	0	Sales activity description 07	TVCG
44	KTA08	☐	KTA08	KTA08	CHAR	3	0	Sales activity description 08	TVCH
45	KTA09	☐	KTA09	KTA09	CHAR	3	0	Sales activity description 09	TVCI
46	KTA10	☐	KTA10	KTA10	CHAR	3	0	Sales activity description 10	TVCJ
47	KUNNR	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
48	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
49	JOBCOUNT	☐	BTCJOBCNT	CHAR8	CHAR	8	0	Job ID
50	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
51	TXT_KONSE	☐	TXT_KONSE	FLAG	CHAR	1	0	Text entered in document
52	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
53	STR_HAS_PRI	☐	AD_STRPRIO	AD_STRPRIO	CHAR	1	0	Flag: Street has priority over PO box
54	DIRECTION	☐	ACT_DIRECTION	ACT_DIRECTION	CHAR	1	0	Direction of sales activity: Inbound / outbound
55	KTAAR_CLASS	☐	KTAAR_CLASS	KTAAR_CLASS	CHAR	1	0	CAS: Classify sales activity types
56	KALE	☐	KALE	KALE	CHAR	1	0	Maintain appointments in calendar
57	KTEXT_MC	☐	KTEXT_CAS_MC	TEXT40U	CHAR	40	0	Short Text for a Sales Activity in Uppercase Letters
58	KTEXT_MC_LANGU	☐	KTEXT_CAS_MC_LANG	SPRAS	LANG	1	0	Language Key for Short Text	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBKA	KTA01	TVCA	KTA01	REF	C	CN
2	VBKA	KTA02	TVCB	KTA02	REF	C	CN
3	VBKA	KTA03	TVCC	KTA03	REF	C	CN
4	VBKA	KTA04	TVCD	KTA04	REF	C	CN
5	VBKA	KTA05	TVCE	KTA05	REF	C	CN
6	VBKA	KTA06	TVCF	KTA06	REF	C	CN
7	VBKA	KTA07	TVCG	KTA07	REF	C	CN
8	VBKA	KTA08	TVCH	KTA08	REF	C	CN
9	VBKA	KTA09	TVCI	KTA09	REF	C	CN
10	VBKA	KTA10	TVCJ	KTA10	REF	C	CN
11	VBKA	KTAAR	TVKK	KTAAR	REF	1	CN
12	VBKA	KTAEB	TVC7	KATEB	REF	C	CN
13	VBKA	KTAER	TVC1	KTAER	REF	C	CN
14	VBKA	KTAFK	TVKK	KTAAR	REF	C	CN
15	VBKA	KTAGR	TVC2	KTAGR	REF	C	CN
16	VBKA	KTAST	TVC3	KTAST	REF	C	CN
17	VBKA	MANDT	T000	MANDT	KEY	1	CN
18	VBKA	PARVW	TPAR	PARVW	REF	C	CN
19	VBKA	SPART	TVTA	SPART	REF	1	CN
20	VBKA	VBELN	VBUK	VBELN	KEY	1	C
21	VBKA	VGBEL	VBUK	VBELN	REF	C	CN
22	VBKA	VKBUR	TVKBZ	VKBUR	REF	C	CN
23	VBKA	VKGRP	TVBVK	VKGRP	REF	C	CN
24	VBKA	VKORG	TVKO	VKORG	REF	1	CN
25	VBKA	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in