problem with select

[Former Member]

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.

[jayanthi_jayaraman]

Hi,

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

[Sandeep_Panghal]

select * from xyz into table where field ne so_persk.

[Former Member]

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

[Former Member]

Be more clear on your question.

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

Thanks,

Mathivanan.G

[Former Member]

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

[Former Member]

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

[Former Member]

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.