topic Re: doubt in multiple select options in Application Development and Automation Discussions

doubt in multiple select options

Former Member — Wed, 31 Oct 2007 07:21:49 GMT

Hi,

I have a report in this report now running with single select option for sales org. but i want to make multiple select option, it means i want to select 3 different S.organisation . For that i created range. if i gives the multiple input it will correct output or not. Otherwise i want to make code change also? I have confusion regarding this. can anyone plz guid this.

Gowri

Re: doubt in multiple select options

Former Member — Wed, 31 Oct 2007 07:38:56 GMT

Hi Gowri,

As far as I can understand from your message, I think there is no problem at all. Suppose you have declared a select-options:


select-options: s_vkorg for vbak-vkorg.

Then this sentence for selecting sales documents should work:


select * from vbak where vkorg in s_vkorg.
  ...
endselect.

...regardless of whether the select-options is populated with a single value, a single range, or several single values, or several ranges, or a mix of that all. Please note that a select options (in the example s_vkorg) is actually an internal table, and thus can store several entries. So I don't really understand why you need a range.

But anyway, if you do need a range, the behaviour is exactly the same as the select-options, that is, you can use it in a "select... from... where..." sentence.

I hope it helps. Best regards,

Alvaro

Re: doubt in multiple select options

Former Member — Wed, 31 Oct 2007 07:40:09 GMT

Hi Gowri Sankar,

You can use ranges for multiple selection.

Reward If Useful..

Regards,

Chitra

Re: doubt in multiple select options

JozsefSzikszai — Wed, 31 Oct 2007 07:40:09 GMT

hi Gowri,

your range: gr_salesorg....

your selection:

SELECT ...

...

WHERE salesorg IN gr_salesorg

hope this helps