Application Development and Automation 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: 
Read only

position Type

Former Member
0 Likes
715

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
Read only

venkat_o
Active Contributor
0 Likes
651

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
Read only

Former Member
0 Likes
651

Hi,

Use the reoprt flexible employee data.

Tcode:- S_AHR_61016362

Read only

Former Member
0 Likes
651

Any other ideas please, thanks

Read only

venkat_o
Active Contributor
0 Likes
652

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

Read only

venkat_o
Active Contributor
0 Likes
651

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