SAP ABAP Table SQLM_STR_DISPLAY_RECORD_COL (Output structure for SQLM plus colour field)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO-RTA (Application Component) Runtime Analysis
     ⤷ SQLM_UI (Package) SQL Monitor UI

Basic Data

Table Category	INTTAB	Structure
Structure	SQLM_STR_DISPLAY_RECORD_COL	Table Relationship Diagram
Short Description	Output structure for SQLM plus colour field

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	Ausgabestruktur für SQLM Daten
2	.INCLUDE	☐				0	0	Time interval: Data from ... to
3	DATEFROM	☐	SQLMTSDATEFROM		DATS	8	0	SQL-Monitor: Measurement Period / Date From
4	TIMEFROM	☐	SQLMTSTIMEFROM		TIMS	6	0	SQL-Monitor: Include Time Interval / Time From
5	DATETO	☐	SQLMTSDATETO		DATS	8	0	SQL-Monitor: Measurement Period / Date To
6	TIMETO	☐	SQLMTSTIMETO		TIMS	6	0	SQL-Monitor: Include Time Interval / Time To
7	.INCLUDE	☐				0	0	SQL Monitor: Data Record
8	.INCLUDE	☐				0	0	SQL-Monitor: Time Slice Data
9	UNIXTIMEFROM	☐			INT4	10	0
10	UNIXTIMETO	☐			INT4	10	0
11	.INCLUDE	☐				0	0	SQL Monitor: Data Record
12	.INCLUDE	☐				0	0	SQL Monitor: Key (Source)
13	PROGNAME	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
14	PROGKIND	☐	SQLMPROGKIND	SQLMPROGKIND	CHAR	1	0	SQL Monitor: Program Kind
15	PROCTYPE	☐	SQLMPROCTYPE		CHAR	4	0	SQL Monitor: Processing Block Type
16	PROCNAME	☐	SQLMPROCNAME		CHAR	93	0	SQL Monitor: Processing Block Name
17	PROCLINE	☐	SQLMPROCLINE		INT4	10	0	SQL Monitor: Line Number in Processing Block
18	HASHCODE	☐	SQLMHASHCODE	SQLMCRC64	RAW	8	0	SQL Monitor: Source Hash Code
19	.INCLUDE	☐				0	0	SQL Monitor: Subkey
20	RUNLEVEL	☐	SQLMRUNLEVEL	SQLMRUNLEVEL	CHAR	1	0	SQL Monitor: Run Mode
21	ROOTTYPE	☐	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
22	ROOTNAME	☐	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
23	STMTKIND	☐	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
24	TABLENAMES	☐	SQLMTABLENAMES		CHAR	160	0	SQL Monitor: Table Names
25	.INCLUDE	☐				0	0	SQL Monitor: Source Info
26	INCLUDE	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
27	LINE	☐	INT4	INT4	INT4	10	0	Natural number
28	FRAGMENT	☐	SQLMFRAGMENT		CHAR	255	0	SQL Monitor: Source Code Fragment
29	PGMID	☐	PGMID	PGMID	CHAR	4	0	Program ID in Requests and Tasks
30	OBJECT	☐	TROBJTYPE	OBJECT	CHAR	4	0	Object Type
31	OBJ_NAME	☐	SOBJ_NAME	SOBJ_NAME	CHAR	40	0	Object Name in Object Directory
32	DEVCLASS	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package	*
33	PROGDATE	☐	SQLMPROGDATE		DATS	8	0	SQL Monitor: Program Date
34	PROGTIME	☐	SQLMPROGTIME		TIMS	6	0	SQL Monitor: Program Time
35	OUTDATED	☐	SQLMOUTDATED		CHAR	1	0	SQL Monitor: Outdated
36	.INCLUDE	☐				0	0	SQL Monitor: Payload
37	XCNT	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
38	.INCLUDE	☐				0	0	SQL Monitor: Rollarea
39	RCNT	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
40	XCNTRCNT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
41	.INCLUDE	☐				0	0	SQL Monitor: Runtime
42	RTMIN	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
43	RTMAX	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
44	RTCNT	☐	SQLMRUNTIMECNT		INT4	10	0	SQL Monitor: Count
45	RTSUM	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
46	RTSQS	☐	SQLMRUNTIMESQS	SQLMDECIMAL6	DEC	31	6	SQL Monitor: Runtime Sum of Squares
47	RTAVG	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
48	RTDEV	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
49	.INCLUDE	☐				0	0	SQL Monitor: DB Count
50	DBMIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
51	DBMAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
52	DBCNT	☐	SQLMDBCOUNTCNT		INT4	10	0	SQL Monitor: DB Count Count
53	DBSUM	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
54	DBSQS	☐	SQLMDBCOUNTSQS	SQLMINTEGER	DEC	31	0	SQL Monitor: DB Count Sum of Squares
55	DBAVG	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
56	DBDEV	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
57	.INCLUDE	☐				0	0	SQL Monitor: Request Payload
58	WPTIMESUM	☐	SQLMREQWPTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Total Time in Workprocesses [ms]
59	DBTIMESUM	☐	SQLMREQDBTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Total Database Execution Time [ms]
60	ROLLAREACNT	☐	SQLMREQROLLAREACNT		INT4	10	0	SQL Monitor: Number of Internal Sessions
61	STMTKIND_TXT	☐	SQLMSTMTKIND_TXT	TEXT30	CHAR	30	0	SQL Monitor: SQL Operation
62	RUNLEVEL_TXT	☐	SQLMRUNLEVEL_TXT	TEXT30	CHAR	30	0	SQL Monitor: Run Mode
63	ROOTTYPE_TXT	☐	SQLMROOTTYPE_TXT	TEXT30	CHAR	30	0	SQL Monitor: Request Type
64	CNT_ROOTS	☐	SQLMROOTCNT		INT4	10	0	SQL Monitor: Records for Source Position
65	CNT_SOURCE_POSITIONS	☐	SQLMSOURCECNT		INT4	10	0	SQL Monitor: Records for Request
66	RTMCNT	☐	SQLMRTMCNT		INT4	10	0	SQL Monitor: RTM Count
67	OUTDATED_ICON	☐	SQLMOUTDATED_TXT		CHAR	60	0	SQL Monitor: Statement or Program Changed
68	PERCENT_DB_WP	☐	SQLM_D_PERCENT_DB_WP		DEC	5	2	SQLM: Ratio of DB time by work process time in Percent
69	PERCENT_RTSUM	☐	SQLM_D_PERCENT_RTSUM		DEC	5	2	Contribution to the total DB time of the selected request
70	PERCENT_XCNT	☐	SQLM_D_PERCENT_XCNT		DEC	5	2	Contribution of the num. of executions of the selected req.
71	PERCENT_DBSUM	☐	SQLM_D_PERCENT_DBSUM		DEC	5	2	% of Processed Records of Selected Request
72	PROCNAME_SHORT	☐	SQLMPROCNAME		CHAR	93	0	SQL Monitor: Processing Block Name
73	SCOL	☐	LVC_T_SCOL		TTYP	0	0

History

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