Skip to Content

Previous Employment report through Ad-hoc Query_SAPHCM

Hi Folks,


I have a requirement wherein i need to fetch a previous/other employer data for my employees who worked in past with other employers. I am trying to generate this data through Ad-hoc Query for all employee about their previous employment but system shows following results.

1. If I try to run query with specific period, it shows dates 00.00.0000 with no employment history. nevertheless, the data is avaible in the table.

2. If i look to run the query with period selection-All, it populates random results of employment stints.i.e. some data item displays in the result, while the other do not.

I failed to understand as to how i should run the query to full and correct data from the IT0023 (Prev./Other Employment) for the employee whom i desire to.

Kindly suggest your inputs to fix reporting issue.

Best regards

Santosh Chauhan

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.