topic Re: select option in Application Development and Automation Discussions

select option

Former Member — Fri, 07 Dec 2007 05:57:25 GMT

Hi experts,

I have a report which takes values from the select option.

I have defined is as I BT LOW HIGH.

but in the selection screen it is taking values in between the given values.

How do i write it such that i want the values including the range given in select option.

Re: select option

former_member386202 — Fri, 07 Dec 2007 05:58:57 GMT

Hi,

In ur INITIALIZATION event pass all the select options values.

Regards,

Prashant

Re: select option

former_member195698 — Fri, 07 Dec 2007 05:59:32 GMT

please explain in detail. also provide the code that you hvae used

Re: select option

Former Member — Fri, 07 Dec 2007 06:00:02 GMT

Hi Mona,

since u have given 'I', it will take the valus including the range..

just check in the database table if u have the values for the range ends.

Thank you.

Re: select option

Former Member — Fri, 07 Dec 2007 06:01:13 GMT

Hi Mona,

Define I, IN, LOW, HIGH, i.e use the IN option instead of BT and you will get the result that you want.

Kindly Reward points if you found the reply helpful.

Cheers,

CHAITANYA.

Re: select option

Former Member — Fri, 07 Dec 2007 06:09:15 GMT

Hi Mona,

When ever you use select options, u have to write a code against it as per your requirement.

For Example consider :::

DATA:username TYPE usr02.

SELECT-OPTIONS uname FOR username-bname NO INTERVALS.

I this case, uname will behave like an internal table, now u could do:

1) Loop on this itab uname as per you require

LOOP AT uname WHERE sign = 'I'.

if uname-option = 'EQ' OR uname-option = 'BT'.

2) use in select query using WHERE Clause as

SELECT *

FROM table
INTO CORRESPONDING FIELDS OF TABLE it_iatb
WHERE fieldname IN uname.

This will automatically take care of your all select options ......

Kindly Reward if useful

Rohit G

Re: select option

Former Member — Fri, 07 Dec 2007 06:13:26 GMT

UNDER INITIALIZATION EVENT when your declaring the default values give the values for that select options as like this

selectoption-low = '1000'.

selectoption-high = '2000'.

selectoption-option = ;i'.

selectoption-sign = 'BT'

here selectoption means your select option filed name

option is I means INCLUDE

E means EXCLUDE

so if you give that vlaue as I then it will take INCLUDED that range values also

Re: select option

Former Member — Fri, 07 Dec 2007 06:22:58 GMT

hi mona,

since u r giving the option BT which means between so it will take the values in between.

in order to get those values only instead of bt put EQ..

this will work.

regards,

sohi

Re: select option

Former Member — Fri, 07 Dec 2007 10:13:06 GMT

But i am giving I also so that means including rite.

Re: select option

Former Member — Fri, 07 Dec 2007 10:25:27 GMT

Hi Mona,

Please refer my previous post for this thread.. i have said the same thing..

Please refer.. u may get some hint again

Re: select option

Former Member — Mon, 10 Dec 2007 11:40:08 GMT

HI MONA

YES "I" MEANS IT WILL INCLUDE THAT VALUES ALSO

IF IT IS "E" THEN EXCULDE THAT VALUES

I THINK YOUR PROBLEM IS SOLVED

IF YOU HAVE ANY QUERY YOU MAY POST AGAIN

YOUR ALL WAYS WELCOME

Re: select option

Former Member — Mon, 10 Dec 2007 11:46:47 GMT

if you are finding error in the select query

try to use

select * from tab_name where req_field iIN select_option.

select_option is the name of field in selection screen

tab_name is the field in table

if this does not help you i would advice you to use debugger

here use the slect ooption variable as a watchpoint and view its value one by one using F5

reward if useful