SAP ABAP Table VBKAVB (Sales Activities ( Data Base and Dynamic Part ))

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	INTTAB	Structure
Structure	VBKAVB	Table Relationship Diagram
Short Description	Sales Activities ( Data Base and Dynamic Part )

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	500