SAP ABAP Table VBKON (Reporting View of Sales Activities)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-CAS (Application Component) Sales Support
     ⤷ VCR (Package) CAS - reporting

Basic Data

Table Category	INTTAB	Structure
Structure	VBKON	Table Relationship Diagram
Short Description	Reporting View of Sales Activities

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	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
2	PARNR	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
3	SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
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	*
11	ARTXT	☐	KTTXT	TEXT20	CHAR	20	0	Longtext for sales activity type
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
14	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
15	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
16	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
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	*
22	STTXT	☐	KGTXT	TEXT20	CHAR	20	0	Longtext for sales activity reason
23	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	*
24	KSTTXT	☐	STTTXT	TEXT20	CHAR	20	0	Sales activity status long text
25	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	*
26	ERTXT	☐	KRTXT	TEXT20	CHAR	20	0	Longtext for outcome of sales activity
27	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	*
28	EBTXT	☐	KBTXT	TEXT20	CHAR	20	0	Longtext for reason for sales activity outcome
29	KTARE	☐	KTARE	PROGRAMM	CHAR	40	0	Report for sales activities, mailing etc.	*
30	KTAVA	☐	KTAVA	VARIANT	CHAR	14	0	Variants for sales activities, mailing, etc...	*
31	KTANR	☐	KTANR	KTANR	CHAR	10	0	Number of the Address List
32	KTAFK	☐	KTAFK	KTAAR	CHAR	4	0	Type of follow-up activity	*
33	KTADA	☐	KTADA	KTADA	DATS	8	0	Date of follow-up sales activity
34	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
35	KTARA	☐	KTARA	KTARA	CHAR	20	0	Description of where sales activity took place
36	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
37	KTEXT	☐	KTEXT_CAS	TEXT40	CHAR	40	0	Short text for a sales activity
38	KTA01	☐	KTA01	KTA01	CHAR	2	0	Sales activity description 01	*
39	KTA02	☐	KTA02	KTA02	CHAR	2	0	Sales activity description 02	*
40	KTA03	☐	KTA03	KTA03	CHAR	2	0	Sales activity description 03	*
41	KTA04	☐	KTA04	KTA04	CHAR	2	0	Sales activity description 04	*
42	KTA05	☐	KTA05	KTA05	CHAR	2	0	Sales activity description 05	*
43	KTA06	☐	KTA06	KTA06	CHAR	3	0	Sales activity description 06	*
44	KTA07	☐	KTA07	KTA07	CHAR	3	0	Sales activity description 07	*
45	KTA08	☐	KTA08	KTA08	CHAR	3	0	Sales activity description 08	*
46	KTA09	☐	KTA09	KTA09	CHAR	3	0	Sales activity description 09	*
47	KTA10	☐	KTA10	KTA10	CHAR	3	0	Sales activity description 10	*
48	GBSTK	☐	STATUS_VB	STATV	CHAR	1	0	Status of the document
49	STATU	☐	STATS	TEXT20	CHAR	20	0	Document status
50	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
51	KNAME	☐	NAME1	TEXT30	CHAR	30	0	Name
52	KORT	☐	ORT	TEXT30	CHAR	30	0	City where company is located
53	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
54	PNAME	☐	PVNAM	TEXT30	CHAR	30	0	Name of partner
55	ACTIV	☐	ACTIV	NUM02	NUMC	2	0	List Level in which the Line Item is Active
56	.INCLUDE	☐				0	0	Customer Reserves for VBKON
57	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20110901
SAP Release Created in