HR ABAP query

[Former Member]

Hi Experts,

I am developing HR report.

requirement:

There are two options on the selection screen

1) using personnel no: if the first option i.e. get the personnel no selected and entered the personnel no the report is giving the correct optput in SAp-Script

2) using last name and first name : if report run using the second option i.e. last name, report is not giving the correct output.

it is not selecting the values if give last name as 'p*'.

how do i do that ??? if i entered the value 'p*' as last name.

any sample code???

[Former Member]

for the second option ...

select * from PA0002 into table it_pa0002

where NACHN in s_nachn. <-- your select-option(p*)

Here U'll get all the pernr's into internal table it_pa0002

whose lastname starts with 'p' ...

[Former Member]

Validate ENDDA

Select * from pa002 into table itab_pa0002 where nachn in s_name and endda = '99991231'.