SAP ABAP Table SWLT_S_AGGREGATED_COMMONPART (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_COMMONPART	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_NAME	☐	SWLT_D_INCLUDE_NAME	PROGRAMM	CHAR	40	0	Include Name	*
2	INCLUDE_LINE	☐	SWLT_D_INCLUDE_LINE		INT4	10	0	Include Line
3	STAT_FINDINGS_NUM	☐	SWLT_D_STAT_FINDINGS_NUM		INT4	10	0	Number of Static Checks Findings
4	.INCLUDE	☐				0	0	SWLT_S_SQLM_PART
5	SQLM_TOTAL_TIME	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
6	SQLM_EXECUTIONS_NUM	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
7	SQLM_AVERAGE_TIME	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
8	SQLM_MIN_TIME	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
9	SQLM_MAX_TIME	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
10	SQLM_TIME_DEVIATION	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
11	SQLM_DB_COUNT	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
12	SQLM_DB_COUNT_AVERAGE	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
13	SQLM_DB_COUNT_MIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
14	SQLM_DB_COUNT_MAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
15	SQLM_DB_COUNT_DEVIATION	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
16	SQLM_ROOT_ID	☐	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
17	SQLM_ROOT_TYPE	☐	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
18	SQLM_STMTKIND	☐	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
19	SQLM_STMTKIND_DESCR	☐	SQLMSTMTKIND_TXT	TEXT30	CHAR	30	0	SQL Monitor: SQL Operation
20	SQLM_ROOT_TYPE_DESCR	☐	SQLMROOTTYPE_TXT	TEXT30	CHAR	30	0	SQL Monitor: Request Type
21	SQLM_INTERNAL_SESSIONS	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
22	SQLM_EXC_INT_SESSIONS_QUOT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
23	SQLM_FRAGMENT	☐	SQLMFRAGMENT		CHAR	255	0	SQL Monitor: Source Code Fragment
24	SQLM_OUTDATED	☐	SQLMOUTDATED		CHAR	1	0	SQL Monitor: Outdated
25	SQLM_OUTDATED_ICON	☐	SQLMOUTDATED_TXT		CHAR	60	0	SQL Monitor: Statement or Program Changed
26	DATA_SOURCE	☐	SWLT_D_DATA_SOURCE		STRG	0	0	Data source
27	TABLE_NAMES	☐	SWLT_D_RTM_TABLE_NAMES		STRG	0	0	Table Names
28	SCOV_EXECUTIONS	☐	SWLT_D_PBLOCK_EXECUTIONS	CVO_DEC20	DEC	20	0	Number of Processing Block Executions
29	PROCNAME_SHORT	☐	SQLMPROCNAME		CHAR	93	0	SQL Monitor: Processing Block Name
30	.INCLUDE	☐				0	0	SWLT_S_MD_TABLE_INFO
31	MD_TABLE_CLASS	☐	SWLT_D_MD_TABLE_CLASS	TABCLASS	CHAR	8	0	Class of Table
32	MD_SIZE_CATEGORY	☐	SWLT_D_MD_SIZE_CATEGORY	TABKAT	CHAR	2	0	Table Size Category
33	MD_IS_BUFFERED	☐	SWLT_D_MD_IS_BUFFERED	BUFALLOW	CHAR	1	0	Is Table Buffered
34	MD_BUFFERING_KIND	☐	SWLT_D_MD_BUFFERING_KIND	SWLT_BUFFERING_KIND	CHAR	1	0	Kind of Table Buffering
35	MD_ROW_OR_COL_STORE	☐	SWLT_D_MD_STORE_TYPE	DDROWORCOLST	CHAR	1	0	Store Type of Table (Row or Column)
36	MD_COLUMN_NUM	☐	SWLT_D_MD_COLUMN_NUM		INT4	10	0	Number of Columns
37	MD_KEY_COLUMN_NUM	☐	SWLT_D_MD_KEY_COL_NUM		INT4	10	0	Number of Key Columns
38	MD_BUFFERING_KIND_DESCR	☐	SWLT_D_MD_BUFFERING_KIND_DESCR		STRG	0	0	Table Buffering Type
39	MD_ROW_OR_COL_STORE_DESCR	☐	SWLT_D_MD_STORE_TYPE_DESCR		STRG	0	0	Table Store Type (Row or Column)
40	MD_TABLE_CLASS_DESCR	☐	SWLT_D_MD_TABLE_CLASS_DESCR		STRG	0	0	Table Class
41	MD_WIDTH_IN_BYTES	☐	SWLT_D_MD_WIDTH_IN_BYTES		INT4	10	0	Table Width in Bytes
42	PACKAGE_NAME	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package	*

History

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