Page History
...
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, Transaction, program, Appsvr, or Application. Also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
SPTS_PWII_INSTANCE_ID | The instance ID. |
SPTS_TIMESTAMP | The end time of the transaction aligned to the time grain of the table (hour, day, etc.). |
SPTS_RECEIVED_TIMESTAMP | The received timestamp. |
SPTS_MINUTES_COUNT_SUM | The minutes count. |
SPTS_PWHG_ID | The hour group in the PW. |
SPTS_TRAN_KEY | The transaction ID (TCODE or Program). |
SPTS_APP_KEY | The ID of application to which the transaction TCODE belongs. |
SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
SPTS_CLIENT | The ID of the SAP client executing the step. |
SPTS_WORK_TYPE | The transaction's work type. For example: Dialog, Update, or Program. |
SPTS_STEP_COUNT_SUM | Number of steps per transaction. |
SPTS_TRAN_COUNT_SUM | Number of identical transactions per time slice. |
SPTS_RFC_TIME_SUM | Total time spent in the remote function calls, in seconds. |
SPTS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process, in seconds. |
SPTS_APP_TIME_SUM | Total time spent in the application server, in seconds. |
SPTS_DB_TIME_SUM | Total time spent in the database, in seconds. |
SPTS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA, and screen information. |
SPTS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock, in seconds. |
SPTS_CPU_TIME_SUM | |