1. Home
  2. Resources
  3. SAP Tables
  4. TVKK - Sales Activity Types

SAP Table TVKK

Sales Activity Types

TVKK (Sales Activity Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TVKK to other SAP tables.

TVKK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KTAAR Sales Activity Type for Sales Support KTAAR CHAR 4 0
KOPGR Screen sequence group for document header & item BIFGR TVHB CHAR 4 0
UEVOR Proposal for Fcode on the overview screen UEVOR_KA CHAR 20 0
UE01 Overview screen for visit report, telephone call
UE02 Direct mail
ORG1 Organizational data for sales activity
ORG2 Organizational data for direct mailing campaign
NUMKE Number range in the case of internal number assignment NUMKI CHAR 2 0
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VBOBJ SD document object VBOBJ CHAR 1 0
A Order
B Purchase order
F Billing document
K Sales activities
L Delivery
T Shipment
V Shipping
X Others
W Bulk Transportation (only IS-OIL)
TRVOG Transaction group TRVOG CHAR 1 0
0 Sales order
1 Inquiry
2 Quotation
3 Scheduling agreement
4 Contract
5 Item proposal
6 Delivery
7 Billing documents
8 Proforma invoices
9 Sales activities
A Sales promotions
B Customer independent requirements
D Shipping notification
G Rough Goods Receipt
O Cost accounting: Variance calculation
KAPPL Application for output conditions NA_KAPPL T681A CHAR 2 0
KSCHL Output Type NA_KSCHL CHAR 4 0
KALSM Output determination procedure KALSMB T683 CHAR 6 0
DATVO Date proposed as valid-to date DATVO CHAR 1 0
NULL 31.12.9999
0 Today's date
1 End of the current month
2 End of the current year
5 No proposal
6 According to calendar
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
AFART Inquiry type for sales activities KTA_AFART TVAK CHAR 4 0
AGART Quotation type for sales activities KTA_AGART TVAK CHAR 4 0
AUART Sales order type for sales activities KTA_AUART TVAK CHAR 4 0
GUART Credit memo type for sales activities KTA_GUART TVAK CHAR 4 0
LAART Debit memo type for sales activities KTA_LAART TVAK CHAR 4 0
REART Returns type for sales activities KTA_REART TVAK CHAR 4 0
SOART Sales document type for sales activities KTA_SOART TVAK CHAR 4 0
KTAOR Organizational data required for sales activites KTAOR CHAR 1 0
1 Sales organization, distribution channel, and division
2 Sales organization and distribution channel
3 Sales organization
4 no organizational data
BEZOB Reference mandatory BEZOB CHAR 1 0
NULL No reference required
A With reference to an inquiry
B With reference to a quotation
C With reference to a sales order
E Scheduling agreement reference
G With reference to a quantity contract
M With ref.to billing document
KWIVO Indicator for mandatory follow-up sales activity KWIVO CHAR 1 0
X Yes
NULL No
KTAFK Type of follow-up activity KTAFK TVKK CHAR 4 0
AUMA1 Order type for sample enclosure for direct mailing campaign KTA_AUMA1 TVAK CHAR 4 0
AUMA2 Order type for enclosures for a direct mailing campaign KTA_AUMA2 TVAK CHAR 4 0
KPAFK Partner function for follow-up sales activity KPAFK TPAR CHAR 2 0
STGRU Sales activity status group STGRU_CAS TVC6 NUMC 3 0
FEHGR Incompletion procedure for sales document FEHGR TVUV CHAR 2 0
DIAFE Dialog message for incompletion DIAUV CHAR 1 0
X Yes
NULL No
NUMADR Number range in the case of internal number assignment NUMKI CHAR 2 0
AR_OBJECT Document type SAEOBJART TOADV CHAR 10 0
TXT_KONSE Text entered in document TXT_KONSE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EXCLUDE_FC Exclusion of Fcodes that lead to CREATE->EDIT EXCLUDE_FC CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STGKK Statistics grp for sales activity processing in order header STGKK TKSF CHAR 2 0
DIRECTION Direction of sales activity: Inbound / outbound ACT_DIRECTION CHAR 1 0
0 Inbound sales activity
1 Outbound sales activity
NULL No entry
PA_PLTYPE Potential planning: Planning hierarchy type CASPA_PLTYPE T445P CHAR 11 0
KALE Maintain appointments in calendar KALE CHAR 1 0
X Yes
NULL NO
FOLLOW_UP_PREF CAS: Identify preferred follow-up action FOLLOW_UP_PREFERENCE CHAR 4 0
KTAAR_CLASS CAS: Classify sales activity types KTAAR_CLASS CHAR 1 0
NULL No special rule
A Partner sales activity: Sales call
B Partner sales activity: Telephone call
C Partner sales activity: Sales letter
1 Sales promotion: Direct mailing campaign
2 Sales promotion: Collectively generated partner sls activ.
ABPATTERN Action box pattern CAS_ABPATTERN TVC_FOLLOW_UP NUMC 4 0
ISP_KAPPL Application for output conditions NA_KAPPL T681A CHAR 2 0
ISP_KSCHL Output Type NA_KSCHL CHAR 4 0
ISP_KALSM Output determination procedure KALSMB T683 CHAR 6 0

TVKK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVKK ABPATTERN TVKK MANDT TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing MANDT
TVKK ABPATTERN TVKK ABPATTERN TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing ABPATTERN
TVKK ABPATTERN * TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing ABFUNCTION
TVKK AFART TVKK MANDT TVAK Sales Document Types MANDT
TVKK AFART TVKK AFART TVAK Sales Document Types AUART
TVKK AGART TVKK AGART TVAK Sales Document Types AUART
TVKK AGART TVKK MANDT TVAK Sales Document Types MANDT
TVKK AR_OBJECT TVKK MANDT TOADV SAP ArchiveLink: Global document types MANDT
TVKK AR_OBJECT TVKK AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
TVKK AUART TVKK MANDT TVAK Sales Document Types MANDT
TVKK AUART TVKK AUART TVAK Sales Document Types AUART
TVKK AUMA1 TVKK MANDT TVAK Sales Document Types MANDT
TVKK AUMA1 TVKK AUMA1 TVAK Sales Document Types AUART
TVKK AUMA2 TVKK AUMA2 TVAK Sales Document Types AUART
TVKK AUMA2 TVKK MANDT TVAK Sales Document Types MANDT
TVKK FEHGR TVKK MANDT TVUV Incompletion Control: Procedures MANDT
TVKK FEHGR TVKK FEHGR TVUV Incompletion Control: Procedures FEHGR
TVKK GUART TVKK MANDT TVAK Sales Document Types MANDT
TVKK GUART TVKK GUART TVAK Sales Document Types AUART
TVKK ISP_KALSM TVKK MANDT T683 Pricing procedures MANDT
TVKK ISP_KALSM 'B' T683 Pricing procedures KVEWE
TVKK ISP_KALSM TVKK ISP_KAPPL T683 Pricing procedures KAPPL
TVKK ISP_KALSM TVKK ISP_KALSM T683 Pricing procedures KALSM
TVKK ISP_KAPPL TVKK ISP_KAPPL T681A Conditions: Applications KAPPL
TVKK KALSM TVKK MANDT T683 Pricing procedures MANDT
TVKK KALSM 'B' T683 Pricing procedures KVEWE
TVKK KALSM TVKK KAPPL T683 Pricing procedures KAPPL
TVKK KALSM TVKK KALSM T683 Pricing procedures KALSM
TVKK KAPPL TVKK KAPPL T681A Conditions: Applications KAPPL
TVKK KOPGR TVKK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
TVKK KOPGR TVKK MANDT TVHB Sales Document: Screen Sequence Group MANDT
TVKK KOPGR TTAB OBJEKT_BCF TVHB Sales Document: Screen Sequence Group OBJEKT
TVKK KPAFK TVKK MANDT TPAR Business Partner: Functions MANDT
TVKK KPAFK TVKK KPAFK TPAR Business Partner: Functions PARVW
TVKK KTAFK TVKK MANDT TVKK Sales Activity Types MANDT
TVKK KTAFK TVKK KTAFK TVKK Sales Activity Types KTAAR
TVKK LAART TVKK MANDT TVAK Sales Document Types MANDT
TVKK LAART TVKK LAART TVAK Sales Document Types AUART
TVKK MANDT TVKK MANDT T000 Clients MANDT
TVKK PARGR TVKK MANDT TVPG Partner Function Groups MANDT
TVKK PARGR TVKK PARGR TVPG Partner Function Groups PARGR
TVKK PA_PLTYPE TVKK PA_PLTYPE T445P Planning Types: LIS/SOP SCTYP
TVKK REART TVKK MANDT TVAK Sales Document Types MANDT
TVKK REART TVKK REART TVAK Sales Document Types AUART
TVKK SOART TVKK MANDT TVAK Sales Document Types MANDT
TVKK SOART TVKK SOART TVAK Sales Document Types AUART
TVKK STGKK TVKK MANDT TKSF Value Table: Statistics Grp for Sls Activ. Procg in Header MANDT
TVKK STGKK TVKK STGKK TKSF Value Table: Statistics Grp for Sls Activ. Procg in Header STGKK
TVKK STGRU TVKK STGRU TVC6 Sales Activity Status Groups STGRU
TVKK STGRU TVKK MANDT TVC6 Sales Activity Status Groups MANDT
TVKK TXTGR 'VBKA' TTXG Text Processing: Text ID Groups TDOBJECT
TVKK TXTGR TVKK TXTGR TTXG Text Processing: Text ID Groups TXTGR
TVKK TXTGR TVKK MANDT TTXG Text Processing: Text ID Groups MANDT