SAP ABAP View VBKPAKA (CAS Sales Activities: Data Base View using VBKPA 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
⤷ 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 | VBKPAKA | |
Short Description | CAS Sales Activities: Data Base View using VBKPA and VBKA | |
Root table | VBKPA | SD index: Sales activities by partner function |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | VBKPA | VBKPA | ||
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 | VBKPA | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | VBKA | VBELN | JL | EQ | 0 | 0 | ||||
4 | VBKPA | VBELN | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VBKPA | MANDT | MANDT | Client | |||
2 | KUNDE | VBKPA | KUNDE | KUNDE_D | Partner number (KUNNR, LIFNR, or PERNR) | |||
3 | PARVW | VBKPA | PARVW | PARVW | Partner Role | |||
4 | TRVOG | VBKPA | TRVOG | TRVOG | Transaction group | |||
5 | VKORG | VBKPA | VKORG | VKORG | Sales Organization | |||
6 | KTABG | VBKPA | KTABG | KTABG | Start of sales activity (date) | |||
7 | KTAAR | VBKPA | KTAAR | KTAAR | Sales Activity Type for Sales Support | |||
8 | VBELN | VBKPA | 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
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 |