How to Report on Data from R/3 and an External Source

  • by Danielle Larocca, Senior Vice President, Human Capital Management, EPI-USE Labs
  • May 15, 2003
Combining data from R/3 with data from another system is easy as long as both sources of the data contain a similar unique element. The author shows how using the example of a company that wants to combine employee data from R/3 with average clock-in and clock-out times from an external card key system.

As an HRIS director, I am often asked to combine data from R/3 with data from another system into a single report. Some examples include:

  • Requests to produce a report containing data from R/3, such as pay grades and salaries, to compare it to an external pay grade survey to see how our company’s ranges match up to a standard
  • Requests to produce a report containing data from R/3 such as employee schedules and hours worked to compare it to an external legacy system that measures productivity per department

Danielle Larocca

Danielle Larocca is currently the Senior Vice President of Human Capital Management for EPI-USE Labs. Previously she was the Executive Vice President of Operations/Chief Knowledge Officer at a technology start-up. She has more than 20 years of strategic leadership experience in multi-national business, business process re-engineering, and project and people management. Danielle is an expert on SAP Human Resources (HR) and reporting and has authored four best-selling books on SAP. She is a regular speaker at numerous conferences around the world on topics such as HR, technology, change management, and leadership. She is an official SAP Mentor, a global designation assigned to less than 160 professionals worldwide, who serve as influential community participants in the SAP ecosystem. This group is nominated by the community and selected by the SAP Mentors’ Advisory Board to keep SAP relevant. Danielle also serves as an expert advisor for SAP Professional Journal.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.