Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Manager Name for particular personnel number

Hi Friends,

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...

Cheers,

Guru.

replied

Hi ,

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.

Regards,

Dilek

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question