HCM Data
DataSource Transactional Data 0EHSM_HSS_INC_REC_10
Use
You can use this DataSource to extract working times and full-time equivalents (FTE) of organizational units from SAP EHS Management into SAP NetWeaver Business Warehouse (SAP NetWeaver BW). The DataSource extracts the data from Human Capital Management (HCM), specifically from the Personnel Time Management (PT) system.
You can process the extracted data by using the DataStore object 0EHH_DS10 shipped with this release.
SAP EHS Management uses the BAPI BAPI_PTIMEOVERVIEW_GET to read the following information from the PT system:
-
Regular working hours
-
Attendance hours
-
Overtime hours
-
Absence hours
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 | No |
Prerequisites
You have configured your PT system and record time data there.
To use the data from PT, ensure that you have made the following settings in the source system:
-
You have read the information in Customizing SAP EHS Management under
Incident Management 
Integration Human Resources Integration Check Customizing for Personnel Time Management
. -
You have performed the Customizing activity for SAP EHS Management under
Incident Management Integration Human Resources Integration Activate Personnel Time Management Integration.
Data Modeling
Delta Update
The delta update used for this DataSource is AIE (After-Images by Extractor). The delta is determined in the Customizing of the source system. In the Customizing activity Activate Personnel Time Management Integration the field Month in Past specifies the number of months in the past for which data is to be extracted.
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 |
|---|---|---|---|
| ORGUNIT | Organizational Unit ID | - | - |
| CALDATE | Date | - | - |
| WRKTIME | Worktime in Hours | - | - |
| NUMFTE | Number of Full-Time Equivalent Workers | - | - |
Extractor Logic
The DataSource is implemented by a function module (extraction method F1).
The extractor extracts the working time for each day for each organizational unit. This working time is summarized per month, so that the working time per month is loaded into SAP NetWeaver BW.
The extractor extracts the FTEs. FTEs are calculated per month and per organizational unit. The system calculates the FTE in the following manner:
-
Divide the working hours in a given month by the total number of days in that month.
-
Multiply the result by the total days in the year.
-
Divide this number by the hours worked by a full-time employee in one year.
The extractor uses two BAdIs that can be used to modify the extractor’s behavior.
It is not possible to determine if and when records in HCM have changed. For this reason, the extractor for HCM data cannot do a delta extraction. To prevent each extraction from reading all HCM data, the extractor only reads the data from the past x months. The number of months can be configured in the IMG at SAP EHS Management -> Incident Management -> Integration -> Human Resources Integration -> Activate Personnel Time Management Integration (in table EHHSSC_PT_INT). The assumption is that after x months, all working hours will have been maintained in HCM, meaning that these values will not change any more.
HCM data is extracted on a monthly basis because this fulfills the requirements and significantly improves performance compared with extraction on a daily basis.
By default, the data is extracted from HCM. If HCM is not the source of this data, deactivate the BAdI implementation in IMG activity SAP EHS Management Incident Management Integration Human Resources Integration Implementation: Determination of FTE and Working Time from PT. See also the documentation about this IMG activity and the IMG activity SAP EHS Management Incident Management Integration BAdI: Determination of FTE and Working Time.
Unsychronized Backup Recovery in BI System
The DataSource does not have its own time stamp management. If you are applying unsynchronized BW backup recovery, the delta procedure for the DataSource has to be reinitialized.