TVKK SAP (Sales Activity Types) Table details
Dictionary Type: Table
Description: Sales Activity Types
Description: Sales Activity Types
Table field list including key, data, relationships and ABAP select examples
TVKK is a standard SAP Table which is used to store Sales Activity Types data and is available within R/3 SAP systems depending on the version and release level.
The TVKK table consists of various fields, each holding specific information or linking keys about Sales Activity Types data available in SAP. These include KTAAR (Sales Activity Type for Sales Support), KOPGR (Screen sequence group for document header & item), UEVOR (Proposal for Fcode on the overview screen), NUMKE (Number range in the case of internal number assignment).. 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. .
Delivery Class: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = TVKKT
SAP TVKK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KTAAR | Sales Activity Type for Sales Support | KTAAR | CHAR | 4 | KTAAR | VKC | H_KTAAR | ||
KOPGR | Screen sequence group for document header & item | BIFGR | CHAR | 4 | TVHB | BIFGR | |||
UEVOR | Proposal for Fcode on the overview screen | UEVOR_KA | CHAR | 20 | UEVOR_KA | ||||
NUMKE | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | TVPG | PARGR | |||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
VBOBJ | SD document object | VBOBJ | CHAR | 1 | VBOBJ | ||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | TRVOG | VTV | |||
KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | T681A | KAPPL | NA_KAPPL | ||
KSCHL | Output Type | NA_KSCHL | CHAR | 4 | Assigned to domain | KSCHL | NAC | CSH_NA_KSCHL | |
KALSM | Output determination procedure | KALSMB | CHAR | 6 | T683 | KALSM | |||
DATVO | Date proposed as valid-to date | DATVO | CHAR | 1 | DATVO | ||||
TXTGR | Text determination procedure | TXTGR | CHAR | 2 | TTXG | TXTGR | |||
AFART | Inquiry type for sales activities | KTA_AFART | CHAR | 4 | TVAK | AUART | AUART | ||
AGART | Quotation type for sales activities | KTA_AGART | CHAR | 4 | TVAK | AUART | AUART | ||
AUART | Sales order type for sales activities | KTA_AUART | CHAR | 4 | TVAK | AUART | AUART | ||
GUART | Credit memo type for sales activities | KTA_GUART | CHAR | 4 | TVAK | AUART | AUART | ||
LAART | Debit memo type for sales activities | KTA_LAART | CHAR | 4 | TVAK | AUART | AUART | ||
REART | Returns type for sales activities | KTA_REART | CHAR | 4 | TVAK | AUART | AUART | ||
SOART | Sales document type for sales activities | KTA_SOART | CHAR | 4 | TVAK | AUART | AUART | ||
KTAOR | Organizational data required for sales activites | KTAOR | CHAR | 1 | KTAOR | ||||
BEZOB | Reference mandatory | BEZOB | CHAR | 1 | BEZOB | ||||
KWIVO | Indicator for mandatory follow-up sales activity | KWIVO | CHAR | 1 | XFELD | ||||
KTAFK | Type of follow-up activity | KTAFK | CHAR | 4 | TVKK | KTAAR | |||
AUMA1 | Order type for sample enclosure for direct mailing campaign | KTA_AUMA1 | CHAR | 4 | TVAK | AUART | AUART | ||
AUMA2 | Order type for enclosures for a direct mailing campaign | KTA_AUMA2 | CHAR | 4 | TVAK | AUART | AUART | ||
KPAFK | Partner function for follow-up sales activity | KPAFK | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
STGRU | Sales activity status group | STGRU_CAS | NUMC | 3 | TVC6 | STGRU_CAS | |||
FEHGR | Incompletion procedure for sales document | FEHGR | CHAR | 2 | TVUV | FEHGR | |||
DIAFE | Dialog message for incompletion | DIAUV | CHAR | 1 | XFELD | ||||
NUMADR | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
AR_OBJECT | Document type | SAEOBJART | CHAR | 10 | TOADV | SADC10_DV | DOK | ||
TXT_KONSE | Text entered in document | TXT_KONSE | CHAR | 1 | FLAG | ||||
EXCLUDE_FC | Exclusion of Fcodes that lead to CREATE->EDIT | EXCLUDE_FC | CHAR | 1 | FLAG | ||||
STGKK | Statistics grp for sales activity processing in order header | STGKK | CHAR | 2 | TKSF | ALPHA | STGKK | ||
DIRECTION | Direction of sales activity: Inbound / outbound | ACT_DIRECTION | CHAR | 1 | ACT_DIRECTION | ||||
PA_PLTYPE | Potential planning: Planning hierarchy type | CASPA_PLTYPE | CHAR | 11 | T445P | SCTYP | PTS | ||
KALE | Maintain appointments in calendar | KALE | CHAR | 1 | KALE | ||||
FOLLOW_UP_PREF | CAS: Identify preferred follow-up action | FOLLOW_UP_PREFERENCE | CHAR | 4 | Assigned to domain | AUART | AUART | ||
KTAAR_CLASS | CAS: Classify sales activity types | KTAAR_CLASS | CHAR | 1 | KTAAR_CLASS | ||||
ABPATTERN | Action box pattern | CAS_ABPATTERN | NUMC | 4 | TVC_FOLLOW_UP | CAS_ABPATTERN | |||
.INCLU--AP | 0 | ||||||||
ISP_KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | T681A | KAPPL | NA_KAPPL | ||
ISP_KSCHL | Output Type | NA_KSCHL | CHAR | 4 | Assigned to domain | KSCHL | NAC | CSH_NA_KSCHL | |
ISP_KALSM | Output determination procedure | KALSMB | CHAR | 6 | T683 | KALSM |
Key field | Non-key field |
How do I retrieve data from SAP table TVKK using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVKK to SELECT all data from the tableDATA: WA_TVKK TYPE TVKK.
SELECT SINGLE *
FROM TVKK
INTO CORRESPONDING FIELDS OF WA_TVKK
WHERE...
How to access SAP table TVKK
Within an ECC or HANA version of SAP you can also view further information about TVKK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects