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.