SAP VBKON Reporting View of Sales Activities Table data and field list

VBKON is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Reporting View of Sales Activities" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VBKON TYPE VBKON.

The VBKON table consists of various fields, each holding specific information or linking keys about Reporting View of Sales Activities data available in SAP. These include PARNR (Partner number (KUNNR, LIFNR, or PERNR)), SELKZ (Selection indicator for list screens), ERDAT (Date on Which Record Was Created), ERZET (Entry time)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VBKON structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP VBKON structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VBKON table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
VBELN	Sales and Distribution Document Number	VBELN	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
PARNR	Partner number (KUNNR, LIFNR, or PERNR)	KUNDE_D	CHAR	10		ALPHA	KUNDE
SELKZ	Selection indicator for list screens	SELKZ_LIST	CHAR	1			SELKZ
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
ERZET	Entry time	ERZET	TIMS	6			UZEIT
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
AEDAT	Changed On	AEDAT	DATS	8			DATUM
AEZET	Time last change was made	AEZET	TIMS	6			UZEIT
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
KTAAR	Sales Activity Type for Sales Support	KTAAR	CHAR	4	Assigned to domain		KTAAR	VKC	H_KTAAR
ARTXT	Longtext for sales activity type	KTTXT	CHAR	20			TEXT20
VKORG	Sales Organization	VKORG	CHAR	4	Assigned to domain		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	Assigned to domain		VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2	Assigned to domain		SPART	SPA	C_SPART
VKBUR	Sales Office	VKBUR	CHAR	4	Assigned to domain		VKBUR	VKB
VKGRP	Sales Group	VKGRP	CHAR	3	Assigned to domain		VKGRP	VKG
KTABG	Start of sales activity (date)	KTABG	DATS	8			KTABG
KTAEN	End of sales activity (date)	KTAEN	DATS	8			KTAEN
KTABT	Start of sales activity	KTABT	TIMS	6			KTABT
KTAET	End of sales activity (time)	KTAET	TIMS	6			KTAET
KTAGR	Reason for sales activity	KTAGR	CHAR	3	Assigned to domain		KTAGR
STTXT	Longtext for sales activity reason	KGTXT	CHAR	20			TEXT20
KTAST	Status of sales activity	KTAST	CHAR	1	Assigned to domain		KTAST
KSTTXT	Sales activity status long text	STTTXT	CHAR	20			TEXT20
KTAER	Outcome of sales activities	KTAER	CHAR	3	Assigned to domain		KTAER
ERTXT	Longtext for outcome of sales activity	KRTXT	CHAR	20			TEXT20
KTAEB	Analysis of sales activity outcome	KTAEB	CHAR	3	Assigned to domain		KTAEB
EBTXT	Longtext for reason for sales activity outcome	KBTXT	CHAR	20			TEXT20
KTARE	Report for sales activities, mailing etc.	KTARE	CHAR	40	Assigned to domain		PROGRAMM
KTAVA	Variants for sales activities, mailing, etc...	KTAVA	CHAR	14	Assigned to domain		VARIANT
KTANR	Number of the Address List	KTANR	CHAR	10			KTANR
KTAFK	Type of follow-up activity	KTAFK	CHAR	4	Assigned to domain		KTAAR
KTADA	Date of follow-up sales activity	KTADA	DATS	8			KTADA
ADRNR	Address	ADRNR	CHAR	10	Assigned to domain	ALPHA	ADRNR
KTARA	Description of where sales activity took place	KTARA	CHAR	20			KTARA
VGBEL	Document number of the reference document	VGBEL	CHAR	10	Assigned to domain	ALPHA	VBELN
KTEXT	Short text for a sales activity	KTEXT_CAS	CHAR	40			TEXT40
KTA01	Sales activity description 01	KTA01	CHAR	2	Assigned to domain		KTA01
KTA02	Sales activity description 02	KTA02	CHAR	2	Assigned to domain		KTA02
KTA03	Sales activity description 03	KTA03	CHAR	2	Assigned to domain		KTA03
KTA04	Sales activity description 04	KTA04	CHAR	2	Assigned to domain		KTA04
KTA05	Sales activity description 05	KTA05	CHAR	2	Assigned to domain		KTA05
KTA06	Sales activity description 06	KTA06	CHAR	3	Assigned to domain		KTA06
KTA07	Sales activity description 07	KTA07	CHAR	3	Assigned to domain		KTA07
KTA08	Sales activity description 08	KTA08	CHAR	3	Assigned to domain		KTA08
KTA09	Sales activity description 09	KTA09	CHAR	3	Assigned to domain		KTA09
KTA10	Sales activity description 10	KTA10	CHAR	3	Assigned to domain		KTA10
GBSTK	Status of the document	STATUS_VB	CHAR	1			STATV
STATU	Document status	STATS	CHAR	20			TEXT20
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
KNAME	Name	NAME1	CHAR	30			TEXT30
KORT	City where company is located	ORT	CHAR	30			TEXT30
PARVW	Partner Function	PARVW	CHAR	2	Assigned to domain	PARVW	PARVW	PAR
PNAME	Name of partner	PVNAM	CHAR	30			TEXT30
ACTIV	List Level in which the Line Item is Active	ACTIV	NUMC	2			NUM02
DUMMY	Dummy function in length 1	DUMMY	CHAR	1			DUMMY

Key field

Non-key field

< VBKOK - Confirming Picking Data from Delivery Header VBKONZ - Customer Reserves for VBKON >

How do I retrieve data from SAP structure VBKON using ABAP code?

As VBKON is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VBKON as there is no data to select.

How to access SAP table VBKON

Within an ECC or HANA version of SAP you can also view further information about VBKON and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).