topic Re: Read Table with OR condition in Application Development and Automation Discussions

Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:39:46 GMT

how can i check "OR" condition in: Read table itab with key...

ie, Read Table itab With Key f1 = '1000' or f2 = '5000'.

pls give me the syntax............

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:42:04 GMT

hiiii

you can not use OR or AND in READ statement..

but you can do the same thing differently like below

Read Table itab With Key f1 = '1000' .

if sy-subrc <> 0.

Read Table itab With Key f1 = '5000' 
endif.

it will give you same result as you want to get.

reward if useful

thx

twinkal

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:42:09 GMT

It can't do it, it needs to replace that statament with LOOP/ENDLOOP

LOOP AT ITAB WHERE F1 = '1000'
                               OR F2 = '5000'.
    EXIT.
ENDLOOP.

If you insert the EXIT into the loop, that statament will be like READ TABLE

Max

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:42:48 GMT

You cant use AND and OR operators in read statement

better to use if statement

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:43:11 GMT

hiii

Read Table itab With Key f1 = '1000' .
 
if sy-subrc NE  0.
 
Read Table itab With Key f1 = '5000' 
endif.

reward if useful

thx

twinkal

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:43:19 GMT

Hi,

You can use only '=' with read statement.

So it is best if you use two read statements to achieve your functionality like

Read Table itab With Key f1 = '1000' .

If sy-ssubrc eq 0.

continue with priocessing

else.

Read Table itab With Key f2 = '5000'

IF sy-subrc eq 0.

continue with priocessing

endif.

endif..

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:43:33 GMT

Hi,

you could use:

LOOP AT itab INTO wa WHERE f1 = '1000' OR f2 = '5000'.
* Do Something
ENDLOOP.

Regards

Mark-André

Re: Read Table with OR condition

Former Member — Thu, 19 Jun 2008 07:44:21 GMT

Hi Babu ,

I dont think that is possible when you use a read statement.

Regards

Arun

Re: Read Table with OR condition

vishalshinde — Mon, 27 Jun 2022 08:59:09 GMT

solution is working

Re: Read Table with OR condition

vishalshinde — Mon, 27 Jun 2022 08:59:46 GMT

Solution is working