Need to find employees reporting to a manager

[Former Member]

Hi All,

I am new to HR module.

Basically, i need to develop a report which would list out all the employees reporting to a given manager ID. I am trying to understanding how this org unit, positions and users are tied to each other and what set of tables or function modules are involved in knowing all the employees reporting to a manager.

If my question is unclear, please let me know.

Thanks,

SKJ

[Former Member · Accepted solution]

Hi SKJ,

You can go to T Code: PPOME and also find the position and holde for a particular Org Unit. U can aslo see the reporting through Simple Maintenence, General Structure.

You can easily find the Position, Holder and the User ID of that particular Org Unit through Structural Authorization. U can assign Structural Authorization to a particular Org unit. Through Managers Desktop you can easily find the person reporting, the Org units reporting. Structural Authorization will serve your purpose.

Award points if found useful

Regards,

Madhu Sudhanan

Edited by: Madhu Sudhanan on Dec 3, 2008 9:08 AM

[Former Member]

Hi SKJ

In tran code PPOM_OLD select the org unit you want to and click on reporting structure and execute to see all the employees and their reporting tree.

Award Points if found Usefull

Ravee

[Former Member]

Hi,

You can check the Organization Tree Structure on the PPOME TCode.

To evaluate this Tree Structure Programatically, You have a lot of Function Modules.

Here in this case, you want to evaluate the tree downwards and get the employees reporting to a manager.

Use the FM :

CALL FUNCTION 'RH_STRUC_GET'

EXPORTING

act_otype = 'S'

act_objid = l_super_pos

act_wegid = 'O-S-P'

act_tdepth = l_depth

TABLES

result_tab = lt_reslist[]

result_objec = lt_objlist[]

result_struc = lt_strlist[]

EXCEPTIONS

no_plvar_found = 1

no_entry_found = 2

OTHERS = 3.

Regards,

Surya

[Former Member]

Hi,

Table hrp1001 can help you in this.......

or otherwise use function module

HR_HCP_GET_POSITION_FOR_EMPL here pass object like plvar as 01 and object type as P and the pernr of the manager it will give you the position of the manager.

now you could write a select query on hrp1001 and identify the list of positions related to the position of the Manager through relat = 008 and rsign = B

HR_HCP_GET_EMPL_FOR_POSITION here pass all the positions as plvar 01 object type S and the objid of the positions you will get the pernr

Regards,

Divya

[Former Member]

Hi Divya,

Thanks, your response helped me in what i wanted. As you said, It looks like, we can only use HRP1001 to achieve this instead of FMs. However, can you pls clarify below:

1. I had to pass 002 (Reports (line) to ) Instead of 008 to RELAT to get all those positions reporting to manager position fould in step1. Is this correct?

2. Does your steps work in any system? I mean, no matter how the data is set up in HRP1001?

3. Can you also let me know how to start deriving this at company code level? I also have company code termed as Line of Business on my selection. User may enter only company code and i will have to extract everything.

Thanks,

SKJ

[Former Member]

SKJ,

Hope this helps.

1. I had to pass 002 (Reports (line) to ) Instead of 008 to RELAT to get all those positions reporting to manager position fould in step1. Is this correct?

Ans : 002 Relation is the Reporting Relation and 008 is Holder Relationship.

002 will help you to identify the relation ie, which position reports to which position. but if you want to know who is holding the position, you will need 008 relation.

In your case both relation may be required.

2. Does your steps work in any system? I mean, no matter how the data is set up in HRP1001?

Ans : This is the standard System behavior. Unless there is specific changes.

3. Can you also let me know how to start deriving this at company code level? I also have company code termed as Line of Business on my selection. User may enter only company code and i will have to extract everything.

Ans : If you have setup account assignmnet setting for the OU, then you should be able to do that.

[Former Member]

Hi Jithu,

Regarding point 3: When i look at manager details in PA30, i can see that a/c assignment details like comp code, cost center, personal area etc are assigned. Basically, if i have a comp code, i want to know its org unit and employees under that org unit and if possible to know if a particular employee is a manger or director. As you know, the expectation is to pull employees reporting to a manager or director.

Thanks,

SKJ

[Former Member]

I am not a Abaper. So unable to guide to a program / FM.

Check the report RHSTRU00 if this takes you to a solution.