SAP TFC_DB_ITEM_DATA Data for Items Table data and field list

TFC_DB_ITEM_DATA 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 "Data for 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_DB_ITEM_DATA TYPE TFC_DB_ITEM_DATA.

The TFC_DB_ITEM_DATA table consists of various fields, each holding specific information or linking keys about Data for Items data available in SAP. These include POS (Position under a Node), GRP_PREV (Integer for Fast Close (Node Administration)), KIND (Task Type (Report, Workflow, Transaction, Note)), REPORT (ABAP Program Name)... 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_DB_ITEM_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP TFC_DB_ITEM_DATA 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_DB_ITEM_DATA 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
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	Assigned to domain		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	Assigned to domain		TCODE
EXE_USR	Task Processor	TFC_TASK_OWNER	CHAR	12	Assigned to domain		XUBNAME		USER_ADDR
RES_USR	Person Responsible for Task	TFC_TASK_RES	CHAR	12	Assigned to domain		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	Assigned to domain		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	Assigned to domain		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_CMPOUTPUTLIST - Output of Results TFC_DB_ITEM_KEY - Key Fields for Database >

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

As TFC_DB_ITEM_DATA 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_DB_ITEM_DATA as there is no data to select.

How to access SAP table TFC_DB_ITEM_DATA

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

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