SAP ABAP Table /SDF/SQLHIST (SQL Monitor: Delta records for top SQL statements)
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
| Table Category | TRANSP | Transparent table |
| Transparent table | /SDF/SQLHIST |
Table Relationship Diagram 
|
| Short Description | SQL Monitor: Delta records for top SQL statements |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| 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 |  TIMESTAMP |
/SDF/SQLTIMESTAMP | /SDF/SQLTIMESTAMP | DEC | 15 | 0 | Timestamp for SQLM Data Collection | ||
| 2 | .INCLUDE |
0 | 0 | SQL Monitor: Key (Source) | |||||
| 3 | PROGNAME |
PROGNAME | PROGNAME | CHAR | 40 | 0 | ABAP Program Name | ||
| 4 | PROGKIND |
/SDF/ZQLMPROGKIND | /SDF/ZQLMPROGKIND | CHAR | 1 | 0 | SQL Monitor: Program Kind | ||
| 5 | PROCTYPE |
/SDF/ZQLMPROCTYPE | CHAR | 4 | 0 | SQL Monitor: Processing Block Type | |||
| 6 | PROCNAME |
/SDF/ZQLMPROCNAME | CHAR | 93 | 0 | SQL Monitor: Processing Block Name | |||
| 7 | PROCLINE |
/SDF/ZQLMPROCLINE | INT4 | 10 | 0 | SQL Monitor: Line Number in Processing Block | |||
| 8 | .INCLUDE |
0 | 0 | SQL Monitor: Subkey (Internal) | |||||
| 9 | RUNLEVEL |
/SDF/ZQLMRUNLEVEL | /SDF/ZQLMRUNLEVEL | CHAR | 1 | 0 | SQL Monitor: Run Mode | ||
| 10 | ROOTTYPE |
/SDF/ZQLMROOTTYPE | /SDF/ZQLMROOTTYPE | CHAR | 1 | 0 | SQL Monitor: Request Type | ||
| 11 | ROOTNAME |
/SDF/ZQLMROOTNAME | CHAR | 60 | 0 | SQL Monitor: Request Entry Point (Transaction, etc.) | |||
| 12 | STMTKIND |
/SDF/ZQLMSTMTKIND | /SDF/ZQLMSTMTKIND | CHAR | 1 | 0 | SQL Monitor: SQL Operation | ||
| 13 | TABLENAME |
/SDF/ZQLMTABLENAME | DBOBJ_NAME | CHAR | 16 | 0 | SQL Monitor: Table Name | ||
| 14 | HASH |
HASH160X | RAW | 20 | 0 | Hash Value (160 Bits) | |||
| 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 | PGMID |
PGMID | PGMID | CHAR | 4 | 0 | Program ID in Requests and Tasks | ||
| 19 | OBJECT |
TROBJTYPE | OBJECT | CHAR | 4 | 0 | Object Type | ||
| 20 | OBJ_NAME |
SOBJ_NAME | SOBJ_NAME | CHAR | 40 | 0 | Object Name in Object Directory | ||
| 21 | DEVCLASS |
DEVCLASS | DEVCLASS | CHAR | 30 | 0 | Package | * | |
| 22 | .INCLUDE |
0 | 0 | SQL Monitor: Payload | |||||
| 23 | XCNT |
/SDF/SQLMEXECNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Total Number of Executions | ||
| 24 | RCNT |
/SDF/SQLMROLLAREACNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Internal Sessions Affected | ||
| 25 | XCNTRCNT |
/SDF/ZQLMEXECNTROLLAREACNT | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Executions per Internal Sessions | ||
| 26 | RTMIN |
/SDF/ZQLMRUNTIMEMIN | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Minimum Value of Execution Time | ||
| 27 | RTMAX |
/SDF/ZQLMRUNTIMEMAX | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Maximum Value of Execution Time | ||
| 28 | RTCNT |
/SDF/SQLMRUNTIMECNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Count | ||
| 29 | RTSUM |
/SDF/ZQLMRUNTIMESUM | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Total Execution Time | ||
| 30 | RTSQS |
/SDF/ZQLMRUNTIMESQS | /SDF/ZQLMDECIMAL6 | DEC | 31 | 6 | SQL Monitor: Runtime Sum of Squares | ||
| 31 | RTAVG |
/SDF/ZQLMRUNTIMEAVG | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Mean Value of Execution Time | ||
| 32 | RTDEV |
/SDF/ZQLMRUNTIMEDEV | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Standard Deviation of Execution Time | ||
| 33 | DBMIN |
/SDF/ZQLMDBCOUNTMIN | INT4 | 10 | 0 | SQL Monitor: Minimum Value of Fetched / Modified Records | |||
| 34 | DBMAX |
/SDF/ZQLMDBCOUNTMAX | INT4 | 10 | 0 | SQL Monitor: Maximum Value of Fetched / Modified Records | |||
| 35 | DBCNT |
/SDF/SQLMDBCOUNTCNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: DB Count Count | ||
| 36 | DBSUM |
/SDF/ZQLMDBCOUNTSUM | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Total Fetched or Modified Records | ||
| 37 | DBSQS |
/SDF/ZQLMDBCOUNTSQS | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: DB Count Sum of Squares | ||
| 38 | DBAVG |
/SDF/ZQLMDBCOUNTAVG | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Mean Value of Fetched / Modified Records | ||
| 39 | DBDEV |
/SDF/ZQLMDBCOUNTDEV | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Standard Deviation of Fetched / Modif. Records | ||
| 40 | DDATE |
DATS | 8 | 0 | |||||
| 41 | DTIME |
TIMS | 6 | 0 |
History
| Last changed by/on | SAP | 20140922 |
| SAP Release Created in | 2008_1_700 |
