topic Re: Sq02 Extra field in Application Development and Automation Discussions

Sq02 Extra field

Former Member — Mon, 13 Jul 2015 13:41:07 GMT

HI ,

I have created a query and looking for multiple conditions.I have created coding where system checks for one condition but I want to check multiple conditions .

Single condition

check LFB1-bukrs ='A'
AND PURCHASINGORG ='A1'.

I have couple of more condition to check here like

check LFB1-bukrs ='A'
AND PURCHASINGORG ='A1'.

check LFB1-bukrs ='B'
AND PURCHASINGORG ='B1' or 'B2'

check LFB1-bukrs ='C'
AND PURCHASINGORG ='C1' .

Many Thanks

Re: Sq02 Extra field

tomas_talpa — Mon, 13 Jul 2015 15:31:02 GMT

Yyou pretty much posted your logic, Preeti, just wrap it in brackets (each AND statement and total OR statement) and you are done... or what is the question?

TomT

Re: Sq02 Extra field

Former Member — Mon, 13 Jul 2015 15:39:58 GMT

Hi tom .

Thank you ,

I tried in different ways but getting errors.

check LFB1-bukrs ='A'
( AND PURCHASINGORG ='A1'.)

check LFB1-bukrs ='B'
(AND PURCHASINGORG ='B1' or 'B2')

Re: Sq02 Extra field

tomas_talpa — Mon, 13 Jul 2015 16:15:32 GMT

CHECK(

( LFB1-bukrs ='A' AND PURCHASINGORG ='A1') OR
( LFB1-bukrs ='B' AND PURCHASINGORG ='B1') OR

( LFB1-bukrs ='B' AND PURCHASINGORG ='B2') OR

( LFB1-bukrs ='C' AND PURCHASINGORG ='C1') ) .

...bit overdone with brackets (since AND precedes OR in priority), but it makes it legible.

Re: Sq02 Extra field

Former Member — Tue, 14 Jul 2015 08:18:56 GMT

Thanks Tom.

It worked .