topic Re: READ Statement..? in Application Development and Automation Discussions

READ Statement..?

subbarao_ilam — Thu, 18 Feb 2010 17:04:17 GMT

Hi All,

In the read statement after key vbeln can I use conditions like AND, OR

to check multiple conditions..?

Read table I_ITEMS with key vbeln = I_INV_ITEMS-VBELN

posnr = I_INV_ITEMS-uepos

binary search.

Pls let me know.

subbu.

Re: READ Statement..?

Former Member — Thu, 18 Feb 2010 17:08:07 GMT

For that logic, I think we would want to do:

LOOP at <table> [ assigning <field-symbol>]

where...condition

and ( xxxx=xxxx or ( yyyy=yyyy and zzzz <> aaaa ) )

endloop.

Re: READ Statement..?

Former Member — Thu, 18 Feb 2010 17:10:12 GMT

answer for your question is No.

In read statement we are not suppose to use any AND and OR.

But this question is a basic question.

Before posting the question please do the some research. This kind of questions can be solved by yourself.

Re: READ Statement..?

vinod_vemuru2 — Thu, 18 Feb 2010 17:11:42 GMT

Hi,

Just READ the F1 help on READ. You will get the answer+ some bonus documentation:)

Try to use OR and see what it says.

FYI... Basic questions are not allowed in forums.

Thanks,

Vinod.

Re: READ Statement..?

Former Member — Thu, 18 Feb 2010 22:48:18 GMT

No, READ statement allows only simple = condition. If you want stronger condition with >, <, <=, AND, OR etc. there is trick for it using the loop cycle.

DATA: is_items LIKE LINE OF i_items.
LOOP AT i_items INTO is_items 
   WHERE vbeln = i_inv_items-vbeln 
                AND posnr = i_inv_items-uepos 
                OR <some other condition>.
   EXIT.
ENDLOOP.

After that loop you will have your line in the structure IS_ITEMS.

So the key is to use LOOP with additional WHERE condition and inside use EXIT. This will safely simulate READ functionality with possibility of strong logical condition.

And dont forget to check sy-subrc after loop