SAP table AMASTA (Global Performance Analysis: Application Statistc (from 7.0))
SAP table AMASTA has 4 primary key fields being PROCGUID,DESTIN,INSTANCE,LFNUM.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| PROCGUID | Log GUID for Performance Analysis | RAW | 16 | 0 | PROCGUID | ||
| DESTIN | Logical destination (specified in function call) | CHAR | 32 | 0 | * | RFCDEST | |
| INSTANCE | Instance Name | CHAR | 40 | 0 | MSNAME3 | ||
| LFNUM | Global Performance Analysis: Sequence Number | CHAR | 8 | 0 | LFNUMB | ||
| TCODE | Performance Log: Statistical Record Transaction Code | CHAR | 20 | 0 | * | STAT_TCODE | |
| OKEY | Performance Protocol Statistical Record Open Key (Text) | CHAR | 30 | 0 | OKEY | ||
| CONNECTION_NAME | Perofrmance Protocol Statisticsl Record DB Connection | CHAR | 30 | 0 | CONNECTION_NAME | ||
| STARTDATE | SAP Workload NW Collector: Date | DATS | 8 | 0 | SWNCDATUM | ||
| STARTTIME | SAP Workload NW Collector: Time | TIMS | 6 | 0 | SWNCUZEIT | ||
| ENDDATE | SAP Workload NW Collector: Date | DATS | 8 | 0 | SWNCDATUM | ||
| ENDTIME | SAP Workload NW Collector: Time | TIMS | 6 | 0 | SWNCUZEIT | ||
| REPORT | Performance Log: Statistical Record Program Name | CHAR | 40 | 0 | * | STAT_REPID | |
| TASKTYPE | Performance Log: Statistical Record Task Type | CHAR | 1 | 0 | STAT_TASKT | ||
| DYNPRONR | Performance Log: Statistical Record Screen Number | CHAR | 4 | 0 | STAT_DYNNR | ||
| WPROCTIME | Time in Work Process (Reponse Time - Wait Time) in ms | DEC | 24 | 2 | WPROCTIME2 | ||
| KBYTETRANS | Amount of Data Transferred in KB (= Queue + Source + DSQL) | DEC | 14 | 2 | KBYTETRANS2 | ||
| RESPTIME | Response Time in ms | DEC | 24 | 2 | RESPTIME2 | ||
| WAITTIME | Queue Wait Time in ms | DEC | 14 | 2 | WAITTIME2 | ||
| CPUTIME | CPU Time in ms | DEC | 18 | 2 | CPUTIME | ||
| LDGENTIME | Load and Generation Time in ms | DEC | 14 | 2 | LDGENTIME2 | ||
| MEMORYUSED | Memory Used in MBytes | DEC | 24 | 2 | MEMORYUSED2 | ||
| DBTIME | Database Time in ms | DEC | 24 | 2 | DBTIME2 | ||
| DBCHANGES | Number of Physical Database Changes | DEC | 14 | 2 | DBCHANGES2 | ||
| ROUNDTRIPS | SAP Workload: Number of Roundtrips | DEC | 18 | 2 | ROUNDTRIPS | ||
| INDATA | Average Data Volume to Application Server per Step (kBytes) | DEC | 16 | 2 | INDATA_P | ||
| OUTDATA | Average Data Volume to Front End per Step (kBytes) | DEC | 16 | 2 | OUTDATA_P | ||
| RECPROCNUM_ST | Total Number of DB Recs Delivered to Program (Statistics) | DEC | 15 | 2 | RECPROCNUM_ST2 | ||
| TOTALEX_ST | Number of Database Accesses (SEL, UPD, INS, DEL)(Statistics) | DEC | 15 | 2 | TOTALEX_ST2 |