SAP ABAP View SQLMVDITM (SQL Monitor: View on Data Records With Info, Table Names)
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
View Type | D | Database View |
Database View | SQLMVDITM | |
Short Description | SQL Monitor: View on Data Records With Info, Table Names | |
Root table | SQLMD | SQL Monitor: Data |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | SQLMD | SQLMD | ||
2 | SQLMI | |||
3 | SQLMT | |||
4 | SQLMM |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | SQLMD | PROGNAME | JL | EQ | 0 | 0 | ||||
2 | SQLMI | PROGNAME | JR | EQ | AND | 0 | 0 | |||
3 | SQLMD | PROGKIND | JL | EQ | 0 | 0 | ||||
4 | SQLMI | PROGKIND | JR | EQ | AND | 0 | 0 | |||
5 | SQLMD | PROCTYPE | JL | EQ | 0 | 0 | ||||
6 | SQLMI | PROCTYPE | JR | EQ | AND | 0 | 0 | |||
7 | SQLMD | PROCNAME | JL | EQ | 0 | 0 | ||||
8 | SQLMI | PROCNAME | JR | EQ | AND | 0 | 0 | |||
9 | SQLMD | PROCLINE | JL | EQ | 0 | 0 | ||||
10 | SQLMI | PROCLINE | JR | EQ | AND | 0 | 0 | |||
11 | SQLMD | TABLENAME | JL | EQ | 0 | 0 | ||||
12 | SQLMT | TABLENAME | JR | EQ | AND | 0 | 0 | |||
13 | SQLMD | TABLENAME | JL | EQ | 0 | 0 | ||||
14 | SQLMM | TABLENAME | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | PROGNAME | SQLMD | PROGNAME | PROGNAME | ABAP Program Name | |||
2 | PROGKIND | SQLMD | PROGKIND | SQLMPROGKIND | SQL Monitor: Program Kind | |||
3 | PROCTYPE | SQLMD | PROCTYPE | SQLMPROCTYPE | SQL Monitor: Processing Block Type | |||
4 | PROCNAME | SQLMD | PROCNAME | SQLMPROCNAME | SQL Monitor: Processing Block Name | |||
5 | PROCLINE | SQLMD | PROCLINE | SQLMPROCLINE | SQL Monitor: Line Number in Processing Block | |||
6 | RUNLEVEL | SQLMD | RUNLEVEL | SQLMRUNLEVEL | SQL Monitor: Run Mode | |||
7 | ROOTTYPE | SQLMD | ROOTTYPE | SQLMROOTTYPE | SQL Monitor: Request Type | |||
8 | ROOTNAME | SQLMD | ROOTNAME | SQLMROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | |||
9 | STMTKIND | SQLMD | STMTKIND | SQLMSTMTKIND | SQL Monitor: SQL Operation | |||
10 | TABLENAMES | SQLMT | TABLENAMES | SQLMTABLENAMES | SQL Monitor: Table Names | |||
11 | TABLENAME | SQLMD | TABLENAME | SQLMTABLENAME | SQL Monitor: Table Name | |||
12 | TABLENAME0 | SQLMM | TABLENAME0 | SQLMTABLENAME | SQL Monitor: Table Name | |||
13 | INCLUDE | SQLMI | INCLUDE | PROGNAME | ABAP Program Name | |||
14 | LINE | SQLMI | LINE | INT4 | Natural number | |||
15 | PGMID | SQLMI | PGMID | PGMID | Program ID in Requests and Tasks | |||
16 | OBJECT | SQLMI | OBJECT | TROBJTYPE | Object Type | |||
17 | OBJ_NAME | SQLMI | OBJ_NAME | SOBJ_NAME | Object Name in Object Directory | |||
18 | DEVCLASS | SQLMI | DEVCLASS | DEVCLASS | Package | |||
19 | XCNT | SQLMD | XCNT | SQLMEXECNT | SQL Monitor: Total Number of Executions | |||
20 | RCNT | SQLMD | RCNT | SQLMROLLAREACNT | SQL Monitor: Internal Sessions Affected | |||
21 | XCNTRCNT | SQLMD | XCNTRCNT | SQLMEXECNTROLLAREACNT | SQL Monitor: Executions per Internal Sessions | |||
22 | RTMIN | SQLMD | RTMIN | SQLMRUNTIMEMIN | SQL Monitor: Minimum Value of SQL Execution Time | |||
23 | RTMAX | SQLMD | RTMAX | SQLMRUNTIMEMAX | SQL Monitor: Maximum Value of Database Execution Time | |||
24 | RTCNT | SQLMD | RTCNT | SQLMRUNTIMECNT | SQL Monitor: Count | |||
25 | RTSUM | SQLMD | RTSUM | SQLMRUNTIMESUM | SQL Monitor: Summarized Database Execution Time [ms] | |||
26 | RTSQS | SQLMD | RTSQS | SQLMRUNTIMESQS | SQL Monitor: Runtime Sum of Squares | |||
27 | RTAVG | SQLMD | RTAVG | SQLMRUNTIMEAVG | SQL Monitor: Mean Value of DB Execution Time | |||
28 | RTDEV | SQLMD | RTDEV | SQLMRUNTIMEDEV | SQL Monitor: Standard Deviation of Database Execution Time | |||
29 | DBMIN | SQLMD | DBMIN | SQLMDBCOUNTMIN | SQL Monitor: Minimum Value of Processed Records | |||
30 | DBMAX | SQLMD | DBMAX | SQLMDBCOUNTMAX | SQL Monitor: Maximum Value of Processed Records | |||
31 | DBCNT | SQLMD | DBCNT | SQLMDBCOUNTCNT | SQL Monitor: DB Count Count | |||
32 | DBSUM | SQLMD | DBSUM | SQLMDBCOUNTSUM | SQL Monitor: Total Processed Records | |||
33 | DBSQS | SQLMD | DBSQS | SQLMDBCOUNTSQS | SQL Monitor: DB Count Sum of Squares | |||
34 | DBAVG | SQLMD | DBAVG | SQLMDBCOUNTAVG | SQL Monitor: Mean Value of Processed Records | |||
35 | DBDEV | SQLMD | DBDEV | SQLMDBCOUNTDEV | SQL Monitor: Standard Deviation of Processed Records | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 740 |