SAP table TVKK (Sales Activity Types)

SAP table TVKK has 2 primary key fields being MANDT,KTAAR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KTAAR Sales Activity Type for Sales Support CHAR 4 0 KTAAR
KOPGR Screen sequence group for document header & item CHAR 4 0 TVHB BIFGR
UEVOR Proposal for Fcode on the overview screen CHAR 20 0 UEVOR_KA
ORG1 Organizational data for sales activity
ORG2 Organizational data for direct mailing campaign
UE01 Overview screen for visit report, telephone call
UE02 Direct mail
NUMKE Number Range of Internal Number Assignment CHAR 2 0 NUMKI
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
VBOBJ SD document object CHAR 1 0 VBOBJ
A Order
B Purchase Order
F Billing Document
K Sales Activities
L Delivery
T Shipment
V Shipping
W Bulk Transportation (only IS-OIL)
X Others
TRVOG Transaction Group CHAR 1 0 TRVOG
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
P Pre-Billing Document
R Billing Document Request
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
KSCHL Output Type CHAR 4 0 NA_KSCHL
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
DATVO Proposed End Date for the Validity Period CHAR 1 0 DATVO
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 CHAR 2 0 TTXG TXTGR
AFART Inquiry type for sales activities CHAR 4 0 TVAK KTA_AFART
AGART Quotation type for sales activities CHAR 4 0 TVAK KTA_AGART
AUART Sales order type for sales activities CHAR 4 0 TVAK KTA_AUART
GUART Credit memo type for sales activities CHAR 4 0 TVAK KTA_GUART
LAART Debit memo type for sales activities CHAR 4 0 TVAK KTA_LAART
REART Returns type for sales activities CHAR 4 0 TVAK KTA_REART
SOART Sales document type for sales activities CHAR 4 0 TVAK KTA_SOART
KTAOR Organizational data required for sales activites CHAR 1 0 KTAOR
1 Sales organization, distribution channel, and division
2 Sales organization and distribution channel
3 Sales organization
4 no organizational data
BEZOB Reference Mandatory CHAR 1 0 BEZOB
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 CHAR 1 0 KWIVO
KTAFK Type of follow-up activity CHAR 4 0 TVKK KTAFK
AUMA1 Order type for sample enclosure for direct mailing campaign CHAR 4 0 TVAK KTA_AUMA1
AUMA2 Order type for enclosures for a direct mailing campaign CHAR 4 0 TVAK KTA_AUMA2
KPAFK Partner function for follow-up sales activity CHAR 2 0 TPAR KPAFK
STGRU Sales activity status group NUMC 3 0 TVC6 STGRU_CAS
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
DIAFE Dialog message for incompletion CHAR 1 0 DIAUV
NUMADR Number Range of Internal Number Assignment CHAR 2 0 NUMKI
AR_OBJECT Document type CHAR 10 0 TOADV SAEOBJART
TXT_KONSE Text entered in document CHAR 1 0 TXT_KONSE
EXCLUDE_FC Exclusion of Fcodes that lead to CREATE->EDIT CHAR 1 0 EXCLUDE_FC
STGKK Statistics grp for sales activity processing in order header CHAR 2 0 TKSF STGKK
DIRECTION Direction of sales activity: Inbound / outbound CHAR 1 0 ACT_DIRECTION
No entry
0 Inbound sales activity
1 Outbound sales activity
PA_PLTYPE Potential planning: Planning hierarchy type CHAR 11 0 T445P CASPA_PLTYPE
KALE Maintain appointments in calendar CHAR 1 0 KALE
NO
X Yes
FOLLOW_UP_PREF CAS: Identify preferred follow-up action CHAR 4 0 FOLLOW_UP_PREFERENCE
KTAAR_CLASS CAS: Classify sales activity types CHAR 1 0 KTAAR_CLASS
No special rule
1 Sales promotion: Direct mailing campaign
2 Sales promotion: Collectively generated partner sls activ.
A Partner sales activity: Sales call
B Partner sales activity: Telephone call
C Partner sales activity: Sales letter
ABPATTERN Action box pattern NUMC 4 0 TVC_FOLLOW_UP CAS_ABPATTERN

TVKK foreign key relationships

Table Field Check Table Check Field
0 TVKK ABPATTERN TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing MANDT
0 TVKK ABPATTERN TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing ABPATTERN
0 TVKK ABPATTERN TVC_FOLLOW_UP Follow-up Activities from Sales Activity Processing ABFUNCTION
1 TVKK AFART TVAK Sales Document Types MANDT
1 TVKK AFART TVAK Sales Document Types AUART
0 TVKK AGART TVAK Sales Document Types MANDT
0 TVKK AGART TVAK Sales Document Types AUART
1 TVKK AR_OBJECT TOADV SAP ArchiveLink: Global document types MANDT
1 TVKK AR_OBJECT TOADV SAP ArchiveLink: Global document types AR_OBJECT
0 TVKK AUART TVAK Sales Document Types MANDT
0 TVKK AUART TVAK Sales Document Types AUART
1 TVKK AUMA1 TVAK Sales Document Types MANDT
1 TVKK AUMA1 TVAK Sales Document Types AUART
0 TVKK AUMA2 TVAK Sales Document Types MANDT
0 TVKK AUMA2 TVAK Sales Document Types AUART
1 TVKK FEHGR TVUV Incompletion Control: Procedures MANDT
1 TVKK FEHGR TVUV Incompletion Control: Procedures FEHGR
0 TVKK GUART TVAK Sales Document Types MANDT
0 TVKK GUART TVAK Sales Document Types AUART
1 TVKK KALSM T683 Pricing procedures KAPPL
1 TVKK KALSM T683 Pricing procedures KALSM
0 TVKK KAPPL T681A Conditions: Applications KAPPL
1 TVKK KOPGR TVHB Sales Document: Screen Sequence Group MANDT
1 TVKK KOPGR TVHB Sales Document: Screen Sequence Group OBJEKT
1 TVKK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
0 TVKK KPAFK TPAR Business Partner: Functions PARVW
1 TVKK KTAFK TVKK Sales Activity Types MANDT
0 TVKK LAART TVAK Sales Document Types MANDT
0 TVKK LAART TVAK Sales Document Types AUART
1 TVKK PARGR TVPG Partner Function Groups PARGR
0 TVKK REART TVAK Sales Document Types MANDT
0 TVKK REART TVAK Sales Document Types AUART
1 TVKK SOART TVAK Sales Document Types MANDT
1 TVKK SOART TVAK Sales Document Types AUART
0 TVKK STGKK TKSF Value Table: Statistics Grp for Sls Activ. Procg in Header STGKK
1 TVKK STGRU TVC6 Sales Activity Status Groups MANDT
0 TVKK TXTGR TTXG Text Processing: Text ID Groups MANDT