PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
| PWII_ID | The instance ID. Columns of XXXX_PWII_INSTANCE_ID have values from the column. |
| PWII_INSTANCE_NAME | The name of the instance. |
| PWII_TECHNOLOGY | Two characters defining technology of the instance (such as OR for Oracle and JE for J2EE). |
| PWII_SERVER | The name of the server on which the instance is installed. |
PW_SPVS_AVAIL_STAT_LS_T
Calculated table showing total availably. Source tables are PW_SPSS_APPSVR_AVAIL_STAT_T and PW_SPLS_LOCALE_STAT_T.
| Column Name | Column Description |
|---|---|
| SPVS_PWII_INSTANCE_ID | The instance ID. |
| SPVS_TIMESTAMP | The sampling end time aligned to the time grain (5 minutes). |
| SPVS_RECEIVED_TIMESTAMP | The received timestamp. |
| SPVS_MINUTES_COUNT_SUM | The minutes count. |
| SPVS_PWHG_ID | The hour group in the PW. |
| SPVS_APPSVR_KEY | The application server ID, on which the job step occurred. |
| SPVS_LOCALE_KEY | The locale ID, on which the step took place. |
| SPVS_LOCALE_AVAIL_AVG | The average availability of the destinations in this locale’s locale. |
| SPVS_APPSVR_AVAIL_AVG | The average availability of the application server. |
| SPVS_REAL_AVAILABILITY_AVG | The average end to end availability. |
| SPVS_AVAIL_WITH_DOWNTIME_AVG | The average end to end availability, excluding planned down time in the average. |
PW_SPBS_BATCH_STAT_T
Batch step statistics table.
| Column Name | Column Description |
|---|---|
| SPBS_PWII_INSTANCE_ID | The instance ID. |
| SPBS_TIMESTAMP | The start time of the batch step. |
| SPBS_RECEIVED_TIMESTAMP | The received timestamp. |
| SPBS_MINUTES_COUNT_SUM | The minutes count. |
| SPBS_PWHG_ID | The hour group in the PW. |
| SPBS_HOST_KEY | The host machine ID, on which the transaction took place. |
| SPBS_APPSVR_KEY | The application server ID, on which the job step occurred. |
| SPBS_CLIENT | The ID of the SAP client executing the step. |
| SPBS_PGM_KEY | The ID of the executing ABAP program. |
| SPBS_USER_KEY | The ID of the user executing the job. |
| SPBS_ROW_ID | The row ID. |
| SPBS_JOB_KEY | The ID of the executed job. |
| SPBS_STEP_ID | The step order in the executed job. |
| SPBS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process (in seconds). |
| SPBS_APP_TIME_SUM | Total time spent in the application server (in seconds). |
| SPBS_DB_TIME_SUM | Total time spent in the database (in seconds). |
| SPBS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA and screen information. |
| SPBS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock (in seconds). |
| SPBS_CPU_TIME_SUM | CPU time consumed by the work processes (in seconds). |
| SPBS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server (in seconds). |
| SPBS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
| SPBS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
| SPBS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
| SPBS_PHY_READ_COUNT_SUM | Number of read access performed to the database (could not be satisfied from SAP buffers). |
| SPBS_DB_SEQ_REQS_SUM | Number of requests for database sequential read. |
| SPBS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
| SPBS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads (in seconds). |
| SPBS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
| SPBS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
| SPBS_DB_DIR_TIME_SUM | Time spent in the database for direct reads (in seconds). |
| SPBS_DB_ROWS_READ_SUM | Number of rows read from the database. |
| SPBS_DB_READ_REQS_SUM | Total number of database read requests. |
| SPBS_DB_REQS_SUM | Total number of database requests. |
PW_SPRS_APPSVR_BUFFER_STAT_T
Application server statistics. Also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
| SPRS_PWII_INSTANCE_ID | The instance ID. |
| SPRS_TIMESTAMP | The time of the host samples, aligned to five minutes. |
| SPRS_RECEIVED_TIMESTAMP | The received timestamp. |
| SPRS_MINUTES_COUNT_SUM | The minutes count. |
| SPRS_PWHG_ID | The hour group in the PW. |
| SPRS_APPSVR_KEY | The sampled application server ID. |
| SPRS_HOST_KEY | The host machine ID, on which the application server is installed. |
| SPRS_RECORD_COUNT_SUM | Total number of samples made to the application server in the specified time. |
| SPRS_USERS_AVG | Average number of connected users. |
| SPRS_SESSION_COUNT_AVG | Average sessions number. |
| SPRS_ACTIVE_USER_COUNT_AVG | Average number of active users in five minutes. |
| SPRS_ROLL_AREA_TOTAL_AVG | Total size of roll area, in KB. |
| SPRS_ROLL_AREA_IN_USE_AVG | Average size of used roll area, in KB. |
| SPRS_EXTEND_MEMORY_TOTAL_AVG | Size of available extended memory, in KB. |
| SPRS_EXTEND_MEMORY_IN_USE | Average size of used extended memory, meaning extended memory that is in allocated status, in KB. |
| SPRS_SELECT_SINGLE_COUNT_AVG | Number of requests for database direct reads. |
| SPRS_SELECT_COUNT_AVG | Number of requests for database direct and sequential reads. |
| SPRS_SCREEN_HIT_RATIO_AVG | Average hit ratio of screen buffer. |
| SPRS_SELECT_HIT_RATIO_AVG | Average hit ratio of DB read access. |
| SPRS_PROGRAM_HIT_RATIO_AVG | Average hit ratio of program buffer. |
| SPRS_SCREEN_HIT_RATIO_AVG | Average hit ratio of screen buffer. |
PW_SPHS_HOST_STAT_T
Host statistics table. Also has D, H, W, M, B, BT, BH, BD, BW, and BM summary levels.
| Column Name | Column Description |
|---|---|
| SPHS_PWII_INSTANCE_ID | The instance ID. |
| SPHS_TIMESTAMP | The time of the host samples (aligned to 5 minutes). |
| SPHS_RECEIVED_TIMESTAMP | The received timestamp. |
| SPHS_MINUTES_COUNT_SUM | The minutes count. |
| SPHS_PWHG_ID | The hour group in the PW. |
| SPHS_HOST_KEY | The sampled host machine ID. |
| SPHS_REC_COUNT_SUM | Total number of samples made to the host in the specified time. |
| SPHS_LOAD_AVG1_AVG | The average number of work processes waiting for a free processor. |
| SPHS_LOAD_AVG5_AVG | The average number of work processes waiting for a free processor. |
| SPHS_LOAD_AVG15_AVG | The average number of work processes waiting for a free processor. |
| SPHS_INTERRUPTS_AVG | The average number of times per second the operating system had to interrupt system resources during process activity. |
| SPHS_SYS_CALLS_AVG | The average number of times the operating system performed system (privileged/root) calls per second. |
| SPHS_CONTEXT_SW_AVG | The average number of times the operating system had to switch CPU resources from one form of work to another per second. |
| SPHS_USER_MODE_AVG | The average CPU workload caused by user processes (SAP system or database); average percentage of the CPU that is used for user processes. |
| SPHS_SYS_MODE_AVG | The average CPU workload caused by operating system processes; average percentage of the CPU that is used for operating system processes. |
| SPHS_IDLE_AVG | The average percentage of the CPU that was not consumed. |
| SPHS_PAGE_INS_AVG | The average paging in rate per second. |
| SPHS_PAGE_OUTS_AVG | The average paging out rate per second. |
| SPHS_KB_PAGE_INS_AVG | The average paging in data amount (in KB) per second. |
| SPHS_KB_PAGE_OUTS_AVG | The average paging out data amount (in KB) per second. |
| SPHS_PHYS_MEMORY_AVG | The amount of physical operating system memory (in KB). |
| SPHS_FREE_MEMORY_AVG | The average amount of free memory (in KB). |
| SPHS_SWAP_CONFIG_AVG | The configured size of the swap area (in KB). |
| SPHS_SWAP_FREE_AVG | The average free swap space (in KB). |
| SPHS_SWAP_SIZE_AVG | The average allocated swap space (in KB). |
| SPHS_SWAP_MAX | The maximum swap space (in KB) that was allocated. |
PW_SPDS_DETAILS_STAT_T
Step statistics table.
| Column Name | Column Description |
|---|---|
| SPDS_PWII_INSTANCE_ID | The instance ID. |
| SPDS_TIMESTAMP | The start time of the step aligned to the time grain (5 minutes). |
| SPDS_RECEIVED_TIMESTAMP | The received timestamp. |
| SPDS_MINUTES_COUNT_SUM | The minutes count. |
| SPDS_PWHG_ID | The hour group in the PW. |
| SPDS_LOCALE_KEY | The ID of the locale, on which the step took place. |
| SPDS_HOST_KEY | The ID of the host machine, on which the step took place. |
| SPDS_TCODE_KEY | The step's TCODE ID. |
| SPDS_TRAN_KEY | The step's TCODE or Program ID. |
| SPDS_PGM_KEY | The ID of the executing ABAP program. |
| SPDS_USER_KEY | The ID of the user executing the step. |
| SPDS_APP_KEY | The ID of application the step's TCODE belongs to. |
| SPDS_ORG_KEY | The ID of the user's organization executing the step. |
| SPDS_APPSVR_KEY | The ID of the application server, on which the step occurred. |
| SPDS_CLIENT | The ID of the SAP client user that executed the step belongs to. |
| SPDS_WORK_TYPE | The step's work type. For example: Dialog, Update, Program. |
| SPDS_TRAN_TYPE | The step detailed type. For example: Login/Logout , Buffer synchronization, etc. |
| SPDS_GUIPGM_NAME | The GUI program the step executed. |
| SPDS_DYNPRO | The screen number. |
| SPDS_STEP_COUNT_SUM | Number of identical steps per time slice. |
| SPDS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process (in seconds). |
| SPDS_RFC_TIME_SUM | Total time spent in remote function calls (in seconds). |
| SPDS_STEP_TIMESTAMP | The start time of the step. |
| SPDS_TERMINAL_KEY | The ID of the terminal which activated the step. |
| SPDS_APP_TIME_SUM | Total time spent in the application server (in seconds). |
| SPDS_DB_TIME_SUM | Total time spent in the database (in seconds). |
| SPDS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA, and screen information. |
| SPDS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock (in seconds). |
| SPDS_CPU_TIME_SUM | CPU time consumed by the work processes (in seconds). |
| SPDS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server (in seconds). |
| SPDS_GUI_TIME_SUM | The GUI time (in seconds) (available from SAP version 4.6). |
| SPDS_FENET_TIME_SUM | The FE Net time (in seconds) (available from SAP version 4.6). |
| SPDS_ROUNDTRIPS_SUM | Number of round-trips performed (available from SAP version 4.6). |
| SPDS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
| SPDS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
| SPDS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
| SPDS_INPUTBYTES_SUM | Total number of bytes transferred from the front end to the application server. |
| SPDS_OUTPUTBYTES_SUM | Total number of bytes transferred from the application server to the front end. |
| SPDS_PHY_READ_COUNT_SUM | Volume of read requests transferred to the database server. |
| SPDS_DB_SEQ_REQS_SUM | Number of requests for a database sequential read. |
| SPDS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
| SPDS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads (in seconds). |
| SPDS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
| SPDS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
| SPDS_DB_DIR_TIME_SUM | Time spent in the database for direct reads (in seconds). |
| SPDS_DB_ROWS_READ_SUM | Number of rows read from the database. |
| SPDS_DB_READ_REQS_SUM | Total number of database read requests. |
| SPDS_DB_REQS_SUM | Total number of database requests. |
| SPDS_RFC_SRV_DEST_COUNT_SUM | For future use. |
| SPDS_RFC_SRV_CALLS_COUNT_SUM | For future use. |
| SPDS_RFC_SRV_CALL_TIME_SUM | For future use. |
| SPDS_RFC_SRV_EXE_TIME_SUM | For future use. |
| SPDS_RFC_SRV_DATA_SENT_SUM | For future use. |
| SPDS_RFC_SRV_DATA_RCV_SUM | For future use. |
| SPDS_RFC_CLNT_DEST_COUNT_SUM | For future use. |
| SPDS_RFC_CLNT_CALLS_COUNT_SUM | For future use. |
| SPDS_RFC_CLNT_CALL_TIME_SUM | For future use. |
| SPDS_RFC_CLNT_EXE_TIME_SUM | For future use. |
| SPDS_RFC_CLNT_CLNT_DATA_SENT | For future use. |
| SPDS_RFC_CLNT_CLNT_DATA_RCV_SUM | For future use. |
Expressions
| Oracle | PRES | Expression Description |
|---|---|---|
| SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_GUI_TIME_SUM) | SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_GUI_TIME_SUM) | The sum of all the response time components of the step. |
| SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_ GUI_TIME_SUM)/SUM(SPDS_STEP_COUNT_SUM) | SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_ GUI_TIME_SUM)/SUM(SPDS_STEP_COUNT_SUM) | The average of all the response time components of the step. |
| SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM) | SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM) | The sum of the client time components of the step. |
| SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM)/ SUM(SPDS_STEP_COUNT_SUM) | SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM)/ SUM(SPDS_STEP_COUNT_SUM) | The average of the client time components of the step. |
PW_SPTS_TRAN_STAT_T
Transaction Statistics table. Also has D, H, W, M, B, BT, BH, BD, BW, and BM 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 (5 minutes). |
| SPTS_RECEIVED_TIMESTAMP | The received timestamp. |
| SPTS_MINUTES_COUNT_SUM | The minutes count. |
| SPTS_PWGH_ID | The hour group in the PW. |
| SPTS_LOCALE_KEY | The locale ID, on which the transaction took place. |
| SPTS_HOST_KEY | ID of the host machine, on which the transaction took place. |
| SPTS_TRAN_KEY | The ID of the transaction (Program or TCODE). |
| SPTS_USER_KEY | The ID of the user executing the transaction. |
| SPTS_APP_KEY | The ID of application to which the transaction's TCODE belongs. |
| SPTS_ORG_KEY | The ID of the user's organization executing the transaction. |
| SPTS_APPSVR_KEY | The ID of the application server, on which 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_TERMINAL_KEY | The ID of the terminal which activated the transaction. |
| SPTS_URL_KEY | The key of the URL that activated the transaction. |
| SPTS_TRAN_TYPE | The transaction's detailed type. For example: Login/Logout , Buffer synchronization, etc. |
| 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_ENG_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 version 4.6). |
| SPTS_FENET_TIME_SUM | The FE Net time (in seconds) (available from SAP version 4.6). |
| SPTS_ROUNDTRIPS_SUM | Number of round-trips performed (available from SAP version 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 (could not 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_START_BIT_MAP | Insight SmarTune bitmap. |
| 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. |
Expressions
| Oracle | PRES | Expression Description |
|---|---|---|
| SSUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | SSUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | The sum of all the response time components of the step. |
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_ GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_ GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of all the response time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | The sum of the client time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/ SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/ SUM(SPTS_STEP_COUNT_SUM) | The average of the client time components of the step. |
PW_SPTS_TRAN_STAT_AOLS_T
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, Locale, Appsvr, Organization, 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_LOCALE_KEY | The locale ID, on which the transaction took place. |
| SPTS_APP_KEY | The application ID to which the transaction's TCODE belongs. |
| SPTS_ORG_KEY | The ID of the user's organization executing the transaction. |
| SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
| SPTS_CLIENT | The ID of the SAP's 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 | 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 version 4.6). |
| SPTS_FENET_TIME_SUM | The FE Net time (in seconds) (available from SAP version 4.6). |
| SPTS_ROUNDTRIPS_SUM | Number of round-trips performed (available from SAP version 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 (could not 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_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. |
Expressions
| Oracle | PRES | Expression Description |
|---|---|---|
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | The sum of all the response time components of the step. |
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_ GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_ GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of all the response time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | The sum of the client time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/ SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/ SUM(SPTS_STEP_COUNT_SUM) | The average of the client time components of the step. |
PW_SPTS_TRAN_STAT_OA_T
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, Organization, 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_APP_KEY | The ID of application to which the transaction's TCODE belongs. |
| 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 transactions. |
| 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_TME_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 version 4.6). |
| SPTS_FENET_TIME_SUM | The FE Net time (in seconds) (available from SAP version 4.6). |
| SPTS_ROUNDTRIPS_SUM | Number of round-trips performed (available from SAP version 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 (could not 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_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. |
Expressions
| Oracle | PRES | Expression Description |
|---|---|---|
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | The sum of all the response time components of the step. |
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_ GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_ GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of all the response time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | The sum of the client time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/ SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/ SUM(SPTS_STEP_COUNT_SUM) | The average of the client time components of the step. |
PW_SPTS_TRAN_STAT_ATS_T
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 | 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_START_BIT_MAP | Insight SmarTune bitmap. |
| 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. |
Expressions
| Oracle | PRES | Expression Description |
|---|---|---|
SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | The sum of all the response time components of the step. |
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of all the response time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | The sum of the client time components of the step. |
| SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of the client time components of the step. |
PW_SPTS_TRAN_STAT_LS_T
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, Locale, Appsvr, or URL. 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_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_LOCALE_KEY | The ID of the locale on which the transaction occurred. |
| SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
| SPTS_URL_KEY | The key of the URL that activated the transaction. |
| 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_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_DESCT_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_SPTS_TRAN_STAT_OLSU_T
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, User, Terminal, Locale, Appserver, Organization, or URL. 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_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_LOCALE_KEY | The ID of the locale on which the transaction occurred. |
| SPTS_USER_KEY | The ID of the user executing the transaction. |
| SPTS_TERMINAL_KEY | The ID of the terminal executing the transaction. |
| SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
| SPTS_ORG_KEY | The ID of the user's organization executing the step. |
| SPTS_URL_KEY | The key of the URL that activated the transaction. |
| 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_SPTS_TRAN_STAT_H_T
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.
| Column Name | Column Description |
|---|---|
| SPLD_LOCALE_KEY | The locale key. |
| SPLD_LOCALE_NAME | The locale name. |
| SPLD_SAPROUTER | SAP router string. |
| SPLD_DESCRIPTION | The locale description. |
| SPLD_USEICMP | Whether you use ICMP to connect to the locale. |
| SPLD_CHANGED_DT | The date when this record was last changed. |
| SPLD_START_DT | The start date of the record. |
| SPLD_END_DT | The end date of the record. |
| SPLD_IS_DELETED | Whether this record is deleted. |
PW_SPID_INSTANCE_DIM
Instance dimension view.
| Column Name | Column Description |
|---|---|
| SPID_ENVIRONMENT_KEY | The instance environment key. |
| SPID_APPTIER_KEY | The instance AppTier key. |
| SPID_PWII_INSTANCE_ID | The instance ID. |
| SPID_INSTANCE_NAME | The instance name. |
| SPID_CREATE_TIME | The time the record was created. |
| SPID_UPDATE_TIME | The time the record was updated. |
| SPID_IS_DELETED | Whether this record is deleted. |
PW_SPUL_USERLOCALE_DIM
User locale dimension.
| Column Name | Column Description |
|---|---|
| SPUL_PWII_INSTANCE_ID | The instance ID. |
| SPUL_USERLOCALE_KEY | The user locale key. |
| SPUL_CLIENT | The client. |
| SPUL_USER_AREA | The user area. |
| SPUL_LOCALE_KEY | The locale key. |
| SPUL_CHANGED_DT | The date when this record was last changed. |
| SPUL_START_DT | The start date of the record. |
| SPUL_END_DT | The end date of the record. |
| SPUL_IS_DELETED | Whether this record is deleted. |
PW_SPUD_USER_DIM
User dimension.
| Column Name | Column Description |
|---|---|
| SPUD_PWII_INSTANCE_ID | The instance ID. |
| SPUD_USER_NAME | The user name. |
| SPUD_CLIENT | The client number. |
| SPUD_USER_TYPE | The user type. |
| SPUD_DEPT | The user's department. |
| SPUD_BLDG | The user's building. |
| SPUD_COST | The user's cost center. |
| SPUD_LOC | The user's location. |
| SPUD_REGION | The user's region. |
| SPUD_ACCT | The user's account. |
| SPUD_CLS | The user's group. |
| SPUD_NAME0 | The user's name 0. |
| SPUD_NAME1 | The user's name 1. |
| SPUD_NAME2 | The user's name 2. |
| SPUD_NAME3 | The user's name 3. |
| SPUD_CHANGED_DT | The date when this record was last changed. |
| SPUD_IS_DELETED | Whether this record is deleted. |
PW_SPSQ_SEQ
Sequel table.
| Column Name | Column Description |
|---|---|
| SPSQ_TABLE_COLUMN | The table column. |
| SPSQ_NEXT_FREE_SEQ | Next free sequel. |
PW_SPID_AI_SIDS
SIDs table.
| Column Name | Column Description |
|---|---|
| SPID_SID_KEY | The SID key. |
| SPID_SYSTEM_NAME | The system name. |
| SPID_SID_NAME | The ID name. |
| SPID_SID_SYSNO | The SID system number. |
| SPID_SAP_IMPHOST | The SAP implement host. |
| SPID_SAP_RELEASE | The SAP release. |
| SPID_SID_USER | The user used to connect to the SID. |
| SPID_SID_PASSTHROUGH_SERVER | Deprecated. Not in use. |
| SPID_DB_STANDALONE | Whether this SID is a standalone DB server. |
| SPID_RFC_DEST | Routing string for RFC connection. |
| SPID_CENTRAL_INSTANCE | Application server key of the central instance. |
| SPID_DB_HOST_NAME | Host name of the DB server. |
| SPID_SID_LAST_IMPORT_DATE | Deprecated. Not in use. |
| SPID_USE_SAPROUTER | Boolean indication whether to use routing string connection. |
| SPID_SID_PASS | The password for the user. |
| SPID_SID_DEFCLIENT | The SID default client. |
| SPID_USER_LOC_FIELD | The user locale field. |
| SPID_USER_ORG_FIELD | The user organization field. |
PW_SPDI_DISABLED_INSTANCES
Disabled instances table.
| Column Name | Column Description |
|---|---|
| SPDI_INSTANCE_ID | The instance ID. |
PW_SPID_AI_SIDS_VIEW
SIDs view.
| Column Name | Column Description |
|---|---|
| SPID_SID_KEY | The SID key. |
| SPID_SYSTEM_NAME | The system name. |
| SPID_SID_NAME | The ID name. |
| SPID_SID_SYSNO | The SID system number. |
| SPID_SAP_IMPHOST | The SAP implement host. |
| SPID_SAP_RELEASE | The SAP release. |
| SPID_SID_USER | The user used to connect to the SID. |
| SPID_SID_PASS | The password for the user. |
| SPID_SID_DEFCLIENT | The SID default client. |
| SPID_SID_DEFAPPSVR | The SID default application server. |
| SPID_USER_LOC_FIELD | The user locale field. |
| SPID_USER_ORG_FIELD | The user organization field. |
| SPID_SID_PASSTHROUGH_SERVER | The SID passthrough server. |
| SPID_DB_STANDALONE | Whether this SID is a standalone DB server. |
| SPID_RFC_DEST | Routing string for RFC connection. |
| SPID_CENTRAL_INSTANCE | Application server key of the central instance. |
| SPID_DB_HOST_NAME | Host name of the DB server. |
| SPID_SID_LAST_IMPORT_DATE | Deprecated. Not in use. |
| SPID_USE_SAPROUTER | Boolean indication whether to use routing string connection. |
| SPID_SERVER | The server. |
| SPID_INTERPOINT_NAME | The Interpoint name. |
PW_SPAS_AI_APPSVRS
Application servers view.
| Column Name | Column Description |
|---|---|
| SPAS_APPSVR_KEY | The application server key. |
| SPAS_SID_KEY | The SID key. |
| SPAS_APPSVR_SID | The application server SID. |
| SPAS_APPSVR_NAME | The application server name. |
| SPAS_APPSVR_SYSNO | The application server sys number. |
| SPAS_APPSVR_SAPROUTER | The application server SAP router. |
| SPAS_INSM_ID | The instance server. |
PW_SPLC_AI_LOCALES
Locales view.
| Column Name | Column Description |
|---|---|
| SPLC_LOC_KEY | The locale key. |
| SPLC_LOC_NAME | The locale name. |
| SPLC_LOC_SAPROUTER | The locale SAP router. |
| SPLC_LOC_DESCRIPTION | The locale description. |
| SPLC_USEICMP | Use ICMP. |
PW_SPCL_AI_CLIENTS
Clients view.
| Column Name | Column Description |
|---|---|
| SPCL_CLIENT_KEY | The client key. |
| SPCL_CLIENT_NAME | The client name, |
| SPCL_CLIENT_COMMENT | The client comment. |
| SPCL_CLIENT_LANG | The client's language. |
| SPCL_CLIENT_DOCOLLECTION | The client do collection. |
| SPCL_SID | The SID. |
| SPCL_SID_KEY | The SID key. |
PW_SPSL_AI_SYSLOC
System locale view.
| Column Name | Column Description |
|---|---|
| SPSL_SYS_KEY | The system key. |
| SPSL_LOC_KEY | The locale key. |
| SPSL_CHANGED_DT | The changed date. |
| SPSL_IS_DELETED | Whether this record is deleted. |
AI_AVAILAGENT_APPSERVER_VIEW
Avail agent application server view.
| Column Name | Column Description |
|---|---|
| SID_KEY | The SID key. |
| APPSVR_KEY | The application server key. |
| APPSVR_NAME | The application server name. |
| APPSVR_SYSNO | The application server system number. |
| APPSVR_SAPROUTER | The application server SAP router. |
| SID_NAME | The SID name. |
| SID_DEFCLIENT | The SID default client. |
| SID_USER | The SID user. |
| SID_PASS | The SID password. |
| SID_RELEASE | The SAP release. |
| CLIENT_LANG | The client’s language. |
PW_SPUN_USER_N
PW normalization table for users.
| Column Name | Column Description |
|---|---|
| SPUN_ID | User ID. |
| SPUN_HASH_VALUE | PW internal hash value. |
| SPUN_STRING_VALUE | User name. |
| SPUN_TIMESTAMP | Creation time. |
PW_SPTN_TRAN_N
PW normalization table for transactions.
| Column Name | Column Description |
|---|---|
| SPTN_ID | The ID of the transaction. |
| SPTN_HASH_VALUE | The PW internal hash value. |
| SPTN_STRING_VALUE | The name of the transaction. |
| SPTN_TIMESTAMP | The time the transaction was created. |
PW_SPPN_PGM_N
PW normalization table for programs.
| Column Name | Column Description |
|---|---|
| SPPN_ID | The ID of the program. |
| SPPN_HASH_VALUE | The PW internal hash value. |
| SPPN_STRING_VALUE | The name of the program. |
| SPPN_TIMESTAMP | The time the program was created. |
PW_SPRN_APPSVR_N
PW normalization table for application servers.
| Column Name | Column Description |
|---|---|
| SPRN_ID | The ID of the application server. |
| SPRN_HASH_VALUE | The PW internal hash value. |
| SPRN_STRING_VALUE | The name of the application server. |
| SPRN_TIMESTAMP | The time the application server was created. |
PW_SPHN_HOST_N
PW normalization table for server hosts.
| Column Name | Column Description |
|---|---|
| SPHN_ID | The ID of the host. |
| SPHN_HASH_VALUE | The PW internal hash value. |
| SPHN_STRING_VALUE | The name of the host. |
| SPHN_TIMESTAMP | The time the host was created. |
PW_SPFN_FUNC_N
PW normalization table for functions.
| Column Name | Column Description |
|---|---|
| SPFN_ID | The ID of the function. |
| SPFN_HASH_VALUE | The PW internal hash value. |
| SPFN_STRING_VALUE | The name of the function. |
| SPFN_TIMESTAMP | The time the function was created. |
PW_SPON_ORG_N
PW normalization table for organizations.
| Column Name | Column Description |
|---|---|
| SPON_ID | The ID of the organization. |
| SPON_HASH_VALUE | The PW internal hash value. |
| SPON_STRING_VALUE | The name of the organization. |
| SPON_TIMESTAMP | The time the organization was created. |
PW_SPIN_IP_N
PW normalization table for IP addresses.
| Column Name | Column Description |
|---|---|
| SPIN_ID | The ID of the IP address. |
| SPIN_HASH_VALUE | The PW internal hash value. |
| SPIN_STRING_VALUE | The name of the IP address. |
| SPIN_TIMESTAMP | The time the IP address was created. |
PW_SPAN_APP_N
PW normalization table for applications.
| Column Name | Column Description |
|---|---|
| SPAN_ID | The ID of the application. |
| SPAN_HASH_VALUE | The PW internal hash value. |
| SPAN_STRING_VALUE | The name of the application. |
| SPAN_TIMESTAMP | The time the application was created. |
PW_SPWD_WORKTYPES_DIM
Dimension table for work types.
| Column Name | Column Description |
|---|---|
| SPWD_WORKTYPE_KEY | The work type key. |
| SPWD_WORKTYPE_NAME | The work type name. |
| SPWD_WORKTYPE_INTERNAL | The internal SAP work type name. |
PW_SPPP_PRODUCT_PARAMS
Internal parameter table.
| Column Name | Column Description |
|---|---|
| SPPP_PARAM_NAME | The name of the parameter. |
| SPPP_PARAM_VALUE | The value of the parameter. |
PW_SPTN_TRAN_N_VIEW
View on PW_SPTN_TRAN_N.
| Column Name | Column Description |
|---|---|
| SPTN_ID_VIEW | The ID of the transaction. |
| SPTN_HASH_VALUE_VIEW | The PW internal hash value. |
| SPTN_STRING_VALUE_VIEW | The name of the transaction. |
| SPTN_TIMESTAMP_VIEW | The time the transaction was created. |
PW_SPCF_AI_CONFIG
Configuration table for all of the collectors.
| Column Name | Column Description |
|---|---|
| SPCF_CONFIG_KEY | Configuration key. |
| SPCF_LOCCFG_LAST_UPD | Local agent last update time. |
| SPCF_AVAILCFG_LAST_UPD | Availability agent last update time. |
| SPCF_WRKLDCFG_LAST_UPD | Workload agent last update time. |
| SPCF_LOCCFG_LAST_PUSH | Locale agent last push time. |
| SPCF_AVAILCFG_LAST_PUSH | Availability agent last push time. |
| SPCF_WRKLDCFG_LAST_PUSH | Workload agent last push time. |
| SPCF_DEF_USER_AREA | User area mapping definition. |
| SPCF_DEF_USER_ORG | User organization mapping definition. |
| SPCF_DEF_LOC | Locale mapping definition. |
| SPCF_DEF_APP | Application mapping definition. |
PW_SPPG_AI_PINGERS
Locale pingers list.
| Column Name | Column Description |
|---|---|
| SPPG_PINGER_KEY | Pinger key. |
| SPPG_LOC_KEY | Locale key. |
| SPPG_PINGER_NAME | Pinger name or IP address. |
AI_CONFIG_VIEW
View on PW_SPCF_AI_CONFIG.
| Column Name | Column Description |
|---|---|
| CONFIG_KEY | Configuration key. |
| LOCCFG_LAST_UPD | Local agent last update time. |
| AVAILCFG_LAST_UPD | Availability agent last update time. |
| WRKLDCFG_LAST_UPD | Workload agent last update time. |
| LOCCFG_LAST_PUSH | Locale agent last push time. |
| AVAILCFG_LAST_PUSH | Availability agent last push time. |
| WRKLDCFG_LAST_PUSH | Workload agent last push time. |
| DEF_USER_AREA | User area mapping definition. |
| DEF_USER_ORG | User organization mapping definition. |
| DEF_LOC | Locale mapping definition. |
| DEF_APP | Application mapping definition. |
AI_LOCAGENTLOC_VIEW_1
View on PW_SPLC_AI_LOCALES.
| Column Name | Column Description |
|---|---|
| LOC_KEY | Locale key. |
| LOC_NAME | Locale name. |
| USEICMP | Whether the locale is using ICMP. |
AI_LOCAGENT_PINGER_VIEW
View that joins PW_SPPG_AI_PINGERS and AI_LOCAGENTLOC_VIEW_1.
| Column Name | Column Description |
|---|---|
| LOC_KEY | Locale key. |
| LOC_NAME | Locale name. |
| USEICMP | Whether the locale is using ICMP. |
| DEVICENAME | Pinger name. |
AI_WRKLDAGENT_APPSERVER_VIEW
| Column Name | Column Description |
|---|---|
| SID_KEY | SID key. |
| APPSVR_KEY | Application server key. |
| APPSVR_NAME | Application server name. |
| APPSVR_SYSNO | Application server system number. |
| APPSVR_SAPROUTER | Application server SAP router. |
| INSM_ID | INSM_ID in server table. |
| SID_DEFAPPSVR | Default application server key of SID. |
| SID_DEFAPPSVR_NAME | Default application server name of SID. |
| SID_DEFCLIENT | SID default client. |
| SID_USER | SID user. |
| SID_PASS | SID password encrypted. |
| SID_PASSTHRU_APPSVR | Deprecated. Not in use. |
| SID_STANDALONE | Whether the database is on a stand one server. |
| SID_HOST | Database host name. |
| RFC_DEST | RFC destination. |
| CLIENT_LANG | Client language. |
| SYS_SID | SID name. |
PW_SPII_INTERPOINT_INSTALLED
View to get data on SAP Interpoint installations.
| Column Name | Column Description |
|---|---|
| SPII_ORACLE_INSTANCE_NAME | Instance name of the database product. |
| SPII_INTERPOINT_INSTALLED | Number representing the database type. |
| SPII_INAP_ID | Apptier ID. |
| SPII_INCE_ID | Instance key of the database product. |
PW_SPAR_SLA_RULES
View for the SLA of Precise for SAP.
| Column Name | Column Description |
|---|---|
| SPAR_ID | Rule ID. |
| SPAR_INAD_ID | Rule in alert. |
| SPAR_RULE_TYPE | Rule type. |
| SPAR_RULE | Rule definition. |
| SPAR_RFC_IND | RFC indication. |
| SPAR_CREATE_TIME | Rule creation time. |
| SPAR_UPDATE_TIME | Rule update time. |
| SPAR_DELETED | Whether the rule is deleted. |
PW_SPOL_ORGLOCALE_STAT_D
Statistics table for locale organizations mapping. Also has M summary level.
| Column Name | Column Description |
|---|---|
| SPOL_PWII_INSTANCE_ID | Instance ID. |
| SPOL_TIMESTAMP | Timestamp the mapping was created. |
| SPOL_PWHG_ID | PW hour group. |
| SPOL_RECEIVED_TIMESTAMP | Time received. |
| SPOL_MINUTES_COUNT_SUM | Minutes count. |
| SPOL_LOCALE_KEY | Locale key. |
| SPOL_ORG_KEY | Organization key. |