SAP ABAP Table SWLT_S_SQLM_PART (SWLT_S_SQLM_PART)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO (Application Component) Workbench Tools: Editors, Painters, Modelers
     ⤷ SWLT (Package) SQL Performance Tuning Worklist

Basic Data

Table Category	INTTAB	Structure
Structure	SWLT_S_SQLM_PART	Table Relationship Diagram
Short Description	SWLT_S_SQLM_PART

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	SQLM_TOTAL_TIME	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
2	SQLM_EXECUTIONS_NUM	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
3	SQLM_AVERAGE_TIME	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
4	SQLM_MIN_TIME	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
5	SQLM_MAX_TIME	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
6	SQLM_TIME_DEVIATION	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
7	SQLM_DB_COUNT	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
8	SQLM_DB_COUNT_AVERAGE	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
9	SQLM_DB_COUNT_MIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
10	SQLM_DB_COUNT_MAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
11	SQLM_DB_COUNT_DEVIATION	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
12	SQLM_ROOT_ID	☐	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
13	SQLM_ROOT_TYPE	☐	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
14	SQLM_STMTKIND	☐	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
15	SQLM_STMTKIND_DESCR	☐	SQLMSTMTKIND_TXT	TEXT30	CHAR	30	0	SQL Monitor: SQL Operation
16	SQLM_ROOT_TYPE_DESCR	☐	SQLMROOTTYPE_TXT	TEXT30	CHAR	30	0	SQL Monitor: Request Type
17	SQLM_INTERNAL_SESSIONS	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
18	SQLM_EXC_INT_SESSIONS_QUOT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
19	SQLM_FRAGMENT	☐	SQLMFRAGMENT		CHAR	255	0	SQL Monitor: Source Code Fragment
20	SQLM_OUTDATED	☐	SQLMOUTDATED		CHAR	1	0	SQL Monitor: Outdated
21	SQLM_OUTDATED_ICON	☐	SQLMOUTDATED_TXT		CHAR	60	0	SQL Monitor: Statement or Program Changed

History

Last changed by/on	SAP	20141013
SAP Release Created in	740