SAP AMTSU Global Performance Analysis: Trace Data SQL, Table View Table
Overview
AMTSU is a standard SAP S/4HANA table that stores Global Performance Analysis: Trace Data SQL, Table View data. There are total 8 fields in the AMTSU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AMTSU belongs to Transaction ST30: Tool for Automated Performance Tests (BC-TWB-TST-P-GPA) module and is located in the package New Performance Trace / Statistics with DB Connection (S_PERF_TRA).
In addition, following links provide an overview of foreign key relationships, if any, that link AMTSU to other SAP tables and standard CDS views available based on AMTSU table in S/4HANA 2020.
Techincal Settings of AMTSU
Below are technical details of the table AMTSU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AMTSU Fields
The following table gives you an overview of the fields available in AMTSU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| PROCGUID | Log GUID for Performance Analysis | PROCGUID | RAW | 16 | |
| DESTIN | Logical destination (specified in function call) | RFCDEST | * | CHAR | 32 |
| LFNUM | Global Performance Analysis: Sequence Number | LFNUMB | CHAR | 8 | |
| TABNAME | Table Name | TABNAME | * | CHAR | 30 |
| SQLSTATEM | Abbreviated SQL Statement | SQLSTAT_K | CHAR | 6 | |
| TOTALEXEC | Number of Database Accesses (SELECT, UPDATE, and INSERT) | TOTALEX_S | DEC | 10 | |
| RECPROCNUM | Total Number of Database Records Passed to Program | RECPROCNUM | DEC | 10 | |
| EXECTIME | Total Runtime for SQL Statements (in Microseconds) | EXECTIME | DEC | 12 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AMTSU