OELs and Amounts
DataSource Transactional Data 0EHSM_HSS_RAS_02
Use
You can use this DataSource to extract amounts that have been compared to their respective limit value as part of a risk analysis from the conducted risk assessments from SAP EHS Management into SAP NetWeaver Business Warehouse (SAP NetWeaver BW). The DataSource extracts the data from the following nodes of the following business objects:
-
Business object EHHSS_RISK
-
ROOT
-
REVISION
-
ANALYSIS
-
OEL_VALUES
-
-
Business object EHFND_DATA_AMOUNT
-
ROOT
-
-
Business object EHHSS_AGENT/EHFND_CHEMICAL
-
ROOT (only the ID field)
-
LIMIT
-
-
Business object EHHSS_RISK_ASSESSMENT
-
ROOT (only the fields KEY and ID)
-
-
Business object EHFND_LOCATION
-
ROOT (only the ID field)
-
-
Business object EHHSS_JOB
-
ROOT (only the ID field)
-
The DataSource extracts data only for those risks for which an exposure analysis has been performed.
Technical Data
| Application Component | SAP EHS Management (EHS-MGM-RAS) |
|---|---|
| Exchange Available as of Release | Component Extension 2.0 for SAP EHS Management |
| Shipment | SAP NetWeaver 7.0 BI Content Add-On 7 SP 02 |
| Content Versions | EHM200, EHM300 |
| RemoteCube-Capable | No |
| Delta-Capable | Yes |
| Extraction from Archives | No |
| Verifiable | No |
Prerequisites
-
You have configured the DataSource in Customizing in the source system under .
-
The BAdI implementation BADI_EHFND_FW_BI_BOPF_OBJ_LIST must be an active default implementation of the BAdI BADI_EHFND_FW_BI_OBJ_LIST. For more information, see Customizing in the source system under .
-
The BAdI implementation BADI_EHFND_FW_BI_BOPF_EXTRACT must be an active default implementation of the BAdI BADI_EHFND_FW_BI_EXTRACTOR. For more information, see Customizing in the source system under .
Data Modeling
Delta Update
The delta update used for this DataSource is AIED (After-Images with Deletion Indicator by Extractor). The deciding field for the update is BW_DELTATIMESTMP.
Fields of Origin for the Extraction Structure
| Fields in the Extraction Structure | Description of the Field in the Extraction Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
| ID | Risk ID | - | - |
| RISK_ROOT_KEY_REF | Risk Key | - | - |
| HAZARD | Hazard | - | - |
| HAZ_CAT | Hazard Category | - | - |
| OPERATION_STATUS | Operational Status | - | - |
| RAS_TYPE | Risk Assessment Type | - | - |
| AGENT_ID | Agent ID | - | - |
| AGENT_KEY_REF | Agent Key | - | - |
| JOB_ID | Job ID | - | - |
| SPLIT_DATE | Revision Date | - | - |
| STATUS | Risk Status | - | - |
| OEL_KEY_REF | Analysis Key | - | - |
| TYPE | Risk Type | - | - |
| ACT_VALUE_MEAS | Action Value for Exposure Analysis | - | - |
| EXP_RESULT | Result of Exposure Analysis | - | - |
| LIMIT_VALUE | OEL Value | - | - |
| LIMIT_UNIT | OEL Unit | - | - |
| AMOUNT_CAT | Amount Category | - | - |
| AMN_VALUE | Amount Value | - | - |
| AMN_UNIT | Amount Unit | - | - |
| RATING | Exposure Rating | - | - |
| LOCATION_ID | Location ID | - | - |
| RAS_ID | Risk Assessment ID | - | - |
| REGULATION | Regulation/Regulatory List for OEL | - | - |
| SAMPLING_DATE | Sampling Date | - | - |
| VALUE_TYPE | Amount Value Type | - | - |
| SAMPLING_DUR | Duration of Sampling Period | - | - |
| OEL_AGNT_KEY_REF | Agent With Limits or Amounts | - | - |
| BW_RECORDNUMBER | Serial number of record since one risk can have multiple records | Generated (by extractor) | - |
| BW_RECORDMODE | Record mode that allows flagging records for deletion in BW | Generated (by extractor) | - |
| BW_DELTATIMESTAMP | Time stamp for delta load | Input for extractor | - |
Extractor Logic
The extractor extracts only the most recent revision of a risk. The actual extractor logic is implemented as a BOPF determination of the transient node BI_LIMITS of the business object EHHSS_RISK. The business object EHHSS_RISK saves references to the following business objects:
-
EHHSS_RISK_ASSESSMENT
-
EHFND_LOCATION
-
EHHSS_AGENT
-
EHFND_CHEMICAL
-
EHHSS_JOB
These references consist of internal keys (GUIDs). Except for agents, the extractor does not extract these internal keys. Instead, the extractor translates these keys into the ID of the corresponding business object instance. Because the agent IDs are not necessarily unique (depending on how the number range objects are maintained in Customizing), the extractor also extracts internal keys for agents.
The hazard category is not saved in the business object EHHSS_RISK directly. The extractor determines the hazard category from the customizing table EHHSSC_HAZARD.
The key figures are extracted 1:1 without any transformations or calculations.
The sampling duration for the field SAMPLING_DUR is derived from the start date/time and the end date/time from the amount record. When no end date/time has been maintained, this field remains empty. The extractor creates a language-independent description of the duration where language-dependent texts are represented by placeholders. For example, the duration 1 Hour is extracted as 1 #hh# where #hh# is the placeholder for Hour. The system inserts the language-dependent texts during the query runtime in BW depending on the current user’s logon language.
To create the values for the RATING field, the extractor concatenates the hazard from the root record with the rating from the OEL record separated by a period (dot). This allows entering rating texts depending on the hazard. For non-chemical hazards, the extractor also appends a number to the rating code that corresponds to one of the texts entered in the source system in the Customizing activity for SAP EHS Management under .
The field OEL_AGNT_KEY_REFcontains the agent for which the OEL or amount exists. This is not necessarily the agent for which the risk is defined. The risk could be defined for a chemical mixture, whereas the limit values are defined for the mixture’s ingredients.
Verification of Key Figures
In the exposure analysis, the system compares the amount (AMN_VALUE) that was collected for an agent to the selected occupational exposure limit (OEL) (LIMIT_VALUE) of the agent to produce the exposure result (EXP_RESULT). For non-chemicals, the system subtracts the value of the OEL from the value of the amount. For chemicals, the system divides the value of the amount by the value of the OEL, and multiplies the result by 100 to express the result as a percentage. To verify these key figures, check the exposure analysis in the application for the inherent risk, initial risk, and residual risk of the most recent revision of the respective risk.
Unsychronized Backup Recovery in BI System
The DataSource does not use an own time stamp management. The DataSource uses the generic delta functionality.

