Sq02 Extra field

[Former Member]

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'.

OR

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

OR

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

Many Thanks

[tomas_talpa]

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

[Former Member]

Hi tom .

Thank you ,

I tried in different ways but getting errors.

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

OR

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

[tomas_talpa]

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.

[Former Member]

Thanks Tom.

It worked .