2006 Apr 27 7:13 AM
Hi
I require to display the position description in one of my HR Reports. where can i can get the position details
Regards
Ganesh
2006 Apr 27 7:26 AM
Hi
I require to display the position description in one of my HR Reports. where can i can get the position details
Regards
Ganesh
2006 Apr 27 7:26 AM
2006 Apr 27 7:41 AM
Hi Ganesan,
Descriptions are stored in table HRP1000
with OTYPE = 'S'.
**Don't forget to reward points for all helpful replies
2006 Apr 27 7:43 AM
Hi,
did you check the info type PA0001,
<b>PA0001-PLANS "position
PA0001-STELL "job</b>
these are the fields you are looking for.
Regards
vijay
2006 Apr 27 9:52 AM
Hi
I fetch the Position details from T528T-PLSTX table by using common field 'PLANS'
Is it correct or suggest me pls
Regards
Ganesh
2006 Apr 27 9:57 AM
Yes get the plans from Pa0001 and then pass it to T528T
pass the appropriate Object type and get the text.
Regards
vijay
2006 Apr 27 10:00 AM
But If i do this method, i am getting a duplicate records also . how do i avoid ?
Regards
Ganesh
2006 Apr 27 10:00 AM
Hi,
PASS language 'EN' and oject type 'S' and then PLANS Position to T528T and get the text .
Regards
vijay
2006 Apr 27 10:03 AM
How you will get ...?
since there are 4 keys , one language(EN),Object type(S), Position(Unique), and enddate.
you will not get the duplicates .try to pass all these in where condition.
Regards
vijay
2006 Apr 27 10:09 AM
Hi
Thanks very much, now i am able to get the correct records
Regards
Ganesh
2006 Apr 27 10:12 AM
Please close the thread and reward points for helpful answers.
Regards
vijay
2006 Apr 27 10:07 AM
Hi Ganesh,
You will get position description from HRP1000 table.
Please check the below code :
** Get Position from HRP1000
SELECT stext INTO hrp1000-stext UP TO 1 ROWS
FROM hrp1000
WHERE objid = p0001-plans
AND OTYPE = 'S'
AND LANGU = sy-langu
AND endda = '99991231'.
ENDSELECT.
Hope this will help you.
Thanks & Regards,
Siri.
kindly award points if it is useful.
Message was edited by: Srilatha T
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |