doubt in multiple select options

[Former Member]

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

[Former Member]

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 <i>s_vkorg</i>) 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 <b>do</b> 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

[Former Member]

Hi Gowri Sankar,

You can use ranges for multiple selection.

Reward If Useful..

Regards,

Chitra

[JozsefSzikszai]

hi Gowri,

your range: gr_salesorg....

your selection:

SELECT ...

...

WHERE salesorg <b>IN</b> gr_salesorg

hope this helps

ec