User Activity Insight specific Objects

Objects are displayed on the IRC user interface while building rule conditions. The data required by these objects comes from the respective schemas. A schema is an xml representation of an object. Each object corresponds to a schema relating to single or multiple ERP entities.

The general structure of a business process schema in IRC can be described as object attribute.

  • Objects represent a business object such as a User Activity Insight Transaction Code.
  • Attributes represent fields within the object or other objects related to the object.

This schema gives IRC the flexibility to analyze different combinations of objects, associated objects and data. IRC presents these objects in business language and therefore, reduces or eliminates the need to understand the ERP system’s naming conventions.

In addition to the list of objects listed in the section List of Objects common to all Insights , this section lists the tables (objects) of User Activity Insight for SAP that are extracted, the attributes associated with each object and the table in which the object is stored.

Name Attributes extracted Stored in
TransactionHistory (STAT) MANDTTCODE, TTYPE, USERNAME, UDATE, UTIME, TRANSACTIONID, PROGRAM Approva_TEH_SAP_ TransactionHistory
MONITransaction History (MONI) USERNAME, T Code, TRANSACTIONTYPE, BACKGROUNDJOB, Bucket Date, Bucket Type Approva_TEH_SAP_ MONITransactionHistory
TransactionCode

TCODETTEXT

Note: The MONI table also stores information about report execution. Hence, to allow users to create rules on report executions too, report names are picked up from the MONI table.

ApprovaTEHSAPMONI Transaction History table.

(The TTEXT in this case is as same as TCODE)

Approva_TEH_SAP_ TransactionCode
User

USER

Note: Picked up from the Approva_TEH_SAP_MONI Transaction History table.
Approva_TEH_SAP_ User
Configuration Settings

MOVE_STAT_TO_MONI, DAYS_TO_KEEP_ DATA_IN_STAT

Note:  This is picked up from the uaiconfig.xml file.
Approva_TEH_SAP_ ConfigurationSetting
AccessManager Component

CDHDR, CDPOS

Note: This object is available for extraction irrespective of the Access Manager Insight installation. It supports the append mode extraction like all other User Activity Insight object.
Approva_TEH_SAP_ AccessManagerComponent

The following tables can be selected for extraction if HR activity data is required:

Name Attributes extracted Stored in
HRInfyHeader RECNUM, USERNAME, TCODE, DATE_H, TIME_H, OTEXT, PERNR, INFOTYPE, P_ENAME

Approva_TEH_SAP_HRHeader

Approva_TEH_SAP_HRInfyHeader

HRInfyLine RECNUM, FNAME, OLDDT, NEWDT, IS_CHANGED

Approva_TEH_SAP_HRInfyLine

Approva_TEH_SAP_HRLine