SAP ABAP Table VBKOFKA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VBKOFKA	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	VBKOFKA	KTA01	TVCA	KTA01	REF	C	CN
2	VBKOFKA	KTA02	TVCB	KTA02	REF	C	CN
3	VBKOFKA	KTA03	TVCC	KTA03	REF	C	CN
4	VBKOFKA	KTA04	TVCD	KTA04	REF	C	CN
5	VBKOFKA	KTA05	TVCE	KTA05	REF	C	CN
6	VBKOFKA	KTA06	TVCF	KTA06	REF	C	CN
7	VBKOFKA	KTA07	TVCG	KTA07	REF	C	CN
8	VBKOFKA	KTA08	TVCH	KTA08	REF	C	CN
9	VBKOFKA	KTA09	TVCI	KTA09	REF	C	CN
10	VBKOFKA	KTA10	TVCJ	KTA10	REF	C	CN
11	VBKOFKA	KTAAR	TVKK	KTAAR	KEY	1	CN
12	VBKOFKA	KTAEB	TVC7	KATEB	REF	C	CN
13	VBKOFKA	KTAER	TVC1	KTAER	REF	C	CN
14	VBKOFKA	KTAFK	TVKK	KTAAR	REF	C	CN
15	VBKOFKA	KTAGR	TVC2	KTAGR	REF	C	CN
16	VBKOFKA	KTAST	TVC3	KTAST	REF	C	CN
17	VBKOFKA	MANDT	T000	MANDT	KEY	1	CN
18	VBKOFKA	PARVW	TPAR	PARVW	KEY	1	CN
19	VBKOFKA	PARVW_VBKA	TPAR	PARVW	REF	C	CN
20	VBKOFKA	VBELN	VBKA	VBELN	KEY	1	CN
21	VBKOFKA	VGBEL	VBUK	VBELN	REF	C	CN
22	VBKOFKA	VKGRP	TVBVK	VKGRP	REF	C	CN
23	VBKOFKA	VKORG	TVKO	VKORG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in