GET PERNR

[Former Member]

Hi Folks,

GET PERNR event gets all employees in the HR database but I want to restrict the number of employees based upon some condition. I have written a select query and populated it with the personal Numbers based on some condition but when I use

Select * from pa9000 into itab where ind = 'X'.

Get PERNR.

But its still selecting all the employees. Is there something I am missing . COuld somebody help me on this.

Thanks In Advance.

Rocky.

[Former Member · Accepted solution]

Do this:

Select PERNR INTO PNPPERNR

from PA9000

Where IND = 'X'.

APPEND PNPPERNR.

ENDSELECT.

SORT PNPPERNR BY LOW ASCENDING.

DELETE ADJACENT DUPLICATES FROM PNPPERNR

COMPARING LOW.

This would be done before your GET PERNR statment. Then when the GET PERNR is done the PERNRS it be reading or the ones you populated based on your Select from PA9000.

[Former Member · Accepted solution]

Thanks Rich,

That solved my problem.

[Former Member]

Hi,

If you want to restrict the employees based on Personal Sub area or Personal Area or Compnay code,

If you can use the ldb selection screen, end user can enter the particular persa,persg etc and can retire data particular to that selection only.

My opinion is you can filter the employees based on the selection screen entires.

or you can write some statements in the initialization event.

as suggested by vasu if can come with your exact condition, we can suggest you to that particular direction.

Thanks

[Former Member]

No there is a custom infotype created in which there is a indicator called RHRA . I have to get those employees which has that Indicator as X. and then get the current data for those employees using standard macros.

ROck

[Former Member]

hi,

can you please tell me on wat condition you are working. so that we may get some idea.

Regards,

Vasu.