topic Re: multiple condition in the select statement in Application Development and Automation Discussions

multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 13:38:18 GMT

Dear gurus,

Can i use the following syntax for getting data from an internal table.

IF ( WS_CHANNEL = '10' OR WS_CHANNEL = '11' OR WS_CHANNEL = 12 or ws_channel = 15 or ws_channel = 40 ) or ( ( WS_CHANNEL = '50' OR WS_CHANNEL = '60' ) and

( itab-loc = '4058')).

if it is not the correct syntax , how to do it.

Please do the need ful.

Thanx in advance.

R.Rajendran

Re: multiple condition in the select statement

JozsefSzikszai — Tue, 17 Jun 2008 13:42:38 GMT

hi,

yes it is OK. However you can make it a bit simplier:

IF ( ( WS_CHANNEL IN ( '10' , '11' , '12' , '15' , '40' )

OR ( WS_CHANNEL IN ('50', '60' ) AND

itab-loc = '4058' ) ) .

hope this helps

Re: multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 14:06:41 GMT

Please provide proper open bracket and close bracket. since given syntax not working properly.

Re: multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 14:12:29 GMT

Hi Rajender,

Yes, Offcourse this can be possible the only thing in this multiple condition.you need to put a proper open '(' and Closed ')' bracket.

Rest all looks ok to me....

&******Reward point if helpful*************&

Re: multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 14:14:44 GMT

Your syntax is correct. But its better to modify it to

IF ( ( WS_CHANNEL IN ( '10' , '11' , '12' , '15' , '40' )

OR ( WS_CHANNEL IN ('50', '60' ) AND

itab-loc = '4058' ) )

Re: multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 14:16:34 GMT

hiii

you can use it like following code

IF ( WS_CHANNEL IN ( '10' , '11' , '12' , '15' , '40' ) 
OR ( WS_CHANNEL IN ('50', '60' ) AND
itab-loc = '4058' ) ) .

reward if useful

thx

twinkal

Re: multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 14:16:52 GMT

it is ok

Amit.

Re: multiple condition in the select statement

Former Member — Tue, 17 Jun 2008 14:26:05 GMT

IF( WS_CHANNEL IN ( '10','11') or ( ws_channel in ('50','60') and itab-loc = '4058')).

IF WS_CHANNEL = '10' OR WS_CHANNEL = '11' OR WS_CHANNEL = 12 or ws_channel = 15 or ws_channel = 40.

i have given the above statement but the following error shows.

comma without preceeding colon ( after IF (?).

please do the needful.

Regards

R.Rajendran

Re: multiple condition in the select statement

Former Member — Wed, 18 Jun 2008 03:35:35 GMT

check any other errors with the previous statement.