Manager Name for particular personnel number
I got a personnel number data, but i want fetch the manager name for particular personnel number. How to fetch manager name ?
Please help me in this issue...
0. SELECT FROM PA0001 WHERE PERNR = personnelpersnumber PLANS = position of employee
1. SELECT FROM HRP1001 WHERE RSIGN = A RELAT = 002 OTYPE = 'S' OBJID = position_of_employee SCLAS = 'S': SOBID = manager position
2. SELECT FROM HRP1001 WHERE RSIGN = A RELAT = 008 OTYPE = 'S' OBJID = sobid of prev step SCLAS = 'P'.
SOBID of the second SELECT is personnel number of the manager
3. SELECT FROM PA0000 WHERE PERNR = pernoofmanager.
ENAME of 3rd step is manager's name.