AMSP - SQL trace position info in application monitor
SQL trace position info in application monitor information is stored in SAP table AMSP.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table AMSP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TCODE | Program/Transaction in SQL Trace Evaluation | X | PROGRAM | CHAR | 40 | * |
| SAPRL | Release of SAP System | X | SYSAPRL | CHAR | 4 | |
| URSPR | Origin identifier in application monitor | X | SRCFLAG | CHAR | 1 | |
| UNAME | User Name | X | SYUNAME | CHAR | 12 | |
| MANDT | Client ID | X | SYMANDT | CLNT | 3 | * |
| ANDAT | Analysis date for application monitor | X | AM_ANDAT | DATS | 8 | |
| TRCKZ | Unique user-defined ID of an SQL trace | X | TRACEKZ | CHAR | 4 | |
| TNAME | Table name (extended version for application monitor) | X | AM_TNAME | CHAR | 30 | |
| SQLOP | SQL operation in trace (application monitor) | X | AM_SQLOP | CHAR | 2 | |
| NOOPS | No. of database accesses | AM_NOOPS | INT4 | 4 | ||
| NOROW | Number of data records accessed | AM_NOROW | INT4 | 4 | ||
| ACZEI | Cumulated database access time (application monitor) | AM_ACTIM | INT4 | 4 |