topic Re: Read Table.. in Application Development and Automation Discussions

Read Table..

Former Member — Tue, 12 Jun 2007 05:09:59 GMT

Hi,

I waned to use read table as follows :

read table ITAB with key kschl = 'JOCM' kschl = 'JOC1'

kschl = 'JET1'.

But its not possible.

Any alternative??

reagrds,

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:11:59 GMT

Hi,

You can use LOOP AT ..EXIT..ENDLOOP..



LOOP AT ITAB WHERE kschl = 'JOCM' OR kschl = 'JOC1' OR
                                    kschl = 'JET1'.

  EXIT.

ENDLOOP.

IF SY-SUBRC = 0.
** Record found.

ELSE.

** record not found..  
ENDIF.

Thanks,

Naren

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:12:45 GMT

loop at itab where kschl = 'JOCM' OR

kschl = 'JOC1' OR

kschl = 'JET1'.

endloop.

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:13:35 GMT

hi sachin,

try like this,

read table ITAB with key kschl = 'JOCM' 'JOC1' 'JET1'.

regards,

seshu.

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:14:11 GMT

Hi,

We can not use the Read table with more than 1 equality for a Field, instead of this you can use the LOOP statment, if the loop success then use the exit statment to exit from the loop to aviod more loopings.

Regards

Sudheer

Re: Read Table..

gopi_narendra — Tue, 12 Jun 2007 05:14:16 GMT

loop at itab.
if itab-kschl = 'JOCM' or
   itab-kschl = 'JOC1' or
   itab-kschl = 'JET1'.
,,,,,,,,,,,,,,,,,,,,,,,,<write ur code here based on the validation>
endif.
endloop.

Regards

Gopi

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:14:44 GMT

hi,

Use Loop statment ...

i.e,

LOOP AT ITAB WHERE KSCHL = 'JOCM' OR 
                                    KSCHL = 'JOC1'  OR
                                    KSCHL = 'JET1'.
 
 
ENDLOOP.

Re: Read Table..

S0025444845 — Tue, 12 Jun 2007 05:17:35 GMT

hi,

You can use

loop at itab into wa_itab where kschl in( 'JOCM' , 'JOC1' , 'JET1' ).

regards,

sudha

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:18:36 GMT


LOOP AT ITAB  .
if   ITAB-kschl = 'JOCM' OR  ITAB -kschl = 'JOC1' OR   ITAB-kschl = 'JET1'.
Endif .
 
ENDLOOP

Girish

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:20:07 GMT

hi,

try like this

read table ITAB with key kschl = 'JOCM' [and/or] kschl = 'JOC1'

[and/or] kschl = 'JET1'.

loop at itab where kschl = 'JOCM' [or] kschl = 'JOC1'

[or] kschl = 'JET1'.

if sy-subrc eq 0.

write:/10 itab-kschl.

endif.

endloop.

if helpful reward some points.

with regards,

suresh.

Re: Read Table..

former_member186741 — Tue, 12 Jun 2007 05:20:27 GMT

read table ITAB with key kschl = 'JOCM'.

if sy-subrc <> 0.

read table ITAB with key kschl = 'JOC1'.

if sy-subrc <> 0.

read table ITAB with key kschl = 'JET1'.

endif.

Re: Read Table..

Former Member — Tue, 12 Jun 2007 05:24:05 GMT

Hi,

You cannot use 3 or more values for a single field in a read statement. Looping at the table can be some times very expensive if the size of the table is very large. One more alternative is..

read table ITAB with key kschl = 'JOCM'.
if sy-subrc <> 0.
  read table ITAB with key kschl = 'JOC1'.
  if sy-subrc <> 0.
    read table ITAB with key kschl = 'JET1'.
  endif.
endif.

Using Binary search in this case will be very helpful.

Regards,

Richa