topic Re: problem with select in Application Development and Automation Discussions

problem with select

Former Member — Wed, 20 May 2009 07:18:34 GMT

hi experts,

i have a report with selection screen.

selection-option: so_persk type pa0001-persk.

the user want all the rows that not answer on that selection.

for example: the user enter 01-04: all the row that the persk not between that.

my problem is: the user can type single values like: so-persk-low = 01 and

so_persk-low = 31.

and so_persk-high = 4.

that means that i have to bring all the rows that not between 1-4 and not eq to 31(=so_persk-low).

how do i do that?

if i do: if var < so_persk-low or var > so_persk-high....its not enough-it bring all the rows.

i hope i was clear.

than you very much.

Michal.

Re: problem with select

jayanthi_jayaraman — Wed, 20 May 2009 07:27:36 GMT

Hi,

This will automatically be taken care by select-options if they enter the values in exclude option.

Re: problem with select

Sandeep_Panghal — Wed, 20 May 2009 07:28:10 GMT

select * from xyz into table where field ne so_persk.

Re: problem with select

Former Member — Wed, 20 May 2009 07:29:15 GMT

Hi,

As for my understaning the input select option ill take care all the possiblities for which you enter in the Exclude option for that field (F4).Just in select stament mention as fieldanem IN s_inputfield

Re: problem with select

Former Member — Wed, 20 May 2009 07:33:23 GMT

Be more clear on your question.

In addition If you select . . . where pernr IN s_pernr everything will be taken care

Thanks,

Mathivanan.G

Re: problem with select

Former Member — Wed, 20 May 2009 08:23:21 GMT

hi mic,

there is no need of any coding for your above req..

please note that select options are used for the same requ

in Select optin u will get an extended button. click on u will get some choices like select single value ,exlcude single value.. like. this

Ask your user ,to enter the values inside this options...

Convince him .

safel

Re: problem with select

Former Member — Wed, 20 May 2009 08:40:56 GMT

Hi,

On your selection screen... your select option has multiple selection button...

just click that and you can provide all the values which are to be included either single values or ranges

and also exclude values single or ranges

and press continue...

you can execute your report...

select options will take care of your requirement... you need not perform any task for this..

regards

padma

Re: problem with select

Former Member — Wed, 20 May 2009 09:04:17 GMT

Hi ,

You can use exclude options to give all values that needs to be excluded.

In select statement , by using persk in so_persk will automatically exclude the given input values.

Thanks.