Reporting past and current employee data on a single line

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