SDB_THREADS_TASKS SAP (SDB: Threads and Tasks) Structure details

Dictionary Type: Structure
Description: SDB: Threads and Tasks




ABAP Code to SELECT data from SDB_THREADS_TASKS
Related tables to SDB_THREADS_TASKS
Access table SDB_THREADS_TASKS




Structure field list including key, data, relationships and ABAP select examples

SDB_THREADS_TASKS 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 "SDB: Threads and Tasks" 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_SDB_THREADS_TASKS TYPE SDB_THREADS_TASKS.

The SDB_THREADS_TASKS table consists of various fields, each holding specific information or linking keys about SDB: Threads and Tasks data available in SAP. These include OS_PID (SAP DB: Process ID), PROCNAME (MaxDB: Name of a Thread), DISPATCHCNT (SAP DB: Counter for command calls), COMMANDCNT (SAP DB: Counter for command calls).. 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. .

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


SAP SDB_THREADS_TASKS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OS_PIDSAP DB: Process ID SADA_PIDCHAR10CHR10
PROCNAMEMaxDB: Name of a Thread SDB_THREADNAMECHAR32CHAR32
DISPATCHCNTSAP DB: Counter for command calls ADA_CCNTDEC20DEC20
COMMANDCNTSAP DB: Counter for command calls ADA_CCNTDEC20DEC20
TASKS_ACTIVNatural Number INT4INT410INT4
TASKS_TOTALNatural Number INT4INT410INT4
TASKCLUSTERCharacter field, length 64 CHAR64CHAR64CHAR64
TASKGROUPIDNatural Number INT4INT410INT4
DB_PIDNatural Number INT4INT410INT4
PROCTYPESAP DB: Process Type SADA_PTYPCHAR16CHR16
APPL_PIDNatural Number INT4INT410INT4
STATESDB Process Status SADA_PSTACHAR16CHR16
CANCELEDCarrier field for icons ICON_TEXTCHAR132SYCHAR132
SESSION_TIMEOUTSYSDBA.MONITOR.VALUE ADA_VALUEDEC20DEC20
WAITING4TASKNatural Number INT4INT410INT4
WAITING4ROOTNatural Number INT4INT410INT4
WAITING4DEVSAP DB: Volume Name SADA_DEVNCHAR64CHR64
SESSION_IDNatural Number INT4INT410INT4
TRANSCOUNTSDB Transaction Counter SADA_TCNTCHAR10CHR10
PROCESSSAP DB: Process ID SADA_PIDCHAR10CHR10
USERNAMESAP DB User Name SADA_UNAMECHAR32CHAR32
CONNDATESystem Date SYDATUMDATS8SYDATS
CONNTIMESystem Time SYUZEITTIMS6SYTIME
REQUEST_TIMEOUTSDB Timeout SADA_TOUTCHAR10CHR10
LOCKMODESDB Locking Mode SADA_MODECHAR14CHAR14
LOCKSTATESDB Lock Status SADA_STATECHAR10CHAR10
REQMODESDB Locking Mode SADA_MODECHAR14CHAR14
REQSTATESDB Lock Status SADA_STATECHAR10CHAR10
APPLPROCSAP DB: Process ID SADA_PIDCHAR10CHR10
APPL_NODESDB Node Name SADA_NODECHAR64CHR64
OMSCOMROUTINENAMEDatabase Procedure Name: SAP DB (liveCache) SDB_DBPROCCHAR32CHAR32
INFO3-Byte field CHAR3CHAR3CHAR3
STATEMENT30 Characters CHAR30CHAR30CHAR30
WP_ITYPEInternal work process type WPITYPEINT13WPITYPE
WP_TYPType WPTYPCHAR3WPTYP
WP_PIDProcess Identification WPPIDCHAR8WPPID
WP_ISTATUSWork process status WPISTATUSINT13WPISTATUS
WP_STATUSWork process status WPSTATUSCHAR7WPSTATUS
WP_IWAITReason for wait WPIWAITINGINT13WPIWAITING
WP_WAITINGWhy Work Process is Waiting WPWAITINGCHAR5WPWAITING
WP_SEMSemaphore that the work process is waiting for WPSEMCHAR2WPSEM
WP_IRESTRTRestart After Error WPIRESTARTINT13WPIRESTART
WP_RESTARTRestart work process after dump? WPRESTARTCHAR4WPRESTART
WP_DUMPSNumber of Dumps of the Work Process WPDUMPSCHAR2WPDUMPS
WP_CPUCPU WPCPUCHAR8WPCPU
WP_ELTIMEPrevious Runtime of Request (elapsed) WPELZEITCHAR6WPELZEIT
WP_MANDTClient MANDTCLNT3Assigned to domainMANDT
WP_BNAMEUser Currently Served WPBNAMECHAR12UBNAME
WP_REPORTReport now running WPREPORTCHAR40WPREPORT
WP_IACTIONCurrent activity of the work process WPIACTIONINT13INT1
WP_ACTIONCurrent Activity of the Work Process WPACTIONCHAR25WPACTION
WP_TABLEDB table last accessed by the work process WPTABLECHAR30CHAR30
WP_SERVERServer Name MSNAMECHAR20MSNAME
WP_WAITINFAdditional information about the reason for waiting WPWAITINFCHAR40WPWAITINF
WP_WAITTIMTime when waiting started WPWAITTIMECHAR8UDTIME
WP_SEMSTATInternal work process type WPITYPEINT13WPITYPE
WP_INDEXWork Process Number WPINDEXINT410WPINDEX
STUFENatural Number INT4INT410INT4

Key field Non-key field



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

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

How to access SAP table SDB_THREADS_TASKS

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!