Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP HR - Org Unit

Former Member
0 Kudos
145

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.

1 ACCEPTED SOLUTION

Shafiq_Rehman
Active Contributor
0 Kudos
105

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.

8 REPLIES 8

Former Member
0 Kudos
105

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

Former Member
0 Kudos
105

Hi nandu,

Check the table PA0546 where you will get all the termination details.

Cheers!!

VEnk@

0 Kudos
105

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.

0 Kudos
105

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@

0 Kudos
105

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

Shafiq_Rehman
Active Contributor
0 Kudos
106

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.

0 Kudos
105

Thanks all. Im not creating a report. Anyway problem solved.

0 Kudos
105

Hi Nandini,

Can you share for us what the solution you did?

Because I have the same problem like you.

Thanks in advance.