SAP AMSUR Global Performance Analysis: Overview Summarized Log Data Table

Overview

AMSUR is a standard SAP S/4HANA table that stores Global Performance Analysis: Overview Summarized Log Data data. There are total 8 fields in the AMSUR table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table AMSUR 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 AMSUR to other SAP tables and standard CDS views available based on AMSUR table in S/4HANA 2020.

Techincal Settings of AMSUR

Below are technical details of the table AMSUR

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of AMSUR Fields

The following table gives you an overview of the fields available in AMSUR

FieldDescriptionData ElementCheck TableData TypeLength
PROCGUIDLog GUID for Performance AnalysisPROCGUIDRAW16
DESTINLogical destination (specified in function call)RFCDEST*CHAR32
LFNUMGlobal Performance Analysis: Sequence NumberLFNUMBCHAR8
ASCHEMAName of Evaluation Schema (Global Performance Analysis)ASCHEMACHAR56
AOBJECTName of Evaluation Object (Global Performance Analysis)AOBJECTCHAR56
TOTALEXECTotal Number of Executions of Identical SQL StatementsTOTALEXECDEC10
EXECTIMETotal Runtime for SQL Statements (in Microseconds)EXECTIMEDEC12
RECPROCNUMTotal Number of Database Records Passed to ProgramRECPROCNUMDEC10

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 AMSUR

Other References