Page History
...
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. |