Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

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.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools