SAP CMS_TSK Tasks Table data and field list

CMS_TSK is a standard SAP Table which is used to store Tasks data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_TSK table consists of various fields, each holding specific information or linking keys about Tasks data available in SAP. These include TASK_GUID (Task GUID: Primary Key for CMS_TSK), OBJECT (Task Object), OBJECT_ID (Task's Object Identifier), TASK_PRIORITY (Task Priroity)... 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. .

CMS_TSK table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP CMS_TSK table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_TSK table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
TASK_GUID	Task GUID: Primary Key for CMS_TSK	CMS_DTE_TSK_GUID	RAW	16			SYSUUID
OBJECT	Task Object	CMS_DTE_TSK_OBJECT	CHAR	6			CMS_TSK_OBJECT
OBJECT_ID	Task's Object Identifier	CMS_DTE_TSK_OBJECT_ID	RAW	16			SYSUUID
TASK_PRIORITY	Task Priroity	CMS_DTE_TSK_PRTY	CHAR	2	TCMS_TSK_PRTY		CMS_TSK_PRTY
TASK_STATUS	Task Status	CMS_DTE_TSK_STAT	CHAR	2	TCMS_TSK_STAT		CMS_TSK_STAT
COMPL_STATUS	Completion Status of a Task	CMS_DTE_TSK_COMPL_STAT	DEC	5(2)			CMS_TSK_COMPL_STAT
START_ON	Time Stamp in short form (Local date and time/format)	CMS_DTE_TZNTSTMPSL	NUMC	15		TSTPS	TZNTSTMPSL
DUE_ON	Time Stamp in short form (Local date and time/format)	CMS_DTE_TZNTSTMPSL	NUMC	15		TSTPS	TZNTSTMPSL
REMINDER_ON	Time Stamp in short form (Local date and time/format)	CMS_DTE_TZNTSTMPSL	NUMC	15		TSTPS	TZNTSTMPSL
COMPL_ON	Time Stamp in short form (Local date and time/format)	CMS_DTE_TZNTSTMPSL	NUMC	15		TSTPS	TZNTSTMPSL
TASK_TYPE	Task Type	CMS_DTE_TSK_TYP	CHAR	6	TCMS_TSK_TYP		CMS_TSK_TYP
OWNER	Task Owner	CMS_DTE_TSK_OWNER	CHAR	12	USR02		XUBNAME
NOTE	Task Note	CMS_DTE_TSK_NOTE	CHAR	60			CMS_TEXT
CREATED_BY	Login ID of the User who created the Record	CMS_DTE_USER	CHAR	12			CMS_USER
CREATED_AT	Creation Timestamp	CMS_DTE_CREATED_AT	DEC	15			TZNTSTMPS
CHANGED_BY	Last Changed By	CMS_DTE_LAST_CHNG_USER	CHAR	12			CMS_USER
CHANGED_AT	Change Timestamp	CMS_DTE_CHANGED_AT	DEC	15			TZNTSTMPS
SOURCEOFENTRY	Source of Entry	CMS_DTE_SOURCE_OF_ENTRY	CHAR	32			CMS_SOURCE

Key field

Non-key field

< CMS_ST_TO_DUPC - Schema determination table for Scenario TO_DUPC CMTEXT - Credit Management: Texts in Credit Master Sheet >

How do I retrieve data from SAP table CMS_TSK using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_TSK to SELECT all data from the table
DATA: WA_CMS_TSK TYPE CMS_TSK.

SELECT SINGLE *
FROM CMS_TSK
INTO CORRESPONDING FIELDS OF WA_CMS_TSK
WHERE...

How to access SAP table CMS_TSK

Within an ECC or HANA version of SAP you can also view further information about CMS_TSK and the data within it using relevant transactions such as

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