SAP TFC_SORT_ITEM Structure for Table for Sorting Items Table data and field list

TFC_SORT_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure for Table for Sorting Items" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TFC_SORT_ITEM TYPE TFC_SORT_ITEM.

The TFC_SORT_ITEM table consists of various fields, each holding specific information or linking keys about Structure for Table for Sorting Items data available in SAP. These include INST_ITEM (), MANDT (Client), PROFILE (Fast Close: Task List), INSTANCE (Counter)... 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. .

TFC_SORT_ITEM structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP TFC_SORT_ITEM structure 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 TFC_SORT_ITEM 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
ITEM				0
INST_ITEM				0
MANDT	Client	MANDT	CLNT	3			MANDT
PROFILE	Fast Close: Task List	TFC_PROFILE	CHAR	10			TFC_PROFILE
INSTANCE	Counter	TFC_NUM	INT4	10			TFC_INSTANCE
NODE	Node ID	SCMA_NODE	CHAR	12			SCMA_NODE
ITEM	Node ID	SCMA_NODE	CHAR	12			SCMA_NODE
NODE_GRP	Integer for Fast Close (Node Administration)	TFC_INT	INT4	10			TFC_INT
POS	Position under a Node	TFC_POSITION	INT4	10			TFC_POSITION
GRP_PREV	Integer for Fast Close (Node Administration)	TFC_INT	INT4	10			TFC_INT
KIND	Task Type (Report, Workflow, Transaction, Note)	TFC_TASK_TYPE	CHAR	1			TFC_TASK_TYPE
REPORT	ABAP Program Name	TFC_PROGRAMM	CHAR	40			PROGRAMM
VARIANTE	Variant Name	TFC_VARIANT	CHAR	14			SELSET
SEQUENCE	Fast Close: Flow Definition	TFC_SEQUENCE	CHAR	12			TFC_SEQUENCE
TRANSACT	Fast Close: Transaction	TFC_TRANSACTION	CHAR	20			TCODE
EXE_USR	Task Processor	TFC_TASK_OWNER	CHAR	12			XUBNAME		USER_ADDR
RES_USR	Person Responsible for Task	TFC_TASK_RES	CHAR	12			XUBNAME		USER_ADDR
EXE_DAY_OFFSET	Offset in Days Relative to Key Date of a Task List	TFC_OFFSET_REL	INT4	10			TFC_OFFSET_REL
DAY_TYPE	Type of Day (Calendar Day or Working Day)	TFC_DAY_TYPE	CHAR	1			TFC_DAY_TYPE
EXE_TIME	Planned Start Time for a Task	TFC_TIME	TIMS	6			SYTIME
INACTIVE	Bool Indicator	TFC_ACTIVE	CHAR	1			TFC_ACTIVE
LOCKED	Task Completed	TFC_LOCKED	CHAR	1			TFC_ACTIVE
AUTO_VAR	Generate Variant Automatically	TFC_AUTO_VAR	CHAR	1			TFC_ACTIVE
TEXT	Description of a Folder or Task	TFC_FOLDER_TEXT	CHAR	60			TFC_FOLDER_TEXT
JOB	Task Name	TFC_JOB	CHAR	40			PROGRAMM
JOB_ID	Job ID of a Job: Unique Name	TFC_JOB_ID	NUMC	10			TFC_JOB_ID
LAUFZEIT_D	System Date	SYDATUM	DATS	8			SYDATS
LAUFZEIT_T	System Time	SYUZEIT	TIMS	6			SYTIME
DOCUMENT_ID	Business Document Service: Document ID	BDS_DOCID	CHAR	42			CHAR42
IUSAGE	Usage in Following Closing Types	TFC_USAGE	CHAR	8			TFC_USAGE
TEST_NODE	Node ID	SCMA_NODE	CHAR	12			SCMA_NODE
CRIT_PATH	Indicator: Object Belongs to Critical Path	TFC_CRIT_PATH	CHAR	1			TFC_CRIT_PATH
BATCHJOB_ID	Background job name	BTCJOB	CHAR	32			CHAR32
AGR_NAME	Role Name	AGR_NAME	CHAR	30			AGR_NAME		AGR_NAME
SAP_SCRIPT_ID	GUID in 'CHAR' Format in Uppercase	GUID_32	CHAR	32			SYSUUID_C
RT_DEF_ID	Name of Remote Task	TFC_RT_DEF_ID	CHAR	80			DBTC_EXT_SDL_NAME		BTC_EXT_JOBDEFS
RT_QUEUE	Queue of Remote Task	TFC_RT_QUEUE	CHAR	80			DBTC_EXT_SDL_NAME		BTC_EXT_QUEUES

Key field

Non-key field

< TFC_SORT_CRITERIA - For Screen for Sort Fields TFC_SORT_STRU - For Sorting Object References >

How do I retrieve data from SAP structure TFC_SORT_ITEM using ABAP code?

As TFC_SORT_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TFC_SORT_ITEM as there is no data to select.

How to access SAP table TFC_SORT_ITEM

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

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