With over 25 years in SAP Human Capital Management, Danielle is a recognized leader in HR technology. She holds the distinguished roles of SAP Mentor and SuccessFactors Confidant, and serves as HXM Chairperson for ASUG (America's SAP User Group). Danielle is a sought-after speaker at international conferences, sharing insights on HR tech trends. She has authored four best-selling books on SAP and holds certifications in both SAP and SuccessFactors technologies. Danielle is Global Vice President Strategic Alliances at EPI-USE Labs, where she continues to drive innovation in HR solutions.
Start Date | End Date | Name | Position Title | Cost Center |
1/1/1998 | 12/31/1999 | Walter White | Adm.Staf -US | 4235 |
Start Date | End Date | Name | Position Title |
Cost Center |
1/1/1992 | 7/4/1995 | Walter White | Mailroom Clerk | 1054 |
7/5/1995 | 6/28/1996 | Walter White | Front Desk Attendant | 5248 |
6/29/1996 | 12/31/1997 | Walter White | Front Desk Attendant | 5248 |
1/1/1998 | 12/31/1999 | Walter White | Adm.Staf -US | 4235 |
The user would then have the challenge of manually identifying which is the previous record, to manually identify the row with the previous position title, and try to record it appropriately. In the example above, it is easy to see that the previous position title was as a Front Desk Attendant. However, the resolution of getting that previous position title on the same as the original would be a manual effort. A manual update to every employee in a report is not a reasonable exercise.
To further complicate matters, the change in position may not always be on the immediately previous record, so you cannot even use an Excel macro to automate the process.
This is simply another shortcoming of using a tool like the Ad Hoc or SAP Query for HCM reporting. Other examples can be seen here and here. Unless you are one of the many thousands of customers leveraging a third party solution for your reporting, like Query Manager™, you would have to resort to more complicated methods.
To get single line reporting that includes information from both current and previous Infotype records you will need to use a custom ABAP report, leveraging the skills of an ABAP programmer who can modify the InfoSet that you use for Query reporting.
See below for a sample of ABAP code that was added to an SAP Query InfoSet, allowing two fields to be added to the SAP Query for the former position title and previous salary for salaried employees. This sample ABAP code is included here for reference and is based on configuration of a sample system which includes references to values for Action Codes (i.e. 01) and Employees Sub Group types (i.e. S1, S2, S3 and S4) which would need to be replaced by your organizations codes. The code is not all-inclusive, but it should you give you an idea of how that data is retrieved for previous and current data for both the position title and the annual salary, such that you can leverage it back at your organization, resulting in a report that looks like this sample below.
Period Selection = Today
Start Date | End Date | Name | Position Title | Previous Position Title |
1/1/1998 | 12/31/9999 | Walter White | Adm.Staf -US | Front Desk Attendant |
© 2024 EPI-USE Labs
Trafford House, 11th Floor, Chester Road, Stretford, Manchester, United Kingdom, M32 0RS •Other Office Locations
Leave a Comment: