topic multiple range in select option in Application Development and Automation Discussions

multiple range in select option

Former Member — Thu, 05 Mar 2009 07:07:48 GMT

Hi,

I have to give four ranges for Gl account at the time of data selection. so could you please tell me how can I do this.

For exa : 1.(2111 to 2222) or

2.(2333 to 2444) or

3.(2555 to 2666) or

4. (2777 to 2888).

Regards,

Amar

Re: multiple range in select option

Former Member — Thu, 05 Mar 2009 07:09:17 GMT

Hi,

You can enter multiple range option in select options.

Regards

Md.MahaboobKhan

Re: multiple range in select option

I355602 — Thu, 05 Mar 2009 07:10:40 GMT

Hi,

When you take a field as select-options on selection screen, then a button is appended next to the high value.

Click on the button and a popup will appear.

Move to tab INCLUDE RANGES

And click execute button on the popup, you range will be appended.

Hope this helps you.

Regards,

Tarun

Re: multiple range in select option

dev_parbutteea — Thu, 05 Mar 2009 07:11:41 GMT

HI,

select *

from table

where (field ge '2111' and le '2222')

or (field ge '2333' and le '2444')

or (field ge '2555' and le '2666')

or (field ge '2777' and le '2888')

Regards.

Re: multiple range in select option

Former Member — Thu, 05 Mar 2009 07:17:08 GMT

Hi,

When you use select options, at runtime you can select the ranges. just next to the input window there is an button with an arrow. on clicking it you can define the multiple ranges between the values as you required. Goto to 'multiple ranges' tab.

Vinay

Re: multiple range in select option

Former Member — Thu, 05 Mar 2009 07:22:21 GMT

HI,

As Select-options is an internal table ,and in WHERE clause you put condition like

where GI IN s_gi.

this will be taken care by itself you don't need to extra code for that.

regards,

Neha

Re: multiple range in select option

Former Member — Thu, 05 Mar 2009 07:50:19 GMT

Hi,


ranges: r_fieldname for tablename-fieldname.

r_fieldname-sign = 'I'.       "including
r_fieldname-option = 'BT'. "between
r_fieldname-low = '2111'.
r_fieldname-high = '2222'.
     
  APPEND r_fieldname.
  Clear       r_fieldname.

same way append 2333 to 2444, 2555 to 2666, 2777 to 2888

Thanks,

Krishna..