Page History
...
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, or Host. 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_HOST_KEY | The host machine ID, on which the transaction took place. |
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 | CPU time consumed by the work processes, in seconds. |
SPTS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server, in seconds. |
SPTS_GUI_TIME_SUM | The GUI time, in seconds. Available from SAP 4.6. |
SPTS_FENET_TIME_SUM | The FE Net time, in seconds. Available from SAP 4.6. |
SPTS_ROUNDTRIPS_SUM | Number of round-trips performed. Available from SAP 4.6. |
SPTS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
SPTS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
SPTS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
SPTS_INPUTBYTES_SUM | Total number of bytes transferred from the front end to the application server. |
SPTS_OUTPUTBYTES_SUM | Total number of bytes transferred from the application server to the front end. |
SPTS_PHY_READ_COUNT_SUM | Number of read access performed to the database. Cannot be satisfied from SAP buffers. |
SPTS_DB_SEQ_REQS_SUM | Number of requests for database sequential read. |
SPTS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
SPTS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads, in seconds. |
SPTS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
SPTS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
SPTS_DB_DIR_TIME_SUM | Time spent in the database for direct reads, in seconds. |
SPTS_DB_ROWS_READ_SUM | Number of rows read from the database. |
SPTS_DB_READ_REQS_SUM | Total number of database read requests. |
SPTS_DB_REQS_SUM | Total number of database requests. |
SPTS_RFC_SRV_DEST_COUNT_SUM | For future use. |
SPTS_RFC_SRV_CALLS_COUNT_SUM | For future use. |
SPTS_RFC_SRV_CALL_TIME_SUM | For future use. |
SPTS_RFC_SRV_EXE_TIME_SUM | For future use. |
SPTS_RFC_SRV_DATA_SENT_SUM | For future use. |
SPTS_RFC_SRV_DATA_RCV_SUM | For future use. |
SPTS_RFC_CLNT_DEST_COUNT_SUM | For future use. |
SPTS_RFC_CLNT_CALLS_ COUNT_SUM | For future use. |
SPTS_RFC_CLNT_CALL_TIME_SUM | For future use. |
SPTS_RFC_CLNT_EXE_TIME_SUM | For future use. |
SPTS_RFC_CLNT_DATA_SENT_SUM | For future use. |
SPTS_RFC_CLNT_DATA_RCV_SUM | For future use. |
SPTS_GREEN_SUM | Number of transactions that their SLA time does not exceed their Near Breach or Breach SLA thresholds. |
SPTS_YELLOW_SUM | Number of transactions that their SLA time exceeds the Near Breach SLA threshold but not the Breach threshold. |
SPTS_RED_SUM | Number of transactions that their SLA time exceeds the Breach SLA threshold. |
PW_SPSS_APPSVR_AVAIL_STAT_T
Application Server Availability table. Also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
SPSS_PWII_INSTANCE_ID | The instance ID. |
SPSS_TIMESTAMP | The timestamp. |
SPSS_PWHG_ID | The hour group ID. |
SPSS_RECEIVED_TIMESTAMP | The received timestamp. |
SPSS_MINUTES_COUNT_SUM | The minutes count. |
SPSS_APPSVR_KEY | The application server key. |
SPSS_REAL_AVAILABILITY_AVG | The availability value. |
SPSS_AVAIL_WITH_DOWNTIME_AVG | The availability value with planned downtime. |
SPSS_TOTAL_COUNT_SUM | Total sampling count in the time slice. |
PW_SPFS_FUNCTION_STAT_T
Function (RFC) Statistics table. Also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
SPFS_PWII_INSTANCE_ID | The instance ID. |
SPFS_TIMESTAMP | The end time of the RFC aligned to the time grain of the table, such as hour, day, etc. |
SPFS_RECEIVED_TIMESTAMP | The received timestamp. |
SPFS_MINUTES_COUNT_SUM | The minutes count. |
SPFS_PWHG_ID | The hour group in the PW. |
SPFS_TRAN_KEY | The transaction ID (TCODE or Program). |
SPFS_APP_KEY | The ID of application to which the transaction's TCODE belongs. |
SPFS_ORG_KEY | The ID of organization to which the user belongs. |
SPFS_APPSVR_KEY | The ID of the application server where the RFC occurred. |
SPFS_LOCALE_KEY | The locale ID of the user running the RFC. |
SPFS_USER_KEY | The ID of the SAP user executing the RFC. |
SPFS_CLIENT | The ID of the SAP client executing the step. |
SPFS_FUNCTION_KEY | The ID of the Function executed. |
SPFS_PROGRAM_KEY | The ID of the Program to which the Function belongs. |
SPFS_RFC_USER_KEY | The RFC User ID. |
SPFS_IP_KEY | The ID of the IP running the RFC. |
SPFS_REMOTE_IP_KEY | The ID of the Remote IP running the RFC. |
SPFS_COUNT_SUM | Count of RFC. |
SPFS_RECEIVE_SUM | Bytes Received. |
SPFS_SEND_SUM | Bytes Sent. |
SPFS_EXE_TIME_SUM | Execution Time. |
SPFS_WAIT_TIME_SUM | Wait Time. |
SPFS_TARGET | Target. |
SPFS_DEST | Destination. |
SPFS_HOST | Host. |
SPFS_CALLER | Caller. |
SPFS_TID | Transaction ID. |
SPFS_GREEN_SUM | Number of transactions that their SLA time does not exceed their Near Breach or Breach SLA thresholds. |
SPFS_YELLOW_SUM | Number of transactions that their SLA time exceeds the Near Breach SLA threshold but not the Breach threshold. |
SPFS_RED_SUM | Number of transactions that their SLA time exceeds the Breach SLA threshold. |
PW_SPLS_LOCALE_STAT_T
Local availability table. Also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
SPLS_PWII_INSTANCE_ID | The instance ID. |
SPLS_TIMESTAMP | The timestamp. |
SPLS_PWHG_ID | The hour group ID. |
SPLS_RECEIVED_TIMESTAMP | The received timestamp. |
SPLS_MINUTES_COUNT_SUM | The minutes count. |
SPLS_LOCALE_KEY | The locale key. |
SPLS_REAL_AVAILABILITY_AVG | The availability value. |
SPLS_AVAIL_WITH_DOWNTIME_AVG | The availability value with planned downtime. |
SPLS_LOCALE_COUNT_SUM | Count. |
SPLS_LOCALE_SMPL_COUNT_SUM | Samples count. |
SPLS_LOCALE_TIME_AVG | Time average. |
SPLS_LOCALE_TIME_MAX | Time maximum. |
PW_SPUD_CURR_USER_DIM WITH_ORG
View for User dimensions with Organizations.
| Column Name | Column Description |
|---|---|
SPUD_PWII_INSTANCE_ID | The instance ID. |
SPUD_USER_NAME | The user name. |
SPUD_CLIENT | The client number. |
SPUD_ORG_NAME | The user's organization. |
SPUD_USER_AREA | The user's user area. |
PW_SPOV_ORGLOCALE_VIEW
_USER_DIM_WITH_ORG joined with locale dimension.
| Column Name | Column Description |
|---|---|
SPOV_TIMESTAMP | The timestamp. |
SPOV_INSTANCE_KEY | The instance ID. |
SPOV_LOCALE_KEY | The locale key. |
SPOV_ORG_KEY | The organization key. |
PW_SPCD_CLIENT_DIM
Client dimension.
| Column Name | Column Description |
|---|---|
SPCD_PWII_INSTANCE_ID | The instance ID. |
SPCD_CLIENT_KEY | The client key. |
SPCD_SID | The client SID. |
SPCD_CLIENT | The client name. |
SPCD_CHANGED_DT | The date when this record was last changed. |
SPCD_CLIENT_COMMENT | Comment. |
SPCD_IS_DELETED | Whether this record is deleted. |
SPCD_CLIENT_LANG | The client's language. |
PW_SPTD_TRAN_DIM
Transaction dimension.
| Column Name | Column Description |
|---|---|
SPTD_PWII_INSTANCE_ID | The instance ID. |
SPTD_APP_NAME | The application name of the transaction |
SPTD_CHANGE_DATE | The date when this record was last changed. |
SPTD_IS_TCODE | Whether this key is a TCODE or a program. |
SPTD_TRAN_NAME | The transaction name. |
SPTD_IS_DELETED | Whether this record is deleted. |
PW_SPLD_LOCALE_DIM
Locale dimension.