topic small doubt in ranges in Application Development and Automation Discussions

small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:00:39 GMT

Hi,

I need to check a value is there or not in a range. Can somebody tell me the logic please.

r_ranges is having company code ranges like...

I EQ 1001 1004

I EQ 2001 2006

I EQ 3001 3009

I EQ 4001 4007

Now I want to check a variable is there in the above range or not.

Can somebody tell me the logic.

<removed_by_moderator>

Cheers.

Edited by: Julius Bussche on Oct 28, 2008 4:15 PM

Re: small doubt in ranges

naimesh_patel — Tue, 28 Oct 2008 15:02:44 GMT

Check like:


IF W_BUKRS IN R_BUKRS.
  WRITE: ' IT IS VALID'.
ELSE.
  WRITE: 'NOT VALID'.
ENDIF.

Regards,

Naimesh Patel

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:02:55 GMT

Try:


IF v_ccode IN r_ranges.
    "Company code exist in range.
ELSE.
    "Company code does not exist.
ENDIF.

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:03:17 GMT

Hi,

Use something like

if v_variable in r_range.
endif.

if not v_variable in r_range.
endif.

Darren

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:10:31 GMT

Before trying logic, correct the range. The option you should be using is 'BT', not 'EQ'.

Rob

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:12:38 GMT

When I use

if v_variable in r_range.

endif.

It is checking only lower limit of the range. Ex: if ranges contains I EQ 1001 1006. If I check the value 1003, If condition is failed.

What to do.

Regards,

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:15:14 GMT

Hi,

The filling up the range table is incorrect. When you have Low as well as High value means range.. you can't use 'EQ' as option instead use 'BT'.

Hope this helps.

Regds,

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:16:12 GMT


> It is checking only lower limit of the range. Ex: if ranges contains I  EQ   1001     1006. If I check the value 1003, If condition is failed.

Check my answer above.

Rob

Re: small doubt in ranges

Former Member — Tue, 28 Oct 2008 15:20:19 GMT

Do what Rob suggested, do not use EQ, use BT. EQ = equal = single value. BT = Between = range.