SAP Table SQLD_ST05
list of identical SQL statements (ST05)
SQLD_ST05 (list of identical SQL statements (ST05)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SQLD_ST05 to other SAP tables.
SQLD_ST05 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STAT_ID | Statement Identifier | SQL_STID | CHAR | 3 | 0 | |||||||||||||||
| EXECUTIONS | Total number of executions of identical statements | SQLTTOTALE | CHAR | 10 | 0 | |||||||||||||||
| IDENTICAL | Percentage of statements that are identical | SQLTSTATID | CHAR | 9 | 0 | |||||||||||||||
| DURATION | Total statement execution time | SQLTSDURA | CHAR | 12 | 0 | |||||||||||||||
| TIMEPEREXE | Average time per execution | SQLTTPEXEC | CHAR | 10 | 0 | |||||||||||||||
| ROWS | Total number of records processed | SQLTROWS | CHAR | 10 | 0 | |||||||||||||||
| ROWSPEREXE | Average number of records executed per execution | SQLTRPEXEC | CHAR | 10 | 0 | |||||||||||||||
| AVGTPERROW | Average processing time per record | SQLTAVGTPR | CHAR | 10 | 0 | |||||||||||||||
| MINTPERROW | Minimal processing time per record | SQLTMINTPR | CHAR | 10 | 0 | |||||||||||||||
| BUFFERTYPE | Table buffer type | SQLTBUFTYP | CHAR | 5 | 0 |
Possible values
|
||||||||||||||
| TABLEN | Table row length | SQLTTLENSI | CHAR | 6 | 0 | |||||||||||||||
| TABCLASS | Table category | SQLTTABCLA | CHAR | 8 | 0 |
Possible values
|
||||||||||||||
| TABLE_L | Object used in trace statement | SQLTTABLE | CHAR | 30 | 0 | |||||||||||||||
| STATEMENT | Short SQL statement | SQLTSTATM | CHAR | 110 | 0 | |||||||||||||||
