SAP ABAP View /SDF/ZQLMVDIT (SQL Monitor: View on Data Records With Info and Table Names)
Hierarchy
☛
ST-PI (Software Component) SAP Solution Tools Plug-In
⤷
SV-SMG-DIA (Application Component) Solution Manager Diagnostics
⤷
/SDF/ZQLM (Package) Package for SQL Monitor
ST-PI (Software Component) SAP Solution Tools Plug-In⤷
SV-SMG-DIA (Application Component) Solution Manager Diagnostics⤷
/SDF/ZQLM (Package) Package for SQL Monitor
Basic Data
| View Type | D | Database View |
| Database View | /SDF/ZQLMVDIT | |
| Short Description | SQL Monitor: View on Data Records With Info and Table Names | |
| Root table | /SDF/ZQLMD | SQL Monitor: Data |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /SDF/ZQLMD |
/SDF/ZQLMD | ||
| 2 | /SDF/ZQLMI |
|||
| 3 | /SDF/ZQLMT |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /SDF/ZQLMD |
PROGNAME | JL | EQ | 0 | 0 | ||||
| 2 | /SDF/ZQLMI |
PROGNAME | JR | EQ | AND | 0 | 0 | |||
| 3 | /SDF/ZQLMD |
PROGKIND | JL | EQ | 0 | 0 | ||||
| 4 | /SDF/ZQLMI |
PROGKIND | JR | EQ | AND | 0 | 0 | |||
| 5 | /SDF/ZQLMD |
PROCTYPE | JL | EQ | 0 | 0 | ||||
| 6 | /SDF/ZQLMI |
PROCTYPE | JR | EQ | AND | 0 | 0 | |||
| 7 | /SDF/ZQLMD |
PROCNAME | JL | EQ | 0 | 0 | ||||
| 8 | /SDF/ZQLMI |
PROCNAME | JR | EQ | AND | 0 | 0 | |||
| 9 | /SDF/ZQLMD |
PROCLINE | JL | EQ | 0 | 0 | ||||
| 10 | /SDF/ZQLMI |
PROCLINE | JR | EQ | AND | 0 | 0 | |||
| 11 | /SDF/ZQLMT |
TABLENAME | JL | EQ | 0 | 0 | ||||
| 12 | /SDF/ZQLMD |
TABLENAME | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  PROGNAME |
/SDF/ZQLMD |
PROGNAME | PROGNAME | ABAP Program Name | |||
| 2 | PROGKIND |
/SDF/ZQLMD |
PROGKIND | /SDF/ZQLMPROGKIND | SQL Monitor: Program Kind | |||
| 3 | PROCTYPE |
/SDF/ZQLMD |
PROCTYPE | /SDF/ZQLMPROCTYPE | SQL Monitor: Processing Block Type | |||
| 4 | PROCNAME |
/SDF/ZQLMD |
PROCNAME | /SDF/ZQLMPROCNAME | SQL Monitor: Processing Block Name | |||
| 5 | PROCLINE |
/SDF/ZQLMD |
PROCLINE | /SDF/ZQLMPROCLINE | SQL Monitor: Line Number in Processing Block | |||
| 6 | RUNLEVEL |
/SDF/ZQLMD |
RUNLEVEL | /SDF/ZQLMRUNLEVEL | SQL Monitor: Run Mode | |||
| 7 | ROOTTYPE |
/SDF/ZQLMD |
ROOTTYPE | /SDF/ZQLMROOTTYPE | SQL Monitor: Request Type | |||
| 8 | ROOTNAME |
/SDF/ZQLMD |
ROOTNAME | /SDF/ZQLMROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | |||
| 9 | STMTKIND |
/SDF/ZQLMD |
STMTKIND | /SDF/ZQLMSTMTKIND | SQL Monitor: SQL Operation | |||
| 10 | TABLENAMES |
/SDF/ZQLMT |
TABLENAMES | /SDF/ZQLMTABLENAMES | SQL Monitor: Table Names | |||
| 11 | TABLENAME |
/SDF/ZQLMD |
TABLENAME | /SDF/ZQLMTABLENAME | SQL Monitor: Table Name | |||
| 12 | INCLUDE |
/SDF/ZQLMI |
INCLUDE | PROGNAME | ABAP Program Name | |||
| 13 | LINE |
/SDF/ZQLMI |
LINE | INT4 | Natural number | |||
| 14 | PGMID |
/SDF/ZQLMI |
PGMID | PGMID | Program ID in Requests and Tasks | |||
| 15 | OBJECT |
/SDF/ZQLMI |
OBJECT | TROBJTYPE | Object Type | |||
| 16 | OBJ_NAME |
/SDF/ZQLMI |
OBJ_NAME | SOBJ_NAME | Object Name in Object Directory | |||
| 17 | DEVCLASS |
/SDF/ZQLMI |
DEVCLASS | DEVCLASS | Package | |||
| 18 | XCNT |
/SDF/ZQLMD |
XCNT | /SDF/ZQLMEXECNT | SQL Monitor: Total Number of Executions | |||
| 19 | RCNT |
/SDF/ZQLMD |
RCNT | /SDF/ZQLMROLLAREACNT | SQL Monitor: Internal Sessions Affected | |||
| 20 | XCNTRCNT |
/SDF/ZQLMD |
XCNTRCNT | /SDF/ZQLMEXECNTROLLAREACNT | SQL Monitor: Executions per Internal Sessions | |||
| 21 | RTMIN |
/SDF/ZQLMD |
RTMIN | /SDF/ZQLMRUNTIMEMIN | SQL Monitor: Minimum Value of Execution Time | |||
| 22 | RTMAX |
/SDF/ZQLMD |
RTMAX | /SDF/ZQLMRUNTIMEMAX | SQL Monitor: Maximum Value of Execution Time | |||
| 23 | RTCNT |
/SDF/ZQLMD |
RTCNT | /SDF/ZQLMRUNTIMECNT | SQL Monitor: Count | |||
| 24 | RTSUM |
/SDF/ZQLMD |
RTSUM | /SDF/ZQLMRUNTIMESUM | SQL Monitor: Total Execution Time | |||
| 25 | RTSQS |
/SDF/ZQLMD |
RTSQS | /SDF/ZQLMRUNTIMESQS | SQL Monitor: Runtime Sum of Squares | |||
| 26 | RTAVG |
/SDF/ZQLMD |
RTAVG | /SDF/ZQLMRUNTIMEAVG | SQL Monitor: Mean Value of Execution Time | |||
| 27 | RTDEV |
/SDF/ZQLMD |
RTDEV | /SDF/ZQLMRUNTIMEDEV | SQL Monitor: Standard Deviation of Execution Time | |||
| 28 | DBMIN |
/SDF/ZQLMD |
DBMIN | /SDF/ZQLMDBCOUNTMIN | SQL Monitor: Minimum Value of Fetched / Modified Records | |||
| 29 | DBMAX |
/SDF/ZQLMD |
DBMAX | /SDF/ZQLMDBCOUNTMAX | SQL Monitor: Maximum Value of Fetched / Modified Records | |||
| 30 | DBCNT |
/SDF/ZQLMD |
DBCNT | /SDF/ZQLMDBCOUNTCNT | SQL Monitor: DB Count Count | |||
| 31 | DBSUM |
/SDF/ZQLMD |
DBSUM | /SDF/ZQLMDBCOUNTSUM | SQL Monitor: Total Fetched or Modified Records | |||
| 32 | DBSQS |
/SDF/ZQLMD |
DBSQS | /SDF/ZQLMDBCOUNTSQS | SQL Monitor: DB Count Sum of Squares | |||
| 33 | DBAVG |
/SDF/ZQLMD |
DBAVG | /SDF/ZQLMDBCOUNTAVG | SQL Monitor: Mean Value of Fetched / Modified Records | |||
| 34 | DBDEV |
/SDF/ZQLMD |
DBDEV | /SDF/ZQLMDBCOUNTDEV | SQL Monitor: Standard Deviation of Fetched / Modif. 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 | 20140922 |
| SAP Release Created in | 702 |
