12-14-2009 9:00 AM
Dear friends ,
I want to find in HR the link between employees and their chiefs . For example i belong to IT department and i want to find who is my chief.
Is there any FM or any Bapi .
If there isn't which is the tables ?
Thanks a lot .
12-14-2009 9:26 AM
Hi Dimath,
You can use HRP1001 table for it.
SELECT SOBID from HRP1001 into wa_sobid1 where otype = 'P' and objid = <your employee no> and subty = 'B008' and sclas = '9S'.(This will give you position of yours).
SELECT SOBID from HRP1001 into wa_sobid2 where otype = '9S' and objid = wa_sobid1 and subty = 'A002'' and sclas = '9S'.(This will give you position of your chief).
SELECT SOBID from HRP1001 into wa_sobid3 where otype = '9S' and objid = wa_sobid2 and subty = 'A008'' and sclas = 'P'.(This will give you employee id of your chief).
Thanks
Nitesh
12-14-2009 9:26 AM
Hi Dimath,
You can use HRP1001 table for it.
SELECT SOBID from HRP1001 into wa_sobid1 where otype = 'P' and objid = <your employee no> and subty = 'B008' and sclas = '9S'.(This will give you position of yours).
SELECT SOBID from HRP1001 into wa_sobid2 where otype = '9S' and objid = wa_sobid1 and subty = 'A002'' and sclas = '9S'.(This will give you position of your chief).
SELECT SOBID from HRP1001 into wa_sobid3 where otype = '9S' and objid = wa_sobid2 and subty = 'A008'' and sclas = 'P'.(This will give you employee id of your chief).
Thanks
Nitesh
12-14-2009 9:32 AM
12-14-2009 9:36 AM
Hi,
You need to look in pa0001 for slm id emps manager will be there in pa0001 u will have his position or relationships can be checked in hrp1001 or from tcode pp03
Regards,
Sandhya
12-14-2009 9:46 AM
Hi,
Use FM HRCM_ORGUNIT_MANAGER_GET and then enter PLVAR,OTYPE as S,OBJID the position of the employee(can be seen from pa0001 table or IT0001 infotype),BEgda,endda and pathid as evaluation path(use ooaw tcode for finding the evaluation path for Reports to, normally it will be A002), then the output will give the manager details.
12-16-2009 7:39 PM