SAP ABAP Table SDB_THREADS_TASKS (SDB: Threads and Tasks)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SDB (Application Component) MaxDB
     ⤷ SADA (Package) Porting and CCMS SAP DB

Basic Data

Table Category	INTTAB	Structure
Structure	SDB_THREADS_TASKS	Table Relationship Diagram
Short Description	SDB: Threads and Tasks

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	SDB: Threads
2	OS_PID	☐	SADA_PID	CHR10	CHAR	10	0	SAP DB: Process ID
3	PROCNAME	☐	SDB_THREADNAME	CHAR32	CHAR	32	0	MaxDB: Name of a Thread
4	DISPATCHCNT	☐	ADA_CCNT	DEC20	DEC	20	0	SAP DB: Counter for command calls
5	COMMANDCNT	☐	ADA_CCNT	DEC20	DEC	20	0	SAP DB: Counter for command calls
6	TASKS_ACTIV	☐	INT4	INT4	INT4	10	0	Natural number
7	TASKS_TOTAL	☐	INT4	INT4	INT4	10	0	Natural number
8	TASKCLUSTER	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64
9	TASKGROUPID	☐	INT4	INT4	INT4	10	0	Natural number
10	DB_PID	☐	INT4	INT4	INT4	10	0	Natural number
11	PROCTYPE	☐	SADA_PTYP	CHR16	CHAR	16	0	SAP DB: Process Type
12	APPL_PID	☐	INT4	INT4	INT4	10	0	Natural number
13	STATE	☐	SADA_PSTA	CHR16	CHAR	16	0	SDB Process Status
14	CANCELED	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
15	SESSION_TIMEOUT	☐	ADA_VALUE	DEC20	DEC	20	0	SYSDBA.MONITOR.VALUE
16	WAITING4TASK	☐	INT4	INT4	INT4	10	0	Natural number
17	WAITING4ROOT	☐	INT4	INT4	INT4	10	0	Natural number
18	WAITING4DEV	☐	SADA_DEVN	CHR64	CHAR	64	0	SAP DB: Volume Name
19	SESSION_ID	☐	INT4	INT4	INT4	10	0	Natural number
20	TRANSCOUNT	☐	SADA_TCNT	CHR10	CHAR	10	0	SDB Transaction Counter
21	PROCESS	☐	SADA_PID	CHR10	CHAR	10	0	SAP DB: Process ID
22	USERNAME	☐	SADA_UNAME	CHAR32	CHAR	32	0	SAP DB User Name
23	CONNDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
24	CONNTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
25	REQUEST_TIMEOUT	☐	SADA_TOUT	CHR10	CHAR	10	0	SDB Timeout
26	LOCKMODE	☐	SADA_MODE	CHAR14	CHAR	14	0	SDB Locking Mode
27	LOCKSTATE	☐	SADA_STATE	CHAR10	CHAR	10	0	SDB Lock Status
28	REQMODE	☐	SADA_MODE	CHAR14	CHAR	14	0	SDB Locking Mode
29	REQSTATE	☐	SADA_STATE	CHAR10	CHAR	10	0	SDB Lock Status
30	APPLPROC	☐	SADA_PID	CHR10	CHAR	10	0	SAP DB: Process ID
31	APPL_NODE	☐	SADA_NODE	CHR64	CHAR	64	0	SDB Node Name
32	OMSCOMROUTINENAME	☐	SDB_DBPROC	CHAR32	CHAR	32	0	Database Procedure Name: SAP DB (liveCache)
33	INFO	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
34	STATEMENT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
35	WP_ITYPE	☐	WPITYPE	WPITYPE	INT1	3	0	Internal work process type
36	WP_TYP	☐	WPTYP	WPTYP	CHAR	3	0	Type
37	WP_PID	☐	WPPID	WPPID	CHAR	8	0	Process Identification
38	WP_ISTATUS	☐	WPISTATUS	WPISTATUS	INT1	3	0	Work process status
39	WP_STATUS	☐	WPSTATUS	WPSTATUS	CHAR	7	0	Work process status
40	WP_IWAIT	☐	WPIWAITING	WPIWAITING	INT1	3	0	Reason for wait
41	WP_WAITING	☐	WPWAITING	WPWAITING	CHAR	5	0	Why Work Process is Waiting
42	WP_SEM	☐	WPSEM	WPSEM	CHAR	2	0	Semaphore that the work process is waiting for
43	WP_IRESTRT	☐	WPIRESTART	WPIRESTART	INT1	3	0	Restart After Error
44	WP_RESTART	☐	WPRESTART	WPRESTART	CHAR	4	0	Restart work process after dump?
45	WP_DUMPS	☐	WPDUMPS	WPDUMPS	CHAR	2	0	Number of Dumps of the Work Process
46	WP_CPU	☐	WPCPU	WPCPU	CHAR	8	0	CPU
47	WP_ELTIME	☐	WPELZEIT	WPELZEIT	CHAR	6	0	Previous Runtime of Request (elapsed)
48	WP_MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
49	WP_BNAME	☐	WPBNAME	UBNAME	CHAR	12	0	User Currently Served
50	WP_REPORT	☐	WPREPORT	WPREPORT	CHAR	40	0	Report now running
51	WP_IACTION	☐	WPIACTION	INT1	INT1	3	0	Current activity of the work process
52	WP_ACTION	☐	WPACTION	WPACTION	CHAR	25	0	Current Activity of the Work Process
53	WP_TABLE	☐	WPTABLE	CHAR30	CHAR	30	0	DB table last accessed by the work process
54	WP_SERVER	☐	MSNAME	MSNAME	CHAR	20	0	Server Name
55	WP_WAITINF	☐	WPWAITINF	WPWAITINF	CHAR	40	0	Additional information about the reason for waiting
56	WP_WAITTIM	☐	WPWAITTIME	UDTIME	CHAR	8	0	Time when waiting started
57	WP_SEMSTAT	☐	WPITYPE	WPITYPE	INT1	3	0	Internal work process type
58	WP_INDEX	☐	WPINDEX	WPINDEX	INT4	10	0	Work Process Number
59	STUFE	☐	INT4	INT4	INT4	10	0	Natural number

History

Last changed by/on	SAP	20140117
SAP Release Created in	730