topic Re: Comparing select options and range table in Application Development and Automation Discussions

Comparing select options and range table

Former Member — Thu, 11 Dec 2014 15:55:03 GMT

Hi All,

I have a requirement like following senario:

I have a range table with 10 records: 1, 3, 9, 12, 15, 18, 21, 24, 27, 30 and in select option if i give low = 3 and high = 14, then i need to fetch records from range table which are in select option range (i.e 3, 9, 12) into another range table.

Any suggestion will be highly appreciated.

Regards,

Sharan

Re: Comparing select options and range table

Former Member — Thu, 11 Dec 2014 16:02:36 GMT

What have you coded so far?

Rob

Re: Comparing select options and range table

roberto_vacca2 — Thu, 11 Dec 2014 16:17:21 GMT

Hi.

Did you try something like :

LOOP AT range_table.

IF range_table-value IN sel_option.

ELSE.

ENDIF.

ENDLOOP.

Hope to help

Bye

Re: Comparing select options and range table

Former Member — Thu, 11 Dec 2014 17:31:34 GMT

Hi Sharanabasappa,

So my understanding is this first range table with all the data is single selection row records.

So all of them will be stored as I EQ 1, I EQ 3 etc..

In which case if your first range table with all individual records are r_1, your select option is so_1 and the final range is r_2.

Then you can do the following:

MOVE r_1[] TO r_2[].

DELETE r_2 WHERE low NOT IN so_1.

Regards,

Nabarko

Re: Comparing select options and range table

VenkatRamesh_V — Fri, 12 Dec 2014 10:50:35 GMT

Hi Sharanabappa,

Hope it helpful.

loop at range.

if range-num between so_num-low and so_num-high.

else.

delete range index sy-tabix.

endif.

endloop.

Regards,

Venkat.

Re: Comparing select options and range table

Former Member — Fri, 12 Dec 2014 11:59:09 GMT

hi sharan,

I have coded and tried to get the result as per your requirement.

Have a look at the following code.

REPORT ZR_RANGE_TABLE.

DATA: num1 type I.

TYPES: range_type TYPE RANGE OF fieldname.

DATA: range_table1 TYPE range_type,
range_wa1 TYPE LINE of range_type,
range_table2 TYPE range_type,
range_wa2 TYPE LINE of range_type.
DATA: counter TYPE I VALUE 1.

range_wa1-sign = 'I'.
range_wa1-option = 'EQ'.
range_wa1-low = 1.
APPEND range_wa1 to range_table1.

DO 10 TIMES.
range_wa1-sign = 'I'.
range_wa1-option = 'EQ'.
range_wa1-low = 3 * counter.
APPEND range_wa1 to range_table1.
counter = counter + 1.
ENDDO.

SELECT-OPTIONS: val FOR NUM1.

START-OF-SELECTION.

loop at range_table1 into range_wa1.
write: / range_wa1-low.
If range_wa1-low BETWEEN val-low AND val-high.
APPEND range_wa1 to range_table2.
ENDIF.
ENDLOOP.

write: / 'Final result in range table2'.

loop at range_table2 into range_wa1.
write: / range_wa1-low.
ENDLOOP.

INITIALIZATION.
val-sign = 'I'.
val-option = 'BT'.
val-low = 3.
val-high = 14.
append val.