topic Re: read table in Application Development and Automation Discussions

read table

Former Member — Thu, 24 Apr 2008 10:05:10 GMT

i have to read a internal table with two key values for the same field.

itab contains the following records:

val1 x x

val2 x x

val3 x x

for <f1> = val1 or val2 i want to read itab.

read table <itab>into <wa> with key <f1> =val1 or val2. this stmt doesnt work..so how can i do it?

Re: read table

Former Member — Thu, 24 Apr 2008 10:06:55 GMT

u cannot read the record in that way.

loop the internal table.

use if -endif condition to check the same.

regards,

madhu

Re: read table

Former Member — Thu, 24 Apr 2008 10:08:59 GMT

i have to read a internal table with two key values for the same field.

itab contains the following records:

val1 x x

val2 x x

val3 x x

for <f1> = val1 or val2 i want to read itab.

read table <itab>into <wa> with key <f1> =val1 or val2. this stmt doesnt work..so how can i do it?

u r code only excetues but small modification is needed i.e.

read table <itab>into <wa> with key <f1> =val1 or <f1> =val2.

its enough..

reward if useful

Re: read table

Former Member — Thu, 24 Apr 2008 10:09:36 GMT

Try like this.

read table <itab>into <wa> with key <f1> = val1

or <f1> = val2.

Regards

Haritha.

Re: read table

Former Member — Thu, 24 Apr 2008 10:11:00 GMT

Read the internal table twice ...

read table itab into wa with key f1 = val1.

if sy-subrc <> 0.

read table itab into wa with key f1 = val2.

endif.

Re: read table

Former Member — Thu, 24 Apr 2008 10:11:24 GMT

Hi rakhi,

U can try this way

read table <itab>into <wa> with key (f1 =val1 or f1=val2).

reward if helpful

raam

Re: read table

Former Member — Thu, 24 Apr 2008 10:12:51 GMT

Hi,

read will get u only one record at a time.

if u want to check whether the record is existing or not with both the case do like below.


read table itab with key <f1> = 'VAL1'.
if sy-subrc <> 0.
  read table itab with key <f1> = 'VAL2'.
    if sy-subrc = 0.
    "ur logic
    endif.
else.
*ur logic
endif.

rgds,

bharat.

Re: read table

Former Member — Thu, 24 Apr 2008 10:13:48 GMT

i have already tried these stmts ..bt these dont works read table

<itab>into <wa> with key <f1> = val1 or <f1> = val2.

read table <itab>into <wa> with key ( <f1> = val1 or <f1> = val2).

Re: read table

Former Member — Thu, 24 Apr 2008 10:17:05 GMT

hi you cannot use OR in read table.

to perform what you want you can do like tis.

read table <itab>into <wa> with key <f1> .

if sy-subrc <> 0.

read table <itab>into <wa> with key <f1> val2.

endif.

reward if useful.

Re: read table

Former Member — Thu, 24 Apr 2008 10:23:23 GMT

thanks all SOLVED

Re: read table

Former Member — Thu, 24 Apr 2008 10:26:01 GMT

How did u wrote

defenitely it should be or what i have given previously.. if it is wrong please mention how did u wrote

Re: read table

Former Member — Thu, 24 Apr 2008 10:35:44 GMT

read table <itab>into <wa> with key <f1> =val1 or <f1> =val2. does not work

i have used two read stmts ie.

read table <itab>into <wa> with key <f1> =val1.

read table <itab>into <wa> with key <f1> =val2 .

Edited by: rakhi bose on Apr 24, 2008 12:37 PM