Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

KTAAR

Sales Activity Type for Sales Support

KTAAR

CHAR

KOPGR

Screen sequence group for document header & item

BIFGR

TVHB

CHAR

UEVOR

Proposal for Fcode on the overview screen

UEVOR_KA

CHAR

Value	Description
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

PARGR

Partner Determination Procedure

PARGR

TVPG

CHAR

VBTYP

SD document category

VBTYP

CHAR

Value	Description
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
NULL	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

Value	Description
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

Value	Description
NULL	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

KSCHL

Output Type

NA_KSCHL

CHAR

KALSM

Output determination procedure

KALSMB

T683

CHAR

DATVO

Date proposed as valid-to date

DATVO

CHAR

Value	Description
NULL	31.12.9999
NULL	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

AFART

Inquiry type for sales activities

KTA_AFART

TVAK

CHAR

AGART

Quotation type for sales activities

KTA_AGART

TVAK

CHAR

AUART

Sales order type for sales activities

KTA_AUART

TVAK

CHAR

GUART

Credit memo type for sales activities

KTA_GUART

TVAK

CHAR

LAART

Debit memo type for sales activities

KTA_LAART

TVAK

CHAR

REART

Returns type for sales activities

KTA_REART

TVAK

CHAR

SOART

Sales document type for sales activities

KTA_SOART

TVAK

CHAR

KTAOR

Organizational data required for sales activites

KTAOR

CHAR

Value	Description
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

Value	Description
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

Value	Description
X	Yes
NULL	No

KTAFK

Type of follow-up activity

KTAFK

TVKK

CHAR

AUMA1

Order type for sample enclosure for direct mailing campaign

KTA_AUMA1

TVAK

CHAR

AUMA2

Order type for enclosures for a direct mailing campaign

KTA_AUMA2

TVAK

CHAR

KPAFK

Partner function for follow-up sales activity

KPAFK

TPAR

CHAR

STGRU

Sales activity status group

STGRU_CAS

TVC6

NUMC

FEHGR

Incompletion procedure for sales document

FEHGR

TVUV

CHAR

DIAFE

Dialog message for incompletion

DIAUV

CHAR

Value	Description
X	Yes
NULL	No

NUMADR

Number range in the case of internal number assignment

NUMKI

CHAR

AR_OBJECT

Document type

SAEOBJART

TOADV

CHAR

TXT_KONSE

Text entered in document

TXT_KONSE

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

EXCLUDE_FC

Exclusion of Fcodes that lead to CREATE->EDIT

EXCLUDE_FC

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

STGKK

Statistics grp for sales activity processing in order header

STGKK

TKSF

CHAR

DIRECTION

Direction of sales activity: Inbound / outbound

ACT_DIRECTION

CHAR

Value	Description
NULL	Inbound sales activity
1	Outbound sales activity
NULL	No entry

PA_PLTYPE

Potential planning: Planning hierarchy type

CASPA_PLTYPE

T445P

CHAR

KALE

Maintain appointments in calendar

KALE

CHAR

Value	Description
X	Yes
NULL	NO

FOLLOW_UP_PREF

CAS: Identify preferred follow-up action

FOLLOW_UP_PREFERENCE

CHAR

KTAAR_CLASS

CAS: Classify sales activity types

KTAAR_CLASS

CHAR

Value	Description
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

ISP_KAPPL

Application for output conditions

NA_KAPPL

T681A

CHAR

ISP_KSCHL

Output Type

NA_KSCHL

CHAR

ISP_KALSM

Output determination procedure

KALSMB

T683

CHAR

TVKK foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
TVKK	ABPATTERN	*		TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing	ABFUNCTION
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	AFART	TVKK	AFART	TVAK Sales Document Types	AUART
TVKK	AFART	TVKK	MANDT	TVAK Sales Document Types	MANDT
TVKK	AGART	TVKK	MANDT	TVAK Sales Document Types	MANDT
TVKK	AGART	TVKK	AGART	TVAK Sales Document Types	AUART
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	MANDT	TVAK Sales Document Types	MANDT
TVKK	AUMA2	TVKK	AUMA2	TVAK Sales Document Types	AUART
TVKK	FEHGR	TVKK	MANDT	TVUV Incompletion Control: Procedures	MANDT
TVKK	FEHGR	TVKK	FEHGR	TVUV Incompletion Control: Procedures	FEHGR
TVKK	GUART	TVKK	GUART	TVAK Sales Document Types	AUART
TVKK	GUART	TVKK	MANDT	TVAK Sales Document Types	MANDT
TVKK	ISP_KALSM	TVKK	ISP_KAPPL	T683 Pricing procedures	KAPPL
TVKK	ISP_KALSM	TVKK	ISP_KALSM	T683 Pricing procedures	KALSM
TVKK	ISP_KALSM	TVKK	MANDT	T683 Pricing procedures	MANDT
TVKK	ISP_KALSM	'B'		T683 Pricing procedures	KVEWE
TVKK	ISP_KAPPL	TVKK	ISP_KAPPL	T681A Conditions: Applications	KAPPL
TVKK	KALSM	TVKK	KALSM	T683 Pricing procedures	KALSM
TVKK	KALSM	TVKK	MANDT	T683 Pricing procedures	MANDT
TVKK	KALSM	'B'		T683 Pricing procedures	KVEWE
TVKK	KALSM	TVKK	KAPPL	T683 Pricing procedures	KAPPL
TVKK	KAPPL	TVKK	KAPPL	T681A Conditions: Applications	KAPPL
TVKK	KOPGR	TVKK	MANDT	TVHB Sales Document: Screen Sequence Group	MANDT
TVKK	KOPGR	TTAB	OBJEKT_BCF	TVHB Sales Document: Screen Sequence Group	OBJEKT
TVKK	KOPGR	TVKK	KOPGR	TVHB Sales Document: Screen Sequence Group	BIFGR
TVKK	KPAFK	TVKK	MANDT	TPAR Business Partner: Functions	MANDT
TVKK	KPAFK	TVKK	KPAFK	TPAR Business Partner: Functions	PARVW
TVKK	KTAFK	TVKK	KTAFK	TVKK Sales Activity Types	KTAAR
TVKK	KTAFK	TVKK	MANDT	TVKK Sales Activity Types	MANDT
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	SOART	TVAK Sales Document Types	AUART
TVKK	SOART	TVKK	MANDT	TVAK Sales Document Types	MANDT
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	MANDT	TVC6 Sales Activity Status Groups	MANDT
TVKK	STGRU	TVKK	STGRU	TVC6 Sales Activity Status Groups	STGRU
TVKK	TXTGR	TVKK	MANDT	TTXG Text Processing: Text ID Groups	MANDT
TVKK	TXTGR	'VBKA'		TTXG Text Processing: Text ID Groups	TDOBJECT
TVKK	TXTGR	TVKK	TXTGR	TTXG Text Processing: Text ID Groups	TXTGR