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 |