Assets
DataSource Transactional Data 0EHSM_HSS_INC_REC_03
Use
You can use this DataSource to extract asset data of incidents from SAP EHS Management into SAP NetWeaver Business Warehouse (SAP NetWeaver BW). The DataSource extracts the data from the following nodes of the incident business object EHHSS_INCIDENT:
-
ROOT (only the ID of the incident)
-
ASSET_INVOLVED
-
EQUIPMENT
-
VEHICLE
-
ASSET_PROPERTY
-
TRANSACTION
You can process the extracted data by using the DataStore object 0EHH_DS03 shipped with this release.
Technical Data
| Application Component | SAP EHS Management (EHS-MGM-INC) |
|---|---|
| Exchange Available as of Release | Component Extension 1.0 for SAP EHS Management |
| Shipment | SAP NetWeaver 7.0 BI Content Add-On 5 SP 02 |
| Content Versions | EHSM10 |
| RemoteCube-Capable | No |
| Delta-Capable | Yes |
| Extraction from Archives | No |
| Verifiable | Yes |
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 |
|---|---|---|---|
| SERIAL | Serial Number | - | - |
| INCIDNT | Incident ID | EHHSSD_INC_ROOT | ID |
| ASGUID | NodeID | EHHSSD_INC_ASINV | DB_KEY |
| ASSETTY | Involved Asset Type | EHHSSD_INC_ASINV | TYPE |
| BEL2ORG | Company-Owned Asset | EHHSSD_INC_ASINV | BELONG_TO_ORG_TS |
| ASSET_DESC | Asset Description | EHHSSD_INC_EQU or EHHSSD_INC_VEHIC or EHHSSD_INC_PROP | EQU_DESC or VEHICLE_DESC or PROPERTY_DESC |
| EQUIPTY | Equipment Type | EHHSSD_INC_EQU | TYPE |
| EQUIPID | Equipment ID | EHHSSD_INC_EQU | ID |
| EQPLANT | Plant ID | EHHSSD_INC_EQU | PLANT_ID |
| FUNCLOC | Functional Location ID | EHHSSD_INC_EQU | FUNC_LOC_ID |
| EQOPERA | Equipment Still Operational | EHHSSD_INC_EQU | OPERATIONAL_TS |
| VEHICID | Vehicle ID | EHHSSD_INC_VEHIC | ID |
| VEHICTY | Vehicle Type | EHHSSD_INC_VEHIC | PLANT_ID |
| VHPLANT | Plant ID | EHHSSD_INC_VEHIC | FUNC_LOC_ID |
| VHOPERA | Vehicle Still Operational | EHHSSD_INC_VEHIC | OPERATIONAL_TS |
| PROPID | Property | EHHSSD_INC_PROP | ID |
| PROPTY | Property Type | EHHSSD_INC_PROP | PLANT_ID |
| PRPLANT | Plant ID | EHHSSD_INC_PROP | FUNC_LOC_ID |
| PRUSBL | Property Still Usable | EHHSSD_INC_PROP | OPERATIONAL_TS |
| FIN_TRANS_AMNT | Transaction Amount in Local Currency | EHHSSD_INC_FTRAN | FIN_TRANS_AMNT |
| TRANS_CURR_CODE | Local Currency for Financial Transaction | EHHSSD_INC_FTRAN | TRANS_CURR |
| FIN_TR_ORG_AMNT | Transaction Amount in Company Currency | Calculated by extractor (see Extractor Logic below) | - |
| ORG_CURR_CODE | Company Currency | EHFNDC_CONFIG | DEFAULT_CUR_CODE |
| BW_DELTATIMESTMP | BW Delta Time Stamp | - | - |
| BW_RECORDMODE | BW Delta Process: Record Mode | - | - |
Extractor Logic
The DataSource is implemented by a function module (extraction method F1). The extractor transfers most of the data 1:1. If there are several financial transactions for one asset, the extractor summarizes the amounts of the transactions to one key figure per asset.
There are additional fields in the financial transactions node that reference the asset that is related to the respective costs. The key figures for the asset’s costs are determined from the financial transaction node evaluating the asset reference in the following way:
The fields in the financial transaction node that reference the asset are TYPE_REF and KEY_REF. TYPE_REF can have one of 4 values that define how to interpret the value in KEY_REF:
-
REF_TYPE = 001 (Asset) -> KEY_REF points to an instance in ASSET_INVOLVED
-
REF_TYPE = 002 (Release) -> KEY_REF points to an instance in RELEASE_EXCEPT
-
REF_TYPE = 003 (Person) -> KEY_REF points to an instance in PERSON_INVOLVED
-
REF_TYPE = 004 (Violation Notice) -> KEY_REF points to an instance in VIOLATION_NOTICE
The assets extractor only determines the costs of assets. If there are multiple financial transactions for the same asset, the extractor adds the amounts of those financial transactions.
The extractor reads the amounts in company currency from the transient fields of the node TRANSACTION. The determination for these fields calculates the amount in company currency from the amount in local currency with the exchange rate type M (Standard translation at average rate).
Unsychronized Backup Recovery in BI System
The DataSource does not have its own timestamp management. If you are applying unsynchronized BW backup recovery, the delta procedure for the DataSource has to be reinitialized.