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.
Showing results for 
Search instead for 
Did you mean: 

HR ABAP query

Former Member
0 Kudos

Hi Experts,

I am developing HR report.


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
0 Kudos

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' ...

0 Kudos

Validate ENDDA

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