topic Re: HR ABAP query in Application Development and Automation Discussions

HR ABAP query

Former Member — Tue, 10 Jun 2008 09:26:20 GMT

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???

Re: HR ABAP query

Former Member — Tue, 10 Jun 2008 09:33:37 GMT

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

Re: HR ABAP query

Former Member — Tue, 10 Jun 2008 09:51:40 GMT

Validate ENDDA

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