SAP ABAP View /SDF/SQLHISTV (SQLM: View on historical data)
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/SQLHISTV | |
| Short Description | SQLM: View on historical data | |
| Root table | /SDF/SQLHIST | SQL Monitor: Delta records for top SQL statements |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /SDF/SQLHIST |
/SDF/SQLHIST | ||
| 2 | /SDF/SQLTIMST |
|||
| 3 | /SDF/SQLMT |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /SDF/SQLHIST |
TIMESTAMP | JL | EQ | 0 | 0 | ||||
| 2 | /SDF/SQLTIMST |
TIMESTAMP | JR | EQ | AND | 0 | 0 | |||
| 3 | /SDF/SQLHIST |
TABLENAME | JL | EQ | 0 | 0 | ||||
| 4 | /SDF/SQLMT |
TABLENAME | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  TIMESTAMP |
/SDF/SQLHIST |
TIMESTAMP | /SDF/SQLTIMESTAMP | Timestamp for SQLM Data Collection | |||
| 2 | PROGNAME |
/SDF/SQLHIST |
PROGNAME | PROGNAME | ABAP Program Name | |||
| 3 | PROGKIND |
/SDF/SQLHIST |
PROGKIND | /SDF/ZQLMPROGKIND | SQL Monitor: Program Kind | |||
| 4 | PROCTYPE |
/SDF/SQLHIST |
PROCTYPE | /SDF/ZQLMPROCTYPE | SQL Monitor: Processing Block Type | |||
| 5 | PROCNAME |
/SDF/SQLHIST |
PROCNAME | /SDF/ZQLMPROCNAME | SQL Monitor: Processing Block Name | |||
| 6 | PROCLINE |
/SDF/SQLHIST |
PROCLINE | /SDF/ZQLMPROCLINE | SQL Monitor: Line Number in Processing Block | |||
| 7 | RUNLEVEL |
/SDF/SQLHIST |
RUNLEVEL | /SDF/ZQLMRUNLEVEL | SQL Monitor: Run Mode | |||
| 8 | ROOTTYPE |
/SDF/SQLHIST |
ROOTTYPE | /SDF/ZQLMROOTTYPE | SQL Monitor: Request Type | |||
| 9 | ROOTNAME |
/SDF/SQLHIST |
ROOTNAME | /SDF/ZQLMROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | |||
| 10 | STMTKIND |
/SDF/SQLHIST |
STMTKIND | /SDF/ZQLMSTMTKIND | SQL Monitor: SQL Operation | |||
| 11 | TABLENAME |
/SDF/SQLHIST |
TABLENAME | /SDF/ZQLMTABLENAME | SQL Monitor: Table Name | |||
| 12 | HASH |
/SDF/SQLHIST |
HASH | HASH160X | Hash Value (160 Bits) | |||
| 13 | INCLUDE |
/SDF/SQLHIST |
INCLUDE | PROGNAME | ABAP Program Name | |||
| 14 | LINE |
/SDF/SQLHIST |
LINE | INT4 | Natural number | |||
| 15 | PGMID |
/SDF/SQLHIST |
PGMID | PGMID | Program ID in Requests and Tasks | |||
| 16 | OBJECT |
/SDF/SQLHIST |
OBJECT | TROBJTYPE | Object Type | |||
| 17 | OBJ_NAME |
/SDF/SQLHIST |
OBJ_NAME | SOBJ_NAME | Object Name in Object Directory | |||
| 18 | DEVCLASS |
/SDF/SQLHIST |
DEVCLASS | DEVCLASS | Package | |||
| 19 | TABLENAMES |
/SDF/SQLMT |
TABLENAMES | /SDF/ZQLMTABLENAMES | SQL Monitor: Table Names | |||
| 20 | XCNT |
/SDF/SQLHIST |
XCNT | /SDF/SQLMEXECNT | SQL Monitor: Total Number of Executions | |||
| 21 | RCNT |
/SDF/SQLHIST |
RCNT | /SDF/SQLMROLLAREACNT | SQL Monitor: Internal Sessions Affected | |||
| 22 | XCNTRCNT |
/SDF/SQLHIST |
XCNTRCNT | /SDF/ZQLMEXECNTROLLAREACNT | SQL Monitor: Executions per Internal Sessions | |||
| 23 | RTMIN |
/SDF/SQLHIST |
RTMIN | /SDF/ZQLMRUNTIMEMIN | SQL Monitor: Minimum Value of Execution Time | |||
| 24 | RTMAX |
/SDF/SQLHIST |
RTMAX | /SDF/ZQLMRUNTIMEMAX | SQL Monitor: Maximum Value of Execution Time | |||
| 25 | RTCNT |
/SDF/SQLHIST |
RTCNT | /SDF/SQLMRUNTIMECNT | SQL Monitor: Count | |||
| 26 | RTSUM |
/SDF/SQLHIST |
RTSUM | /SDF/ZQLMRUNTIMESUM | SQL Monitor: Total Execution Time | |||
| 27 | RTSQS |
/SDF/SQLHIST |
RTSQS | /SDF/ZQLMRUNTIMESQS | SQL Monitor: Runtime Sum of Squares | |||
| 28 | RTAVG |
/SDF/SQLHIST |
RTAVG | /SDF/ZQLMRUNTIMEAVG | SQL Monitor: Mean Value of Execution Time | |||
| 29 | RTDEV |
/SDF/SQLHIST |
RTDEV | /SDF/ZQLMRUNTIMEDEV | SQL Monitor: Standard Deviation of Execution Time | |||
| 30 | DBMIN |
/SDF/SQLHIST |
DBMIN | /SDF/ZQLMDBCOUNTMIN | SQL Monitor: Minimum Value of Fetched / Modified Records | |||
| 31 | DBMAX |
/SDF/SQLHIST |
DBMAX | /SDF/ZQLMDBCOUNTMAX | SQL Monitor: Maximum Value of Fetched / Modified Records | |||
| 32 | DBCNT |
/SDF/SQLHIST |
DBCNT | /SDF/SQLMDBCOUNTCNT | SQL Monitor: DB Count Count | |||
| 33 | DBSUM |
/SDF/SQLHIST |
DBSUM | /SDF/ZQLMDBCOUNTSUM | SQL Monitor: Total Fetched or Modified Records | |||
| 34 | DBSQS |
/SDF/SQLHIST |
DBSQS | /SDF/ZQLMDBCOUNTSQS | SQL Monitor: DB Count Sum of Squares | |||
| 35 | DBAVG |
/SDF/SQLHIST |
DBAVG | /SDF/ZQLMDBCOUNTAVG | SQL Monitor: Mean Value of Fetched / Modified Records | |||
| 36 | DBDEV |
/SDF/SQLHIST |
DBDEV | /SDF/ZQLMDBCOUNTDEV | SQL Monitor: Standard Deviation of Fetched / Modif. Records | |||
| 37 | DATEFROM |
/SDF/SQLTIMST |
DATEFROM | /SDF/SQLDATEFROM | Begin of Data Collection | |||
| 38 | TIMEFROM |
/SDF/SQLTIMST |
TIMEFROM | /SDF/SQLTIMEFROM | Start time of data collection | |||
| 39 | DATETO |
/SDF/SQLTIMST |
DATETO | /SDF/SQLDATETO | Begin of Data Collection | |||
| 40 | TIMETO |
/SDF/SQLTIMST |
TIMETO | /SDF/SQLTIMETO | Start time of data collection | |||
| 41 | DURATION |
/SDF/SQLTIMST |
DURATION | /SDF/SQLDURATION | Duration of time slot in seconds | |||
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 | 2008_1_700 |
