SAP ABAP Table SWLT_S_AGGREGATED_LINE (Aggregated Line for Worklist Tool)

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_AGGREGATED_LINE	Table Relationship Diagram
Short Description	Aggregated Line for Worklist Tool

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	.INCLUDE	☐				0	0	Identifier / Key for Code Line & Check 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	CHECK	☐	SWLT_D_STATIC_CHECK		CHAR	30	0	Check ID
9	CHECK_MESSAGE_ID	☐	SWLT_D_STATIC_MESSAGE_ID		CHAR	10	0	Check Message ID
10	.INCLUDE	☐				0	0	Aggregated Line for Worklist Tool
11	INCLUDE_NAME	☐	SWLT_D_INCLUDE_NAME	PROGRAMM	CHAR	40	0	Include Name	*
12	INCLUDE_LINE	☐	SWLT_D_INCLUDE_LINE		INT4	10	0	Include Line
13	STAT_FINDINGS_NUM	☐	SWLT_D_STAT_FINDINGS_NUM		INT4	10	0	Number of Static Checks Findings
14	.INCLUDE	☐				0	0	SWLT_S_SQLM_PART
15	SQLM_TOTAL_TIME	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
16	SQLM_EXECUTIONS_NUM	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
17	SQLM_AVERAGE_TIME	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
18	SQLM_MIN_TIME	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
19	SQLM_MAX_TIME	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
20	SQLM_TIME_DEVIATION	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
21	SQLM_DB_COUNT	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
22	SQLM_DB_COUNT_AVERAGE	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
23	SQLM_DB_COUNT_MIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
24	SQLM_DB_COUNT_MAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
25	SQLM_DB_COUNT_DEVIATION	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
26	SQLM_ROOT_ID	☐	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
27	SQLM_ROOT_TYPE	☐	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
28	SQLM_STMTKIND	☐	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
29	SQLM_STMTKIND_DESCR	☐	SQLMSTMTKIND_TXT	TEXT30	CHAR	30	0	SQL Monitor: SQL Operation
30	SQLM_ROOT_TYPE_DESCR	☐	SQLMROOTTYPE_TXT	TEXT30	CHAR	30	0	SQL Monitor: Request Type
31	SQLM_INTERNAL_SESSIONS	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
32	SQLM_EXC_INT_SESSIONS_QUOT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
33	SQLM_FRAGMENT	☐	SQLMFRAGMENT		CHAR	255	0	SQL Monitor: Source Code Fragment
34	SQLM_OUTDATED	☐	SQLMOUTDATED		CHAR	1	0	SQL Monitor: Outdated
35	SQLM_OUTDATED_ICON	☐	SQLMOUTDATED_TXT		CHAR	60	0	SQL Monitor: Statement or Program Changed
36	DATA_SOURCE	☐	SWLT_D_DATA_SOURCE		STRG	0	0	Data source
37	TABLE_NAMES	☐	SWLT_D_RTM_TABLE_NAMES		STRG	0	0	Table Names
38	SCOV_EXECUTIONS	☐	SWLT_D_PBLOCK_EXECUTIONS	CVO_DEC20	DEC	20	0	Number of Processing Block Executions
39	PROCNAME_SHORT	☐	SQLMPROCNAME		CHAR	93	0	SQL Monitor: Processing Block Name
40	.INCLUDE	☐				0	0	SWLT_S_MD_TABLE_INFO
41	MD_TABLE_CLASS	☐	SWLT_D_MD_TABLE_CLASS	TABCLASS	CHAR	8	0	Class of Table
42	MD_SIZE_CATEGORY	☐	SWLT_D_MD_SIZE_CATEGORY	TABKAT	CHAR	2	0	Table Size Category
43	MD_IS_BUFFERED	☐	SWLT_D_MD_IS_BUFFERED	BUFALLOW	CHAR	1	0	Is Table Buffered
44	MD_BUFFERING_KIND	☐	SWLT_D_MD_BUFFERING_KIND	SWLT_BUFFERING_KIND	CHAR	1	0	Kind of Table Buffering
45	MD_ROW_OR_COL_STORE	☐	SWLT_D_MD_STORE_TYPE	DDROWORCOLST	CHAR	1	0	Store Type of Table (Row or Column)
46	MD_COLUMN_NUM	☐	SWLT_D_MD_COLUMN_NUM		INT4	10	0	Number of Columns
47	MD_KEY_COLUMN_NUM	☐	SWLT_D_MD_KEY_COL_NUM		INT4	10	0	Number of Key Columns
48	MD_BUFFERING_KIND_DESCR	☐	SWLT_D_MD_BUFFERING_KIND_DESCR		STRG	0	0	Table Buffering Type
49	MD_ROW_OR_COL_STORE_DESCR	☐	SWLT_D_MD_STORE_TYPE_DESCR		STRG	0	0	Table Store Type (Row or Column)
50	MD_TABLE_CLASS_DESCR	☐	SWLT_D_MD_TABLE_CLASS_DESCR		STRG	0	0	Table Class
51	MD_WIDTH_IN_BYTES	☐	SWLT_D_MD_WIDTH_IN_BYTES		INT4	10	0	Table Width in Bytes
52	PACKAGE_NAME	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package	*
53	.INCLUDE	☐				0	0	Static Check Components for Check Aggregated Mode
54	STAT_CHECKS_NUM	☐	SWLT_D_STAT_CHECKS_NUM		INT4	10	0	Number of relevant checks
55	.INCLUDE	☐				0	0	Static Check Components for Unaggregated Mode
56	.INCLUDE	☐				0	0	Rating of a finding
57	SEVERITY	☐	SWLT_D_SEVERITY		INT4	10	0	Severity
58	EFFORT	☐	SWLT_D_EFFORT		INT4	10	0	Estimated Relative Fixing Effort
59	PRIORITY	☐	SWLT_D_PRIORITY		INT4	10	0	Priority
60	CHECK_TEXT	☐	SWLT_D_STATIC_CHECK_TEXT		STRG	0	0	Check Title
61	CHECK_MESSAGE_TEXT	☐	SWLT_D_STATIC_MESSAGE_TEXT		STRG	0	0	Check Message
62	.INCLUDE	☐				0	0	Key for Transport Objects with ID "R3TR"
63	OBJ_NAME	☐	SOBJ_NAME	SOBJ_NAME	CHAR	40	0	Object Name in Object Directory
64	OBJ_TYPE	☐	TROBJTYPE	OBJECT	CHAR	4	0	Object Type
65	.INCLUDE	☐				0	0	Components Reserved Exclusively for BAdI Post Processing
66	RANK	☐	SWLT_D_RANK		INT4	10	0	Rank of an SWLT record
67	METRIC	☐			FLTP	16	16

History

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