SAP ABAP Table ADASYSMO (SYSDBA.SYSMONITOR and Selection From SYSDBA.SYSPARSEID)

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	ADASYSMO	Table Relationship Diagram
Short Description	SYSDBA.SYSMONITOR and Selection From SYSDBA.SYSPARSEID

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	SYSK	☐	ADA_SYSK	CHAR16	CHAR	16	0	SAP DB: Syskey
2	LINKAGE	☐	ADA_LINK	CHAR2	CHAR	2	0	SAP DB: Linkage
3	PARSEID	☐	ADA_PAID	CHAR24	CHAR	24	0	SAP DB: Parse ID
4	ROWS_READ	☐	ADA_READ	DEC20	DEC	20	0	SAP DB: Counter for rows read
5	ROWS_QUAL	☐	ADA_QUAL	DEC20	DEC	20	0	SAP DB: Counter for qualified rows
6	VIRTUAL_R	☐	ADA_VRDS	DEC20	DEC	20	0	SAP DB: Counter for virtual reads
7	SUBREQS	☐	ADA_REQS	DEC20	DEC	20	0	SAP DB: Counter for subrequests
8	STRATEGY	☐	ADA_STRA	CHAR40	CHAR	40	0	SAP DB: Strategy of SQL optimizer
9	RUNTIME	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
10	VWAITS	☐	ADA_VWAI	DEC20	DEC	20	0	SAP DB: Counter for SQL waits
11	VSUSPENDS	☐	ADA_VSUS	DEC20	DEC	20	0	SAP DB: Counter for task suspensions
12	PHYS_IO	☐	ADA_PHIO	DEC20	DEC	20	0	SAP DB: Counter for physical I/O access
13	R_FETCHED	☐	ADA_RFET	DEC20	DEC	20	0	SAP DB: Counter for "gotten" rows
14	F_CALLS	☐	ADA_FCAL	DEC20	DEC	20	0	SAP DB: Number of get calls
15	ROOT1	☐	ADA_ROOT	INT4	INT4	10	0	SAP DB: Root of a DB index
16	ROOT2	☐	ADA_ROOT	INT4	INT4	10	0	SAP DB: Root of a DB index
17	ROOT3	☐	ADA_ROOT	INT4	INT4	10	0	SAP DB: Root of a DB index
18	ROOT4	☐	ADA_ROOT	INT4	INT4	10	0	SAP DB: Root of a DB index
19	ROOT5	☐	ADA_ROOT	INT4	INT4	10	0	SAP DB: Root of a DB index
20	ROOT6	☐	ADA_ROOT	INT4	INT4	10	0	SAP DB: Root of a DB index
21	RES_COPIED	☐	ADA_RESC	CHAR3	CHAR	3	0	SAP DB: Indicator whether result should be phys. built
22	A_DATE	☐	SDBA_DATE	DATS	DATS	8	0	Date stamp
23	A_TIME	☐	SDBA_TIME	SYTIME	TIMS	6	0	Time (24 hour clock) for DBA action to run
24	TABNAME	☐	ADATABNAME	CHAR30	CHAR	30	0	SDB Table Name
25	S_SQLSTMNT	☐	ADA_SSTMT	CHAR80	CHAR	80	0	SAP DB: Start of SQL command
26	SELTIVITY	☐	ADA_SELTY	DEC3_2	DEC	5	2	SAP DB: Ratio of qualified to read rows
27	VR_PERLINE	☐	ADA_VRPL	DEC20_2	DEC	20	2	SAP DB: Number of page accesses per row
28	OPERATION	☐	ADA_OP	CHAR10	CHAR	10	0	SAP DB: SQL operation
29	JOB	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
30	LINE	☐	ABP_CONT		INT4	10	0	Offset of a Processing Control Block
31	OWNER	☐	SADAOWN	CHAR32	CHAR	32	0	SAP DB: Database table owner
32	TOTAL_IO	☐	ADA_VALUE	DEC20	DEC	20	0	SYSDBA.MONITOR.VALUE
33	JOB_LONG	☐	CHAR120	CHAR120	CHAR	120	0	char120

History

Last changed by/on	SAP	20130604
SAP Release Created in