SAP ABAP Table ADASYSAN (SYSDBA.SYSDATA_ANALYZE and SYSDBA.SYSCMD_ANALYZE)

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	ADASYSAN	Table Relationship Diagram
Short Description	SYSDBA.SYSDATA_ANALYZE and SYSDBA.SYSCMD_ANALYZE

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	CMDID	☐	ADA_SYSK	CHAR16	CHAR	16	0	SAP DB: Syskey
2	CALL_COUNT	☐	ADA_CCNT	DEC20	DEC	20	0	SAP DB: Counter for command calls
3	ROWS_READ	☐	ADA_READ	DEC20	DEC	20	0	SAP DB: Counter for rows read
4	RQ_PEREXEC	☐	ADA_RQPE	DEC20	DEC	20	0	SAP DB: Qualified rows per execution
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	VR_PEREXEC	☐	ADA_VRPE	DEC20	DEC	20	0	SAP DB: Number of page accesses per execution
8	VR_PERLINE	☐	ADA_VRPL	DEC20_2	DEC	20	2	SAP DB: Number of page accesses per row
9	PHYS_IO	☐	ADA_PHIO	DEC20	DEC	20	0	SAP DB: Counter for physical I/O access
10	R_FETCHED	☐	ADA_RFET	DEC20	DEC	20	0	SAP DB: Counter for "gotten" rows
11	RUNTIME	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
12	AVG_RUNTIM	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
13	MIN_RUNTIM	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
14	MAX_RUNTIM	☐	ADA_RTIM	DEC20_3	DEC	20	3	SAP DB: SQL command runtime in seconds
15	VWAITS	☐	ADA_VWAI	DEC20	DEC	20	0	SAP DB: Counter for SQL waits
16	VSUSPENDS	☐	ADA_VSUS	DEC20	DEC	20	0	SAP DB: Counter for task suspensions
17	JOB	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program	*
18	LINE	☐	ABP_CONT		INT4	10	0	Offset of a Processing Control Block
19	S_SQLSTMNT	☐	ADA_SSTMT	CHAR80	CHAR	80	0	SAP DB: Start of SQL command
20	TABNAME	☐	ADATABNAME	CHAR30	CHAR	30	0	SDB Table Name
21	OPERATION	☐	ADA_OP	CHAR10	CHAR	10	0	SAP DB: SQL operation
22	TOTAL_IO	☐	ADA_VALUE	DEC20	DEC	20	0	SYSDBA.MONITOR.VALUE
23	JOB_LONG	☐	CHAR120	CHAR120	CHAR	120	0	char120

History

Last changed by/on	SAP	20130604
SAP Release Created in