topic Re: if statement with IN and bracket in Application Development and Automation Discussions

if statement with IN and bracket

Former Member — Wed, 30 Jun 2010 06:39:57 GMT

Dear forum,

can the below if statement

if p_waers = 'EUR' or p_waers = 'AUD' or p_waers = 'NZD' or p_waers = 'GBP'.

change to

if p_waers IN ( 'EUR' , 'AUD' , 'NZD' ) ?

i tried but not possible. why?

thanks

Re: if statement with IN and bracket

Former Member — Wed, 30 Jun 2010 06:48:45 GMT

Hello

It is because you do not read help for Logical Expressions - Comparison with a Selection Criterion

You need to create ranges for waers, fill it with your waers and in IF statement compare with ranges.

Re: if statement with IN and bracket

vinod_vemuru2 — Wed, 30 Jun 2010 06:49:18 GMT

Hi,

You can populate all the values in to a range variable and then you can use IN. Answer for Why is, it is the way ABAP language syntax was created by SAP

r_waers-sign = 'I'.

r_waers-option = 'EQ'.

r_waers-low = 'EUR'.

APPEND r_waers.

r_waers-low = 'AUD'.

APPEND r_waers.

r_waers-low = 'NZD'.

APPEND r_waers.

IF p_waers IN r_waers.

Thanks,

Vinod.

Re: if statement with IN and bracket

MarcinPciak — Wed, 30 Jun 2010 06:52:19 GMT

In ABAP it is not possible this way. What I usually do instead is


case p_wears.
   when 'EUR' or 'AUD' or 'NZD' or 'GBP'.
      ...
   when others.
     ..
endcase.

Regards

Marcin

Re: if statement with IN and bracket

Former Member — Wed, 30 Jun 2010 06:53:26 GMT

the IN logical operator requires a comparision against a select-option type structure, so would require something like



data: l_waers type waers.

select-options s_waers for l_waers no-display.


s_waers-sign   = 'I'. 
s_waers-option = 'EQ'. 
s_waers-low    = 'EUR'. 
APPEND s_waers TO s_waers.

s_waers-sign   = 'I'. 
s_waers-option = 'EQ'. 
s_waers-low    = 'AUD'. 
APPEND s_waers TO s_waers.

s_waers-sign   = 'I'. 
s_waers-option = 'EQ'. 
s_waers-low    = 'NZD
APPEND s_waers TO s_waers.

if p_waers in s_waers.



endif.

However a quicker alternative may be


if 'EUR AUD NZD' CS p_waers then.

endif.

Re: if statement with IN and bracket

former_member194797 — Wed, 30 Jun 2010 07:45:27 GMT

replace

if p_waers IN ( 'EUR' , 'AUD' , 'NZD' )

with

if p_waers IN ('EUR','AUD','NZD')

(same code without spaces inside the brackets)

Re: if statement with IN and bracket

Former Member — Wed, 30 Jun 2010 08:35:41 GMT

The reason why IN keyword does not work for you is that it can be used with WHERE keyword, but not with IF keyword.

Re: if statement with IN and bracket

Former Member — Wed, 30 Jun 2010 08:41:24 GMT

hI,

Its always recommended to use CASE ... END CASE in this situation..

Thanks

Suraj

Re: if statement with IN and bracket

NigelJames180 — Tue, 14 May 2013 01:32:46 GMT

Hi Henri,

I was surprised at this solution but I thought I would give it a go.

I find that this code does not compile:

if p_waers IN ('EUR','AUD','NZD').

with or without spaces.

The best solution here is to use a ranges object as Vinod Vemuru correctly describes.

Unfortunately Manish Kumar you can use in with an if and Suraj Nair it is not always recommended to use a case statement in this situation.

Re: if statement with IN and bracket

Former Member — Tue, 14 May 2013 03:46:33 GMT

Depends on the intended usage of IN keyword.

IN keyword can be used with values like IN ('EUR','AUD','NZD') or selection table.

Within an IF, IN can be used if you are using selection table, and not if you are using values list.

Within SELECT..WHERE, IN ('EUR','AUD','NZD') will work.

Creating a range table for matching a fixed list of values in IF statement isn't worth the effort.

Re: if statement with IN and bracket

NigelJames180 — Tue, 14 May 2013 04:27:35 GMT

Yes abap is a little inconsistent at the best of times.

Whether a range table is worth the effort is a case by case basis. I would say it is much better than a case statement given that there is no breaking from a case and fall through that you get in a c switch.