Let's Talk HCM

Shared by our experts

Fixing duplicate line reporting in SAP HCM

Aug 13, 2017 12:04:34 PM

Reporting in SAP HCM is never easy

There are multiple tools to choose from, including the Ad Hoc Query and the SAP Query, both accessible via transaction code SQ01. These tools have limited functionality; however they do, in most cases, allow you to report on basic infotype data for employees.

One frustrating result output that you will find with these tools is that sometimes you will see report output that has multiple lines per employee instead of a single line output per employee. There are a couple of different scenarios in which this may occur:


How to better design your HR actions to improve HCM Reporting

Jul 31, 2017 7:10:00 PM

Designing your Employee actions

This blog talks about configuring actions properly in order to improve data and reporting.  The configuration of personnel actions such as hiring, terminations, and organizational assignments in SAP ERP HCM is completely customizable. The SAP-delivered actions can be customized to your company's needs so you can collect necessary data and assign specific employment statuses. The employee data collected during your actions then can be classified with reason codes that will provide you with better employee groupings for reporting. Before you configure new actions, here are three questions to ask:

What data do I need to collect?

  1. What statuses do I want to assign?
  2. What reporting goals do I have related to these actions?

I'll explain why these questions are so important. Then I'll show you how to create your own HR actions.


How to Create an Action in SAP

Jul 21, 2017 7:22:00 AM

Configuration of Personnel Actions and events

In part one of this blog, I discussed personnel actions in SAP HCM and talked about their purpose and how to maximize their impact on your data and reporting. In this second part of the series, I share some step-by-step tips for configuring actions and reasons in your system.


A Quick Fix to Employee Status that can improve your HCM Reporting

Jul 10, 2017 11:45:00 AM

Standard Employee Classifications

Over the years, I have visited hundreds of SAP HCM customers and have seen nearly as many different configurations of personnel and employee structures. I pay close attention to these structures because they play a crucial role in SAP HCM and Payroll reporting. If you have created HCM reports or queries in SAP, you understand how the employee and personnel structure configuration can impact report selection criteria (as shown below), and ultimately your ability to produce the reports that you need.


Five things you need to know about reporting in SAP SuccessFactors

Jul 4, 2017 1:03:00 PM

It's an exciting time in SAP SuccessFactors reporting

After years of seeing very few changes in SAP HCM reporting, suddenly there is cutting edge development on the SAP SuccessFactors reporting and analytics front that is changing the way we think about HCM reporting. To help make sense of all of this, here are the top five things you need to know about the future of reporting in SAP SuccessFactors.