Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

position Type

Former Member
0 Kudos
182

Hi all,

I have a requirement as such If employee's employment status(STAT2=0) is withdrawn or retireee(STAT2=2) on report run date then fetch position type for the last hold position and display in output.

Can you help me in coding the above please. Thnaks in advance

1 ACCEPTED SOLUTION

venkat_o
Active Contributor
0 Kudos
118

Hi, <li>Try this way.


SELECT * FROM pa0000 INTO p0000 WHERE pernr = '00090104'
                                  AND stat2 in ('2', '0').
  SELECT * FROM pa0001 INTO p0001 WHERE pernr = '00090104'
                                    AND endda LE p0000-endda
                                    AND begda GE p0000-begda.
    WRITE p0001-plans. "Plans is Position
  ENDSELECT.
ENDSELECT.
Thanks Venkat.O

4 REPLIES 4

Former Member
0 Kudos
118

Hi,

Use the reoprt flexible employee data.

Tcode:- S_AHR_61016362

Former Member
0 Kudos
118

Any other ideas please, thanks

venkat_o
Active Contributor
0 Kudos
119

Hi, <li>Try this way.


SELECT * FROM pa0000 INTO p0000 WHERE pernr = '00090104'
                                  AND stat2 in ('2', '0').
  SELECT * FROM pa0001 INTO p0001 WHERE pernr = '00090104'
                                    AND endda LE p0000-endda
                                    AND begda GE p0000-begda.
    WRITE p0001-plans. "Plans is Position
  ENDSELECT.
ENDSELECT.
Thanks Venkat.O

venkat_o
Active Contributor
0 Kudos
118

Hi, <li>Use the function module HR_GET_POSITIONS_FOR_EMPLOYEE. Thanks Venkat.O