topic Re: Regarding Select Options Ranges.... in Application Development and Automation Discussions

Regarding Select Options Ranges....

Former Member — Sat, 14 Jun 2008 06:17:52 GMT

Hii all,,

Am Giri...

Am wrking on ABAP-HR ....

Presently am generating report on PF for both contract employees and regular employees..

My prblm is tat..

Am taking the personnel number at run time by select options.

suppose..my data is..

Ecode Ename PFnumber Pfbasis

01 sham 01 2000

...........................

..........

1000 ram 1000 5000..

suppose my data is of 1000 records... itzz gving me the correct data for some employees when i give different ranges........but instead of tat it should give the correct data even if i dont give the range also..right...

Can anyone please help me in solving this problem...

itzz quite an urgent ont for me........

Thanking You all..........

With Regards..

Giri

Re: Regarding Select Options Ranges....

Former Member — Sat, 14 Jun 2008 11:32:25 GMT

see the select statement whether it is wrong or not

select-options:s_pernr for pa0002-pernr .

ranges:r_pernr for pa0002-pernr .

loop at s_pernr .

r_pernr-low = s_pernr-low .

r_pernr-sign= 'I'.

r_pernr-options = 'EQ'.

appnd r_pernr .

endloop.

use this r_ranges in the select statement

Re: Regarding Select Options Ranges....

Former Member — Sat, 14 Jun 2008 21:47:14 GMT

May be ur select statement is not working properly pl. check it again.

select-options: s_pernr for PA0001-pernr.

Now when selecting data from database table use s_pernr with IN operator in the where clause of the select statement without considering it's content i.e. 'if not s_pernr[] is initial' this check is not required before the select statement.

Ex:

Select .........

...................

where pernr in s_pernr.

Regards,

Joy.