SAP ABAP Table /SDF/SQLHIST_DISP (Display structure for SQLM History)
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 | INTTAB | Structure |
| Structure | /SDF/SQLHIST_DISP |
Table Relationship Diagram 
|
| Short Description | Display structure for SQLM History |
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 | Generated Table for View | |||||
| 2 | TIMESTAMP |
/SDF/SQLTIMESTAMP | /SDF/SQLTIMESTAMP | DEC | 15 | 0 | Timestamp for SQLM Data Collection | ||
| 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 | RUNLEVEL |
/SDF/ZQLMRUNLEVEL | /SDF/ZQLMRUNLEVEL | CHAR | 1 | 0 | SQL Monitor: Run Mode | ||
| 9 | ROOTTYPE |
/SDF/ZQLMROOTTYPE | /SDF/ZQLMROOTTYPE | CHAR | 1 | 0 | SQL Monitor: Request Type | ||
| 10 | ROOTNAME |
/SDF/ZQLMROOTNAME | CHAR | 60 | 0 | SQL Monitor: Request Entry Point (Transaction, etc.) | |||
| 11 | STMTKIND |
/SDF/ZQLMSTMTKIND | /SDF/ZQLMSTMTKIND | CHAR | 1 | 0 | SQL Monitor: SQL Operation | ||
| 12 | TABLENAME |
/SDF/ZQLMTABLENAME | DBOBJ_NAME | CHAR | 16 | 0 | SQL Monitor: Table Name | ||
| 13 | HASH |
HASH160X | RAW | 20 | 0 | Hash Value (160 Bits) | |||
| 14 | INCLUDE |
PROGNAME | PROGNAME | CHAR | 40 | 0 | ABAP Program Name | ||
| 15 | LINE |
INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
| 16 | PGMID |
PGMID | PGMID | CHAR | 4 | 0 | Program ID in Requests and Tasks | ||
| 17 | OBJECT |
TROBJTYPE | OBJECT | CHAR | 4 | 0 | Object Type | ||
| 18 | OBJ_NAME |
SOBJ_NAME | SOBJ_NAME | CHAR | 40 | 0 | Object Name in Object Directory | ||
| 19 | DEVCLASS |
DEVCLASS | DEVCLASS | CHAR | 30 | 0 | Package | * | |
| 20 | TABLENAMES |
/SDF/ZQLMTABLENAMES | CHAR | 160 | 0 | SQL Monitor: Table Names | |||
| 21 | XCNT |
/SDF/SQLMEXECNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Total Number of Executions | ||
| 22 | RCNT |
/SDF/SQLMROLLAREACNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Internal Sessions Affected | ||
| 23 | XCNTRCNT |
/SDF/ZQLMEXECNTROLLAREACNT | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Executions per Internal Sessions | ||
| 24 | RTMIN |
/SDF/ZQLMRUNTIMEMIN | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Minimum Value of Execution Time | ||
| 25 | RTMAX |
/SDF/ZQLMRUNTIMEMAX | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Maximum Value of Execution Time | ||
| 26 | RTCNT |
/SDF/SQLMRUNTIMECNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Count | ||
| 27 | RTSUM |
/SDF/ZQLMRUNTIMESUM | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Total Execution Time | ||
| 28 | RTSQS |
/SDF/ZQLMRUNTIMESQS | /SDF/ZQLMDECIMAL6 | DEC | 31 | 6 | SQL Monitor: Runtime Sum of Squares | ||
| 29 | RTAVG |
/SDF/ZQLMRUNTIMEAVG | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Mean Value of Execution Time | ||
| 30 | RTDEV |
/SDF/ZQLMRUNTIMEDEV | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Standard Deviation of Execution Time | ||
| 31 | DBMIN |
/SDF/ZQLMDBCOUNTMIN | INT4 | 10 | 0 | SQL Monitor: Minimum Value of Fetched / Modified Records | |||
| 32 | DBMAX |
/SDF/ZQLMDBCOUNTMAX | INT4 | 10 | 0 | SQL Monitor: Maximum Value of Fetched / Modified Records | |||
| 33 | DBCNT |
/SDF/SQLMDBCOUNTCNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: DB Count Count | ||
| 34 | DBSUM |
/SDF/ZQLMDBCOUNTSUM | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Total Fetched or Modified Records | ||
| 35 | DBSQS |
/SDF/ZQLMDBCOUNTSQS | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: DB Count Sum of Squares | ||
| 36 | DBAVG |
/SDF/ZQLMDBCOUNTAVG | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Mean Value of Fetched / Modified Records | ||
| 37 | DBDEV |
/SDF/ZQLMDBCOUNTDEV | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Standard Deviation of Fetched / Modif. Records | ||
| 38 | DATEFROM |
/SDF/SQLDATEFROM | DATS | 8 | 0 | Begin of Data Collection | |||
| 39 | TIMEFROM |
/SDF/SQLTIMEFROM | /SDF/SQLTIMEFROM | TIMS | 6 | 0 | Start time of data collection | ||
| 40 | DATETO |
/SDF/SQLDATETO | DATS | 8 | 0 | Begin of Data Collection | |||
| 41 | TIMETO |
/SDF/SQLTIMETO | TIMS | 6 | 0 | Start time of data collection | |||
| 42 | DURATION |
/SDF/SQLDURATION | INT4 | 10 | 0 | Duration of time slot in seconds | |||
| 43 | STMTKIND_TXT |
/SDF/ZQLMSTMTKIND_TXT | TEXT30 | CHAR | 30 | 0 | SQL Monitor: SQL Operation | ||
| 44 | RUNLEVEL_TXT |
/SDF/ZQLMRUNLEVEL_TXT | TEXT30 | CHAR | 30 | 0 | SQL Monitor: Run Mode | ||
| 45 | ROOTTYPE_TXT |
/SDF/ZQLMROOTTYPE_TXT | TEXT30 | CHAR | 30 | 0 | SQL Monitor: Request Type |
History
| Last changed by/on | SAP | 20140922 |
| SAP Release Created in | 2008_1_700 |
