on 10-17-2008 6:47 AM
Hi,
I want to display manager of an employ.
refering to position of employ in infotype 0001, how do i procced to fecth manager of that employ. can pls some one help me on this with tables details.
Thanks in Advance,
BabuSrinath
Hi BabuSrinath,
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
Edited by: Dilek Ersoz on Oct 17, 2008 8:06 AM
Edited by: Dilek Ersoz on Oct 17, 2008 8:07 AM
Edited by: Dilek Ersoz on Oct 17, 2008 8:08 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.