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