SAP ABAP Table SQLMRECORDBYROOT (SQL Monitor: Data Record Aggregated By Root)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	SQLMRECORDBYROOT	Table Relationship Diagram
Short Description	SQL Monitor: Data Record Aggregated By Root

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	SQL Monitor: Data Record
2	.INCLUDE	☐				0	0	SQL Monitor: Key (Source)
3	PROGNAME	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
4	PROGKIND	☐	SQLMPROGKIND	SQLMPROGKIND	CHAR	1	0	SQL Monitor: 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	HASHCODE	☐	SQLMHASHCODE	SQLMCRC64	RAW	8	0	SQL Monitor: Source Hash Code
9	.INCLUDE	☐				0	0	SQL Monitor: Subkey
10	RUNLEVEL	☐	SQLMRUNLEVEL	SQLMRUNLEVEL	CHAR	1	0	SQL Monitor: Run Mode
11	ROOTTYPE	☐	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
12	ROOTNAME	☐	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
13	STMTKIND	☐	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
14	TABLENAMES	☐	SQLMTABLENAMES		CHAR	160	0	SQL Monitor: Table Names
15	.INCLUDE	☐				0	0	SQL Monitor: Source Info
16	INCLUDE	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
17	LINE	☐	INT4	INT4	INT4	10	0	Natural number
18	FRAGMENT	☐	SQLMFRAGMENT		CHAR	255	0	SQL Monitor: Source Code Fragment
19	PGMID	☐	PGMID	PGMID	CHAR	4	0	Program ID in Requests and Tasks
20	OBJECT	☐	TROBJTYPE	OBJECT	CHAR	4	0	Object Type
21	OBJ_NAME	☐	SOBJ_NAME	SOBJ_NAME	CHAR	40	0	Object Name in Object Directory
22	DEVCLASS	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package	*
23	PROGDATE	☐	SQLMPROGDATE		DATS	8	0	SQL Monitor: Program Date
24	PROGTIME	☐	SQLMPROGTIME		TIMS	6	0	SQL Monitor: Program Time
25	OUTDATED	☐	SQLMOUTDATED		CHAR	1	0	SQL Monitor: Outdated
26	.INCLUDE	☐				0	0	SQL Monitor: Payload
27	XCNT	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
28	.INCLUDE	☐				0	0	SQL Monitor: Rollarea
29	RCNT	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
30	XCNTRCNT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
31	.INCLUDE	☐				0	0	SQL Monitor: Runtime
32	RTMIN	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
33	RTMAX	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
34	RTCNT	☐	SQLMRUNTIMECNT		INT4	10	0	SQL Monitor: Count
35	RTSUM	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
36	RTSQS	☐	SQLMRUNTIMESQS	SQLMDECIMAL6	DEC	31	6	SQL Monitor: Runtime Sum of Squares
37	RTAVG	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
38	RTDEV	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
39	.INCLUDE	☐				0	0	SQL Monitor: DB Count
40	DBMIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
41	DBMAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
42	DBCNT	☐	SQLMDBCOUNTCNT		INT4	10	0	SQL Monitor: DB Count Count
43	DBSUM	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
44	DBSQS	☐	SQLMDBCOUNTSQS	SQLMINTEGER	DEC	31	0	SQL Monitor: DB Count Sum of Squares
45	DBAVG	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
46	DBDEV	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
47	.INCLUDE	☐				0	0	SQL Monitor: Request Payload
48	WPTIMESUM	☐	SQLMREQWPTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Total Time in Workprocesses [ms]
49	DBTIMESUM	☐	SQLMREQDBTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Total Database Execution Time [ms]
50	ROLLAREACNT	☐	SQLMREQROLLAREACNT		INT4	10	0	SQL Monitor: Number of Internal Sessions
51	CNT	☐	INT4	INT4	INT4	10	0	Natural number

History

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