topic Re: loop where range in Application Development and Automation Discussions

loop where range

Former Member — Tue, 08 Nov 2005 19:17:38 GMT

Hello,

i´m executing a simple loop using a range in the where condition.

eg. loop at itab into wa_tab

where racct in r_range.

Values in r_range are

sign - 'I'

option 'EQ'

low '0000311001'

high '0000315004'

The loop only finds the 'low' entry and then ends although both numbers are in the itab. If I change option to 'BT' the loop will find all those numbers between low and high.

What am i overlooking?

Thank you,

Kevin

Re: loop where range

Former Member — Tue, 08 Nov 2005 19:20:53 GMT

EQ is intended for single values - 000311001 only or 000315004 only.

BT is intended for values with a "distance" between them.

Re: loop where range

Former Member — Tue, 08 Nov 2005 19:22:40 GMT

Put 'BT' instead of 'EQ in the option of range type.

Cheers,

Satya

Re: loop where range

Former Member — Tue, 08 Nov 2005 19:24:55 GMT

If you want only the two records, you need the following in your table:

sign - 'I'
option 'EQ'
low '0000311001'
append r_range.

sign - 'I'
option 'EQ'
low '0000315004'
append r_range.

Rob

Re: loop where range

Former Member — Tue, 08 Nov 2005 19:25:00 GMT

If you don't want range and need more single selection append individual entry to range with 'EQ' Option.

Re: loop where range

RichHeilman — Tue, 08 Nov 2005 19:27:19 GMT

Do you want it to find those values only? Then you must add both of the values to the range table like so.



range-sign = 'I'.
range-option = 'EQ'.
range-low = '0000311001'.
append range.

range-sign = 'I'.
range-option = 'EQ'.
range-low = '0000315004'.
append range.

Here you are specifying single values. You only want when you get a hit for 311001 or 315004.

Regards,

Rich Heilman

Re: loop where range

Former Member — Tue, 08 Nov 2005 19:32:52 GMT

Kevin,

Best option is :

1. Create Ranges

2. Use <b>Ranges in the Database Selection</b> instead at Internal Table Validation.

Example:

select * from MKPF into table itab where mblnr in r_range.

Thanks

Kam

Message was edited by: Kam

Re: loop where range

Former Member — Tue, 08 Nov 2005 19:38:31 GMT

Thanks John,

Of course, (It´s getting late..)