topic Re: READ internal table with two keys on same field in Application Development and Automation Discussions

READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:40:39 GMT

Hi experts.

I'm trying to read an internal table to two values but apparently i can't use the keyword OR.

Here is what i tryed. Can anybody tell me what is the correct instruction to use ?

Thanks for your help.


* Test 1
  READ TABLE lt_status INTO wa_status 
    WITH KEY txt04 =  ( c_wait_exp OR c_expert ).

*Test 2
  READ TABLE lt_status INTO wa_status 
    WITH KEY txt04 =  c_wait_exp.
   OR txt04 = c_expert.

Both are incorrects.

Re: READ internal table with two keys on same field

ThomasZloch — Mon, 22 Sep 2008 08:42:57 GMT

READ is supposed to return a single entry, so there is a logical problem with using OR conditions. That's why they are not allowed.

See if you can use LOOP AT ... WHERE ... instead.

Thomas

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:43:22 GMT

HI,

neither of the syntax is supported by ABAP.

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:44:49 GMT

You cannot use "AND" or "OR" in READ TABLE.

You have to use "LOOP AT" to use the OR condition.

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:47:03 GMT

Use range , Firsttly declare oa variable of type range . Now pass both of your constants in ranhe as

Data ; l type range .

pass both of your constants in range (For help see SAP Help)

now

READ TABLE lt_status INTO wa_status

WITH KEY txt04 in l .

~hitesh

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:47:41 GMT

Hello,

You have to use READ statement twice.

READ TABLE lt_status INTO wa_status

WITH KEY txt04 = c_wait_exp.

IF sy-subrc NE 0.

READ TABLE lt_status INTO wa_status

WITH KEY txt04 = c_expert.

IF sy-subrc NE 0.

Give u r error message here.

ENDIF.

IF one of the statement is true , do u r processing after that.

Hope it solves u r problem.

Thanks,

Chandra.

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:49:02 GMT

Hi Helder,

Both of the syntax are wrong. No OR operator is not supported in READ Statement.

Try using LOOP AT <itab> WHERE <condition> where you can use OR condition.

Regards,

Chandra Sekhar

Re: READ internal table with two keys on same field

naveen_inuganti2 — Mon, 22 Sep 2008 08:49:31 GMT

Hi ..

If fields are different don't use opertors...

do like this..,

> read table itab with key field1 = 'gfhg' field2 = 'fhbrsjf'.

But, for the same filed its not possible.!!

Thanks,

Naveen.I

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:50:01 GMT

Hi,

With READ table you can not use same field more than one time for comparison.

You can get this functionality using LOOP ....Endloop.

Like-

Data:itab like standard table of sflight,

wa like line of itab.

Loop at itab into wa where carrid = 'AA' or carrid = 'AB'.

endloop.

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:51:00 GMT

Hi Helder,

You can not use expression with logical operators and other relational operators except '=' in READ statement.

So you need to query with the first value then if it fail then query with second value.


  READ TABLE lt_status INTO wa_status 
    WITH KEY txt04 =  c_wait_exp.

  IF SY-SUBRC EQ 0.
     <<Required logic>>
  ELSE.
 
  READ TABLE lt_status INTO wa_status 
    WITH KEY txt04 = c_expert.
   IF SY-SUBRC EQ 0.
     <<Required logic>>
   ENDIF.
ENDIF.

Thanks,

Vinay

Re: READ internal table with two keys on same field

Former Member — Mon, 22 Sep 2008 08:56:24 GMT

try this:


data: flag1 type c length 1,
        flag2 type c length 1.

READ TABLE lt_status INTO wa_status 
    WITH KEY txt04 =  c_wait_exp .
if sy-subrc = 0.
 flag1 = 'X'.
endif.
READ TABLE lt_status INTO wa_status 
    WITH KEY txt04 =  c_expert.
if sy-subrc = 0.
 flag2 = 'X'.
endif.

if flag1 = 'X' or flag2 = 'X'.
 " Write your code here
endif.