SAP ABAP Table SYB_VIEW_PROCESS_DTL (SYB: View data structure for process details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_VIEW_PROCESS_DTL	Table Relationship Diagram
Short Description	SYB: View data structure for process details

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	PROCESS	☐	SYBMON_PROCESS		STRU	0	0
2	APPLICATION	☐			STRG	0	0
3	BATCHID	☐			INT4	10	0
4	CONTEXTID	☐			INT4	10	0
5	LINENUMBER	☐			INT4	10	0
6	SPID_STATUS	☐			STRG	0	0
7	BLOCKINGSPID	☐			INT4	10	0
8	BLOCKINGXLOID	☐			INT4	10	0
9	COMMAND	☐			STRG	0	0
10	ENGINEGROUPNAME	☐			CHAR	30	0
11	ENGINENUMBER	☐			INT2	5	0
12	EXECUTIONCLASS	☐			CHAR	30	0
13	FAMILYID	☐			INT4	10	0
14	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
15	KPID	☐			INT4	10	0
16	LOGIN	☐			CHAR	30	0
17	MASTERTRANSACTIONID	☐			STRG	0	0
18	NUMCHILDREN	☐			INT4	10	0
19	PRIORITY	☐			INT4	10	0
20	SPID	☐			INT4	10	0
21	SECONDSCONNECTED	☐			INT4	10	0
22	SECONDSWAITING	☐			INT4	10	0
23	SERVERUSERID	☐			STRG	0	0
24	WAITEVENTID	☐			INT2	5	0
25	TXN_RUNTIME	☐			INT4	10	0
26	TXN_STARTTIME	☐			STRG	0	0
27	TXN_STATE	☐			STRG	0	0
28	TXN_FAILOVER	☐			STRG	0	0
29	TXN_TYPE	☐			STRG	0	0
30	WAITEVENTDESCR	☐			STRG	0	0
31	CLIENTIP	☐			STRG	0	0
32	CLIENTOSPID	☐			STRG	0	0
33	DBID	☐			INT4	10	0
34	DBNAME	☐			CHAR	30	0
35	LOCKS_HELD	☐			INT4	10	0
36	PLANID	☐			INT4	10	0
37	PROCEDUREID	☐			INT4	10	0
38	CPUTIME	☐			INT4	10	0
39	WAITTIME	☐			INT4	10	0
40	MEMUSAGEKB	☐			INT4	10	0
41	LOGICALREADS	☐			INT4	10	0
42	PHYSICALREADS	☐			INT4	10	0
43	PAGESMODIFIED	☐			INT4	10	0
44	PACKETSRECEIVED	☐			INT4	10	0
45	PACKETSSENT	☐			INT4	10	0
46	NETWORKPACKETSIZE	☐			INT4	10	0
47	PLANSALTERED	☐			INT4	10	0
48	ROWSAFFECTED	☐			INT4	10	0
49	STMT_STARTTIME	☐			STRG	0	0
50	STMT_RUNTIME	☐			INT4	10	0
51	STMT_TEXT	☐			STRG	0	0
52	IN_UOW	☐			CHAR	1	0
53	CPU_SAMPLE	☐			DEC	10	2
54	CLIENTNAME	☐			CHAR	30	0
55	CLIENTHOSTNAME	☐			CHAR	30	0
56	CLIENTAPPLNAME	☐			CHAR	30	0
57	HOSTNAME	☐			CHAR	30	0
58	BGCOLOR	☐	LVC_CIFNM	CHAR30	CHAR	30	0	ALV control: Field name with simple row color coding
59	SNAPSHOT_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
60	HAS_STMT	☐			CHAR	1	0
61	SHOW_NO_STMT_TEXT	☐			CHAR	1	0
62	NO_STMT_TEXT	☐			STRG	0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	703