topic Re: SELECT-OPTIONS and data collection in Application Development and Automation Discussions

SELECT-OPTIONS and data collection

pradeepmathewch — Tue, 25 Mar 2008 10:16:03 GMT

Hi All,

I have one inputfield (say users) via SELECT-OPTIONS and it goes to an internal table called "userlist" with values USER1, USER2 etc...(Example)

Now, when I query the database with "userlist" as the input, I'm not able to do so because SELECT-OPTIONS contains an Internal table with values LOW, HIGH etc...

So my input value goes like this IEQUSER1, IEQUSER2 etc......

Could anyone tell me what should I do in order to get USER1, USER2 etc.

Thanks in advance,

Pradeep

Re: SELECT-OPTIONS and data collection

Former Member — Tue, 25 Mar 2008 10:19:01 GMT

Hi pradeep,

1. Exactly for this purpose, we have to use

in the select query, intead of =.

2. In your case

select * from dbtab

where field IN SELOPTION.

regards,

amit m.

Re: SELECT-OPTIONS and data collection

Former Member — Tue, 25 Mar 2008 10:19:31 GMT

HI,

IN selection-Screen click the Extenction Button

and give ur input.

Regards,

S.Nehru

Re: SELECT-OPTIONS and data collection

Former Member — Tue, 25 Mar 2008 10:19:56 GMT

Hi,

code like this.

select-options user for table-user.

select * from table where user in user.

regards,

V.Balaji

Reward if usefull

Re: SELECT-OPTIONS and data collection

pradeepmathewch — Tue, 25 Mar 2008 10:46:27 GMT

Hi All,

Sorry. I'm getting the error: 'Line structure of table USERLIST is incorrect'.

My coding is as follows:

tables : usr02.

data: begin of users,

users type XUBNAME,

end of users.

data : it_usr02 like table of usr02.

data : l_userlist type xubname, "This is a data elemnt thats already in the system of type BNAME

p_userlist like l_userlist.

select-options: userlist for users.

loop at userlist into l_userlist.

select * from usr02 into corresponding fields of table it_usr02 where bname in userlist.

endloop.

ENDFUNCTION.

Could you please help?

Thanks and Regards, Pradeep