TVKK SAP (Sales Activity Types) Table details

Dictionary Type: Table
Description: Sales Activity Types




ABAP Code to SELECT data from TVKK
Related tables to TVKK
Access table TVKK




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 Update
Display/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
MANDTClient MANDTCLNT3T000MANDT
KTAARSales Activity Type for Sales Support KTAARCHAR4KTAARVKCH_KTAAR
KOPGRScreen sequence group for document header & item BIFGRCHAR4TVHBBIFGR
UEVORProposal for Fcode on the overview screen UEVOR_KACHAR20UEVOR_KA
NUMKENumber range in the case of internal number assignment NUMKICHAR2NUMKR
PARGRPartner Determination Procedure PARGRCHAR4TVPGPARGR
VBTYPSD document category VBTYPCHAR1VBTYP
VBOBJSD document object VBOBJCHAR1VBOBJ
TRVOGTransaction group TRVOGCHAR1TRVOGVTV
KAPPLApplication for output conditions NA_KAPPLCHAR2T681AKAPPLNA_KAPPL
KSCHLOutput Type NA_KSCHLCHAR4Assigned to domainKSCHLNACCSH_NA_KSCHL
KALSMOutput determination procedure KALSMBCHAR6T683KALSM
DATVODate proposed as valid-to date DATVOCHAR1DATVO
TXTGRText determination procedure TXTGRCHAR2TTXGTXTGR
AFARTInquiry type for sales activities KTA_AFARTCHAR4TVAKAUARTAUART
AGARTQuotation type for sales activities KTA_AGARTCHAR4TVAKAUARTAUART
AUARTSales order type for sales activities KTA_AUARTCHAR4TVAKAUARTAUART
GUARTCredit memo type for sales activities KTA_GUARTCHAR4TVAKAUARTAUART
LAARTDebit memo type for sales activities KTA_LAARTCHAR4TVAKAUARTAUART
REARTReturns type for sales activities KTA_REARTCHAR4TVAKAUARTAUART
SOARTSales document type for sales activities KTA_SOARTCHAR4TVAKAUARTAUART
KTAOROrganizational data required for sales activites KTAORCHAR1KTAOR
BEZOBReference mandatory BEZOBCHAR1BEZOB
KWIVOIndicator for mandatory follow-up sales activity KWIVOCHAR1XFELD
KTAFKType of follow-up activity KTAFKCHAR4TVKKKTAAR
AUMA1Order type for sample enclosure for direct mailing campaign KTA_AUMA1CHAR4TVAKAUARTAUART
AUMA2Order type for enclosures for a direct mailing campaign KTA_AUMA2CHAR4TVAKAUARTAUART
KPAFKPartner function for follow-up sales activity KPAFKCHAR2TPARPARVWPARVWPAR
STGRUSales activity status group STGRU_CASNUMC3TVC6STGRU_CAS
FEHGRIncompletion procedure for sales document FEHGRCHAR2TVUVFEHGR
DIAFEDialog message for incompletion DIAUVCHAR1XFELD
NUMADRNumber range in the case of internal number assignment NUMKICHAR2NUMKR
AR_OBJECTDocument type SAEOBJARTCHAR10TOADVSADC10_DVDOK
TXT_KONSEText entered in document TXT_KONSECHAR1FLAG
EXCLUDE_FCExclusion of Fcodes that lead to CREATE->EDIT EXCLUDE_FCCHAR1FLAG
STGKKStatistics grp for sales activity processing in order header STGKKCHAR2TKSFALPHASTGKK
DIRECTIONDirection of sales activity: Inbound / outbound ACT_DIRECTIONCHAR1ACT_DIRECTION
PA_PLTYPEPotential planning: Planning hierarchy type CASPA_PLTYPECHAR11T445PSCTYPPTS
KALEMaintain appointments in calendar KALECHAR1KALE
FOLLOW_UP_PREFCAS: Identify preferred follow-up action FOLLOW_UP_PREFERENCECHAR4Assigned to domainAUARTAUART
KTAAR_CLASSCAS: Classify sales activity types KTAAR_CLASSCHAR1KTAAR_CLASS
ABPATTERNAction box pattern CAS_ABPATTERNNUMC4TVC_FOLLOW_UPCAS_ABPATTERN
.INCLU--AP 0
ISP_KAPPLApplication for output conditions NA_KAPPLCHAR2T681AKAPPLNA_KAPPL
ISP_KSCHLOutput Type NA_KSCHLCHAR4Assigned to domainKSCHLNACCSH_NA_KSCHL
ISP_KALSMOutput determination procedure KALSMBCHAR6T683KALSM

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 table
DATA: 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 as

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!