SAP AMSSU Global Performance Analysis: Trace Summary SQL Statements Table
Overview
AMSSU is a standard SAP S/4HANA table that stores Global Performance Analysis: Trace Summary SQL Statements data. There are total 16 fields in the AMSSU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AMSSU 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 AMSSU to other SAP tables and standard CDS views available based on AMSSU table in S/4HANA 2020.
Techincal Settings of AMSSU
Below are technical details of the table AMSSU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AMSSU Fields
The following table gives you an overview of the fields available in AMSSU
| 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 | SQLSTATEM | CHAR | 110 | |
| TOTALEXEC | Total Number of Executions of Identical SQL Statements | TOTALEXEC | DEC | 10 | |
| IDENTSEL | Percentage of Identical SQL Statement | IDENTSEL | DEC | 9 | |
| EXECTIME | Total Runtime for SQL Statements (in Microseconds) | EXECTIME | DEC | 12 | |
| RECPROCNUM | Total Number of Database Records Passed to Program | RECPROCNUM | DEC | 10 | |
| TIMEPEREXE | Average Execution Time per SQL Statement (in ms) | TIMEPEREXE | CHAR | 10 | |
| RECPEREXE | Average Number of Database Records per SQL Statement | RECPEREXE | CHAR | 10 | |
| AVGTPERREC | Average Processing Time per Database Record | AVGTPERREC | CHAR | 10 | |
| MINTPERREC | Minimum Processing Time per Database Record | MINTPERREC | CHAR | 10 | |
| TABROWLEN | Record Length of Specified Table | TABROWLEN | CHAR | 6 | |
| BUFTYPE | Type of Buffer for Specified Table | BUFTYPE | CHAR | 5 | |
| TABLECLASS | Table Category of Specified Table | TABLECLASS | CHAR | 8 |
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 AMSSU