SAP ABAP Table VBKA_KONTAKTE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VBKA_KONTAKTE	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNDE	☑	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
3	PARVW	☑	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
4	TRVOG	☑	TRVOG	TRVOG	CHAR	1	0	Transaction group
5	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	KTABG	☑	KTABG	KTABG	DATS	8	0	Start of sales activity (date)
7	KTAAR	☑	KTAAR	KTAAR	CHAR	4	0	Sales Activity Type for Sales Support	TVKK
8	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBKA
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
16	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
17	SPART	☐	SPART	SPART	CHAR	2	0	Division
18	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
19	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
20	KTAEN	☐	KTAEN	KTAEN	DATS	8	0	End of sales activity (date)
21	KTABT	☐	KTABT	KTABT	TIMS	6	0	Start of sales activity
22	KTAET	☐	KTAET	KTAET	TIMS	6	0	End of sales activity (time)
23	KTAGR	☐	KTAGR	KTAGR	CHAR	3	0	Reason for sales activity	TVC2
24	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
25	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	TVC1
26	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	TVC7
27	KTARE	☐	UNUSEDC8	CHAR8	CHAR	8	0	not used
28	KTAVA	☐	UNUSEDC14	CHAR14	CHAR	14	0	not used
29	KTANR	☐	KTANR	KTANR	CHAR	10	0	Number of the Address List
30	KTAFK	☐	KTAFK	KTAAR	CHAR	4	0	Type of follow-up activity	TVKK
31	KTADA	☐	KTADA	KTADA	DATS	8	0	Date of follow-up sales activity
32	ADRNR	☐	CADRNR	CADRNR	CHAR	10	0	Addresses: Address number of company address
33	KTARA	☐	KTARA	KTARA	CHAR	20	0	Description of where sales activity took place
34	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
35	KTEXT	☐	KTEXT_CAS	TEXT40	CHAR	40	0	Short text for a sales activity
36	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
37	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
38	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
39	KTA01	☐	KTA01	KTA01	CHAR	2	0	Sales activity description 01	TVCA
40	KTA02	☐	KTA02	KTA02	CHAR	2	0	Sales activity description 02	TVCB
41	KTA03	☐	KTA03	KTA03	CHAR	2	0	Sales activity description 03	TVCC
42	KTA04	☐	KTA04	KTA04	CHAR	2	0	Sales activity description 04	TVCD
43	KTA05	☐	KTA05	KTA05	CHAR	2	0	Sales activity description 05	TVCE
44	KTA06	☐	KTA06	KTA06	CHAR	3	0	Sales activity description 06	TVCF
45	KTA07	☐	KTA07	KTA07	CHAR	3	0	Sales activity description 07	TVCG
46	KTA08	☐	KTA08	KTA08	CHAR	3	0	Sales activity description 08	TVCH
47	KTA09	☐	KTA09	KTA09	CHAR	3	0	Sales activity description 09	TVCI
48	KTA10	☐	KTA10	KTA10	CHAR	3	0	Sales activity description 10	TVCJ
49	KUNNR	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
50	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
51	JOBCOUNT	☐	BTCJOBCNT	CHAR8	CHAR	8	0	Job ID
52	PARVW_VBKA	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in