SAP ABAP Table SQLD_ST05 (list of identical SQL statements (ST05))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	INTTAB	Structure
Structure	SQLD_ST05	Table Relationship Diagram
Short Description	list of identical SQL statements (ST05)

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	STAT_ID	☐	SQL_STID	CHAR03	CHAR	3	0	Statement Identifier
2	.INCLUDE	☐				0	0	Idential Statement List Column for SQL Trace
3	EXECUTIONS	☐	SQLTTOTALE	CHAR10	CHAR	10	0	Total number of executions of identical statements
4	IDENTICAL	☐	SQLTSTATID	CHAR9	CHAR	9	0	Percentage of statements that are identical
5	DURATION	☐	SQLTSDURA	CHAR12	CHAR	12	0	Total statement execution time
6	TIMEPEREXE	☐	SQLTTPEXEC	CHAR10	CHAR	10	0	Average time per execution
7	ROWS	☐	SQLTROWS	CHAR10	CHAR	10	0	Total number of records processed
8	ROWSPEREXE	☐	SQLTRPEXEC	CHAR10	CHAR	10	0	Average number of records executed per execution
9	AVGTPERROW	☐	SQLTAVGTPR	CHAR10	CHAR	10	0	Average processing time per record
10	MINTPERROW	☐	SQLTMINTPR	CHAR10	CHAR	10	0	Minimal processing time per record
11	BUFFERTYPE	☐	SQLTBUFTYP	SQLTDBTYP	CHAR	5	0	Table buffer type
12	TABLEN	☐	SQLTTLENSI	CHAR6	CHAR	6	0	Table row length
13	TABCLASS	☐	SQLTTABCLA	TABCLASS	CHAR	8	0	Table category
14	TABLE_L	☐	SQLTTABLE	SQLTAS4TAB	CHAR	30	0	Object used in trace statement
15	STATEMENT	☐	SQLTSTATM	CHAR110	CHAR	110	0	Short SQL statement

History

Last changed by/on	SAP	20130604
SAP Release Created in	50A