topic Re: multiple selections in Application Development and Automation Discussions

multiple selections

Former Member — Mon, 05 May 2008 07:19:12 GMT

could anyone help me with a sample program for the following reqt?

i have three select options: Customer, telephone no. and address. If i want to choose 3 Customer names, 5 telephone numbers, 9 address. Each of this selection should be considered as 3 separate search data and the search should be performed independently.

Re: multiple selections

andreas_mann3 — Mon, 05 May 2008 07:23:39 GMT

use:

select * from KNA1

where ( kunnr in s_kunnr )

or ( telf1 in s_telf )

or ( stras in s_stras )...

Re: multiple selections

Former Member — Mon, 05 May 2008 10:57:06 GMT

Hello Sneha-

Try this sample code and let me know the results because I have some doubts regarding multiple selections.

tables kna1.

types:begin of st_kna1,

kunnr type kunnr,

telf1 type telf1,

stras type STRAS_GP,

end of st_kna1.

data:i_kna1 type table of st_kna1.

select-options:s_kunnr for kna1-kunnr,

s_telf for kna1-telf1,

s_stras for kna1-stras.

select kunnr

telf1

stras from kna1 into table i_kna1

where kunnr in s_kunnr[] or

telf1 in s_telf[] or

stras in s_stras[].

Cheers,

~Srini....