SAP ABAP Table STUISESSCH (Database Sessions and R/3 User and Report Names)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-INF (Application Component) Informix
     ⤷ STUI (Package) Informix Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	STUISESSCH	Table Relationship Diagram
Short Description	Database Sessions and R/3 User and Report Names

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	DBSID	☐	SESSIONID	SESSIONID	INT4	10	0	SID of a DB session
2	TID	☐	STUITID	INT4	INT4	10	0	Thread ID (Informix monitor)
3	VPID	☐	STUIVPID	INT4	INT4	10	0	Informix monitor: Vp ID
4	VP_CLASS	☐	STUIVPCLAS	CHAR3	CHAR	3	0	Informix monitor: Vp class
5	CLHOSTNAME	☐	STUIHOST	CHAR16	CHAR	16	0	Informix client host name
6	DBUSERNAME	☐	WPBNAME	UBNAME	CHAR	12	0	User Currently Served
7	CL_PID	☐	PROCESSID	PROCESSID	INT4	10	0	PID of an ABAP WP (DB Session)
8	CL_TTY	☐	STUITTY	CHAR16	CHAR	16	0	Informix client tty
9	CL_CONNECT	☐	STUICONNEC	INT4	INT4	10	0	Informix client connected
10	THREADSTAT	☐	STUITHSTAT	CHAR23	CHAR	23	0	Informix monitor: Thread status
11	THREADNAME	☐	STUITHNAME	CHAR16	CHAR	16	0	Informix monitor: Thread name
12	PRIORITY	☐	STUIPRIORI	INT4	INT4	10	0	Thread priority
13	LOCK_WAIT	☐	STUILKWAIT	INT4	INT4	10	0	db lock waiting for (Informix monitor)
14	WAITSSINCE	☐	DBLOCKWAIT	DBLOCKWAIT	INT4	10	0	Number of seconds waiting for a DB lock
15	CUMRUNTIME	☐	STUIRUNTCH	CHAR13	CHAR	13	0	Session run time (Informix monitor)
16	CUMWAITTIM	☐	STUIWAITCH	CHAR13	CHAR	13	0	Session wait time (Informix monitor)
17	WP_REPORT	☐	WPREPORT	WPREPORT	CHAR	40	0	Report now running
18	WP_BNAME	☐	WPBNAME	UBNAME	CHAR	12	0	User Currently Served
19	WP_NO	☐	WPNO	WPNO	CHAR	2	0	(Deprecated) Use WP_UNDEX
20	WP_TYP	☐	WPTYP	WPTYP	CHAR	3	0	Type
21	WP_STATUS	☐	WPSTATUS	WPSTATUS	CHAR	7	0	Work process status
22	WP_WAITING	☐	WPWAITING	WPWAITING	CHAR	5	0	Why Work Process is Waiting
23	WP_SEM	☐	WPSEM	WPSEM	CHAR	2	0	Semaphore that the work process is waiting for
24	WP_ELTIME	☐	WPELZEIT	WPELZEIT	CHAR	6	0	Previous Runtime of Request (elapsed)
25	WP_CPU	☐	WPCPU	WPCPU	CHAR	8	0	CPU
26	WP_MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
27	WP_TABLE	☐	WPTABLE	CHAR30	CHAR	30	0	DB table last accessed by the work process
28	WP_WAITINF	☐	WPWAITINF	WPWAITINF	CHAR	40	0	Additional information about the reason for waiting
29	WP_WAITTIM	☐	WPWAITTIME	UDTIME	CHAR	8	0	Time when waiting started
30	WP_ACTION	☐	WPACTION	WPACTION	CHAR	25	0	Current Activity of the Work Process

History

Last changed by/on	SAP	20140117
SAP Release Created in