SAP ABAP Table SWLT_SQLM_D (SWLT: Display data from SQL Monitor test)

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	TRANSP	Transparent table
Transparent table	SWLT_SQLM_D	Table Relationship Diagram
Short Description	SWLT: Display data from SQL Monitor test

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	SNAPSHOT_ID	☑	SWLT_D_RTM_SNAPSHOT_ID	SYSUUID	RAW	16	0	SWLT: snapshot id
2	.INCLUDE	☑				0	0	Identifier / Key for Code Line
3	PROGNAME	☑	REPID	PROGNAME	CHAR	40	0	ABAP Program Name
4	PROGKIND	☑	SWLT_D_PROGKIND		CHAR	1	0	Program kind
5	PROCTYPE	☑	SQLMPROCTYPE		CHAR	4	0	SQL Monitor: Processing Block Type
6	PROCNAME	☑	SQLMPROCNAME		CHAR	93	0	SQL Monitor: Processing Block Name
7	PROCLINE	☑	SQLMPROCLINE		INT4	10	0	SQL Monitor: Line Number in Processing Block
8	RUNLEVEL	☑	SQLMRUNLEVEL	SQLMRUNLEVEL	CHAR	1	0	SQL Monitor: Run Mode
9	ROOTTYPE	☑	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
10	ROOTNAME	☑	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
11	STMTKIND	☑	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
12	TABLE_GROUP_ID	☑	SWLT_D_ID	SYSUUID	RAW	16	0	SWLT ID
13	TABLE_NAMES	☐	SWLT_D_TABLE_NAMES		CHAR	171	0	Table names (comma separated)
14	INCLUDE	☐	SWLT_D_INCLUDE_NAME	PROGRAMM	CHAR	40	0	Include Name	*
15	LINE	☐	SWLT_D_INCLUDE_LINE		INT4	10	0	Include Line
16	OBJ_NAME	☐	SOBJ_NAME	SOBJ_NAME	CHAR	40	0	Object Name in Object Directory
17	OBJ_TYPE	☐	TROBJTYPE	OBJECT	CHAR	4	0	Object Type
18	PACKAGE_NAME	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package	*
19	RTMIN	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
20	RTMAX	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
21	RTCNT	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
22	RTSUM	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
23	RTSQS	☐	SQLMRUNTIMESQS	SQLMDECIMAL6	DEC	31	6	SQL Monitor: Runtime Sum of Squares
24	RTAVG	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
25	RTDEV	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
26	DBMIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
27	DBMAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
28	DBCNT	☐	SQLMDBCOUNTCNT		INT4	10	0	SQL Monitor: DB Count Count
29	DBSUM	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
30	DBSQS	☐	SQLMDBCOUNTSQS	SQLMINTEGER	DEC	31	0	SQL Monitor: DB Count Sum of Squares
31	DBAVG	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
32	DBDEV	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
33	RCNT	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
34	XCNTRCNT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
35	FRAGMENT	☐	SQLMFRAGMENT		CHAR	255	0	SQL Monitor: Source Code Fragment
36	OUTDATED	☐	SQLMOUTDATED		CHAR	1	0	SQL Monitor: Outdated

History

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