function module to get managers under head of the department manager

Hello Experts,

I need some help in the below scenario.

1. I want to get the list of people under a particular manager in HR, i have done this using the HRP1001 table.

Now my problem is :----

2. For the above said manager in point 1 he may be reporting to some other manager or HOD which might belong to same or other department.

so i want to get all the managers under a paricular Head of the department in higher level hierarchy.

Please suggest some function module.

thanks