2008 Nov 03 3:28 PM
Hi Experts,
I have some 20 org units and each one has 1 manager and 15 employees. Now i want to find the Terminated employees. If I check with each PERNR means it takes lot of time. So Is there any way to find the terminated employees?
In other words, Based on Manager PERNR is it possible to find How many employees are terminated By this Manager?
Expecting your valuable reply,
Your helps wil be Highly Appreciated.
2008 Nov 03 9:48 PM
If you want a report that will display terminated employees, then I think best bet would be to use PNP and read status of the employee = terminated/withdrawn.
If you want to make it faster then do a select statement on PA0000 into an internal table and then loop through that table.
If you want a report where you can give manager's pernr and find out how many (or a list of) employees terminated by this manager then you can use PCH LDB. Or again select statements on HRP1000 and HRP1001.
2008 Nov 03 3:38 PM
Hi Nandini,
If you are creating a standard SAP report for this, and are using the PNP logical database, all you need to do is select the org unit you want to look at, and then select the employment status or customer-specific status to the value you want to return (ie. 3=Active). You enter a date range for the report, and all valid employees get returned back to you.
Let me know if you have any further questions.
SL
2008 Nov 03 3:40 PM
Hi nandu,
Check the table PA0546 where you will get all the termination details.
Cheers!!
VEnk@
2008 Nov 03 3:48 PM
Hi,
Thanks for the quick replies. I checked with table PA0546. But I wonder there is no data on that table. I have lot of terminated employees. But the table didnt shows single employee.
Anyway thanks.
2008 Nov 03 3:50 PM
Hi Nandu,
Howcome there is no entries in the table.
And how you know that lot of employees are terminated.
Check how the hr records will be updated, and based on that you find out whether the data is present or not.
if possible revert back the scenario of how the records will be updated i will help you.
Cheers!!
VEnk@
2008 Nov 03 3:51 PM
Hi Nandini,
We don't use PA0546 either. I guess it depends on your workflow in your HR process.
Are you trying to create a report?
SL
2008 Nov 03 9:48 PM
If you want a report that will display terminated employees, then I think best bet would be to use PNP and read status of the employee = terminated/withdrawn.
If you want to make it faster then do a select statement on PA0000 into an internal table and then loop through that table.
If you want a report where you can give manager's pernr and find out how many (or a list of) employees terminated by this manager then you can use PCH LDB. Or again select statements on HRP1000 and HRP1001.
2008 Nov 03 11:53 PM
2010 Mar 08 11:36 AM
Hi Nandini,
Can you share for us what the solution you did?
Because I have the same problem like you.
Thanks in advance.