SAP ABAP View VBKOFKA (CAS: Open Sales Act.: Data Base View using VBKOF and VBKA)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

View Type	D	Database View
Database View	VBKOFKA
Short Description	CAS: Open Sales Act.: Data Base View using VBKOF and VBKA
Root table	VBKOF	SD index: Open sales activities by partner function

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBKOF	VBKOF
2	VBKA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBKA	MANDT	JL	EQ				0	0
2	VBKOF	MANDT	JR	EQ			AND	0	0
3	VBKA	VBELN	JL	EQ				0	0
4	VBKOF	VBELN	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in