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
⤷ 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 |