VBKA - Sales Activities
Sales Activities information is stored in SAP table VBKA.
It is part of development package VCK in software component SD-CAS-SA. This development package consists of objects that can be grouped under "CAS - contacts".
It is part of development package VCK in software component SD-CAS-SA. This development package consists of objects that can be grouped under "CAS - contacts".
Fields for table VBKA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
VBELN | SD document no. of a sales activity in sales support | X | CAS_VBELN | CHAR | 20 | |
ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
ERZET | Entry time | ERZET | TIMS | 12 | ||
ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
AEZET | Time last change was made | AEZET | TIMS | 12 | ||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
KTAAR | Sales Activity Type for Sales Support | KTAAR | CHAR | 8 | TVKK | |
VBTYP | SD Document Category | VBTYPL | CHAR | 8 | ||
TRVOG | Transaction Group | TRVOG | CHAR | 2 | ||
VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVKOV | |
SPART | Division | SPART | CHAR | 4 | TVTA | |
VKBUR | Sales office | VKBUR | CHAR | 8 | TVKBZ | |
VKGRP | Sales group | VKGRP | CHAR | 6 | TVBVK | |
KTABG | Start of sales activity (date) | KTABG | DATS | 16 | ||
KTAEN | End of sales activity (date) | KTAEN | DATS | 16 | ||
KTABT | Start of sales activity | KTABT | TIMS | 12 | ||
KTAET | End of sales activity (time) | KTAET | TIMS | 12 | ||
KTAGR | Reason for sales activity | KTAGR | CHAR | 6 | TVC2 | |
KTAST | Status of sales activity | KTAST | CHAR | 2 | TVC3 | |
KTAER | Outcome of sales activities | KTAER | CHAR | 6 | TVC1 | |
KTAEB | Analysis of sales activity outcome | KTAEB | CHAR | 6 | TVC7 | |
KTARE | not used | UNUSEDC8 | CHAR | 16 | ||
KTAVA | not used | UNUSEDC14 | CHAR | 28 | ||
KTANR | Number of the Address List | KTANR | CHAR | 20 | ||
KTAFK | Type of follow-up activity | KTAFK | CHAR | 8 | TVKK | |
KTADA | Date of follow-up sales activity | KTADA | DATS | 16 | ||
ADRNR | Addresses: Address number of company address | CADRNR | CHAR | 20 | ||
KTARA | Description of where sales activity took place | KTARA | CHAR | 40 | ||
VGBEL | Document number of the reference document | VGBEL | CHAR | 20 | ||
KTEXT | Short text for a sales activity | KTEXT_CAS | CHAR | 80 | ||
SUBMI | Collective Number | SUBMI | CHAR | 20 | ||
VBKLA | Original system with release and transaction control | VBKLA | CHAR | 18 | ||
VBKLT | SD document indicator | VBKLT | CHAR | 2 | ||
KTA01 | Sales activity description 01 | KTA01 | CHAR | 4 | TVCA | |
KTA02 | Sales activity description 02 | KTA02 | CHAR | 4 | TVCB | |
KTA03 | Sales activity description 03 | KTA03 | CHAR | 4 | TVCC | |
KTA04 | Sales activity description 04 | KTA04 | CHAR | 4 | TVCD | |
KTA05 | Sales activity description 05 | KTA05 | CHAR | 4 | TVCE | |
KTA06 | Sales activity description 06 | KTA06 | CHAR | 6 | TVCF | |
KTA07 | Sales activity description 07 | KTA07 | CHAR | 6 | TVCG | |
KTA08 | Sales activity description 08 | KTA08 | CHAR | 6 | TVCH | |
KTA09 | Sales activity description 09 | KTA09 | CHAR | 6 | TVCI | |
KTA10 | Sales activity description 10 | KTA10 | CHAR | 6 | TVCJ | |
KUNNR | Partner number (KUNNR, LIFNR, or PERNR) | KUNDE_D | CHAR | 20 | ||
GBSTK | Overall Processing Status (Header/All Items) | GBSTK | CHAR | 2 | ||
JOBCOUNT | Job ID | BTCJOBCNT | CHAR | 16 | ||
PARVW | Partner Function | PARVW | CHAR | 4 | TPAR | |
TXT_KONSE | Text entered in document | TXT_KONSE | CHAR | 2 | ||
STAFO | Update Group for statistics update | STAFO | CHAR | 12 | ||
STR_HAS_PRI | Flag: Street has priority over PO box | AD_STRPRIO | CHAR | 2 | ||
DIRECTION | Direction of sales activity: Inbound / outbound | ACT_DIRECTION | CHAR | 2 | ||
KTAAR_CLASS | CAS: Classify sales activity types | KTAAR_CLASS | CHAR | 2 | ||
KALE | Maintain appointments in calendar | KALE | CHAR | 2 | ||
KTEXT_MC | Short Text for a Sales Activity in Uppercase Letters | KTEXT_CAS_MC | CHAR | 80 | ||
KTEXT_MC_LANGU | Language Key for Short Text | KTEXT_CAS_MC_LANG | LANG | 2 |