ST05_IDENTICAL_RECORD SAP (Identical Trace Record (Structure and Value)) Structure details
Description: Identical Trace Record (Structure and Value)
Related tables to ST05_IDENTICAL_RECORD
Access table ST05_IDENTICAL_RECORD
Structure field list including key, data, relationships and ABAP select examples
ST05_IDENTICAL_RECORD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Identical Trace Record (Structure and Value)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ST05_IDENTICAL_RECORD TYPE ST05_IDENTICAL_RECORD.
The ST05_IDENTICAL_RECORD table consists of various fields, each holding specific information or linking keys about Identical Trace Record (Structure and Value) data available in SAP. These include DURATION (Execution Duration of a Traced Activity [Microsecs]), NUMBER_OF_ROWS (Number of Accessed Records of Traced Activity), OBJECT (Object That a Traced Activity Accessed), STATEMENT_WITH_NAMES (Statement of Traced Activity).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP ST05_IDENTICAL_RECORD structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| DURATION | Execution Duration of a Traced Activity [Microsecs] | ST05_DURATION | DEC | 15 | |||||
| NUMBER_OF_ROWS | Number of Accessed Records of Traced Activity | ST05_ROWS | INT4 | 10 | |||||
| OBJECT | Object That a Traced Activity Accessed | ST05_OBJECT | CHAR | 30 | |||||
| STATEMENT_WITH_NAMES | Statement of Traced Activity | ST05_STATEMENT | STRG | 0 | |||||
| STATEMENT_WITH_VALUES | Statement of Traced Activity | ST05_STATEMENT | STRG | 0 | |||||
| CURSOR | Cursor of Traced SQL Activity | ST05_CURSOR | CHAR | 4 | CHAR4 | ||||
| NUMBER_OF_EXECUTIONS | Total Number of Executions of Activity | ST05_EXECUTIONS | INT4 | 10 | |||||
| ABS_NUMBER_OF_IDENTICAL_EXECS | Absolute Number of Identical Executions of a Statement | ST05_ABS_IDENTICAL_EXECUTIONS | INT4 | 10 | |||||
| REL_NUMBER_OF_IDENTICAL_EXECS | Relative Number of Identical Executions of Activity | ST05_REL_IDENTICAL_EXECUTIONS | INT4 | 10 | |||||
| DURATION_PER_EXECUTION | Duration of Activity per Execution | ST05_DURATION_PER_EXECUTION | DEC | 15 | |||||
| ROWS_PER_EXECUTION | Accessed Records of Activity per Execution | ST05_ROWS_PER_EXECUTION | DEC | 16(1) | |||||
| MEAN_DURATION_PER_ROW | Duration of Activity per Accessed Row | ST05_MEAN_DURATION_PER_ROW | DEC | 16 | |||||
| MIN_DURATION_PER_ROW | Minimum Duration of Activity per Accessed Row | ST05_MIN_DURATION_PER_ROW | DEC | 16 | |||||
| TABLEN | Record Length of DDIC Object (Table or View) in Bytes | ST05_OBJECT_LENGTH | INT4 | 10 | |||||
| BUFFER_TYPE | Buffer Type of DDIC Object (Table or View) | ST05_OBJECT_BUFFER_TYPE | CHAR | 5 | |||||
| TABCLASS | Type of DDIC Object (Table or View) | ST05_OBJECT_TYPE | CHAR | 8 | TABCLASS | ||||
| TRANS_ID | Transaction ID | ST05_TRANS_ID | CHAR | 32 | |||||
| EPP_ROOT_ID | EPP Root ID | ST05_EPP_ROOT_ID | CHAR | 32 | |||||
| EPP_CONNECTION_ID | EPP Connection ID | ST05_EPP_CONN_ID | CHAR | 32 | |||||
| EPP_CONNECTION_COUNTER | EPP Connection Counter | ST05_EPP_CONN_CNT | INT4 | 10 | |||||
| RECORD_NUMBER | Sequence Number of Trace Record | ST05_RECORD_NUMBER | INT4 | 10 | |||||
| LENGTH_OF_STATEMENT_WITH_NAMES | 0 | ||||||||
| VARIABLES | 0 | ||||||||
| NUMBER_OF_VARIABLES | 0 | ||||||||
| RECORD_NUMBERS | 0 | ||||||||
| STRUCTURE_IDENTICAL | 0 | ||||||||
| VALUE_IDENTICAL | 0 | ||||||||
| TRACE_TYPE | Trace Type (SQL, BUF, RFC, HTTP, ENQ) | ST05_TRACE_TYPE | CHAR | 4 | |||||
| LINE_COLOR | 0 |
| Key field | Non-key field |
How do I retrieve data from SAP structure ST05_IDENTICAL_RECORD using ABAP code?
As ST05_IDENTICAL_RECORD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ST05_IDENTICAL_RECORD as there is no data to select.How to access SAP table ST05_IDENTICAL_RECORD
Within an ECC or HANA version of SAP you can also view further information about ST05_IDENTICAL_RECORD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects