Ask The HR Expert: ABAP Custom Report Shows Employee's Current and Past Positions

  • by Clay Molinari, SAP HR Consultant, C&C Savant, Inc.
  • March 15, 2004
One of HR Expert's readers thinks that it would be useful to have a report showing an employee's current and past positions, including salary and effective dates. Our HR expert agrees that there is a widespread need for such a report. In three steps, he explains how to create a concise, custom ABAP report that provides this information.
Key Concept

Dear HR Expert,

Is there a standard report in SAP that shows an employee’s current and past positions along with their salary and effective dates? Managers at our company use position and salary history to process pay increases, performance awards, and annual salary reviews for each of their direct reports. The ideal solution would be a single-page report with basic employee data at the top and a table in reverse chronological order showing job title, pay grade, change reason, FT/PT indicator, base pay, annualized pay, and effective date. If a standard report is not available, can SAP Query be used to produce this report?

Thanks,
Gerry Smith, Assistant VP - Human Resources

Dear HR Expert,
Is there a standard report in SAP that shows an employee’s current and past positions along with their salary and effective dates? Managers at our company use position and salary history to process pay increases, performance awards, and annual salary reviews for each of their direct reports. The ideal solution would be a single-page report with basic employee data at the top and a table in reverse chronological order showing job title, pay grade, change reason, FT/PT indicator, base pay, annualized pay, and effective date. If a standard report is not available, can SAP Query be used to produce this report?

Thanks,
Gerry Smith, Assistant VP - Human Resources

Thanks for the question. While your specific requirement may be unique, it is not at all uncommon for R/3 users to desire information in a format that is not available in the standard system. The SAP Query or ABAP Query tools could be used to capture the basic information required for your report, but the resulting format would not be very pleasing to the eye. Most companies satisfy this type of requirement with a custom ABAP report program.

Some risks are involved when you develop a custom ABAP program, and it increases your total cost of ownership. Initially, you have the cost of developing and testing the program. In the future, there will be incremental costs each time you install a service package stack or an upgrade. Add to this the fear that the custom program could cause production downtime and you might be inclined to insist that your users make do with standard reports.

Clay Molinari

Clay Molinari has 20 years of experience in the IT industry and has been working as an SAP HR consultant since 1997. He is currently president of C&C Savant, Inc., an SAP consulting firm that specializes in combining standard SAP configuration and custom ABAP programming to help its clients solve unique or complicated requirements.

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.