multiple range in select option

[Former Member]

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

[Former Member]

Hi,

You can enter multiple range option in select options.

Regards

Md.MahaboobKhan

[I355602]

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

[dev_parbutteea]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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..