topic Re: read in Application Development and Automation Discussions

read

Former Member — Tue, 08 May 2007 13:39:11 GMT

hi experts,

by using read.how can we read the number which appears several times.ie we have kunnr = 100 ,5 times.how can we read 2nd one by using read.

thanks in advance

Re: read

RichHeilman — Tue, 08 May 2007 13:41:21 GMT

In this case you should use a LOOP with a WHERE.

Loop at itab where kunnr = '100'.

endloop.

Regards,

Rich Heilman

Re: read

Former Member — Tue, 08 May 2007 13:42:15 GMT

Hi,

data:i_kna1 type kna1 occurs 0 with header line.

select * from kna1 into i_kna1 where kunnr = '100'.

write:/ i_kna1-name1,i_kna1-land1.

endselect.

rgds,

bharat.

Re: read

Former Member — Tue, 08 May 2007 13:43:11 GMT

U can't do it, u have to use the LOOP/ENDLOOP statament instead of READ.

LOOP AT ITAB WHERE KUNNR = '100'.

ENDLOOP.

If you want to use the READ statament u have to read all and stop if the field has the value you want to read:

DO.
  READ TABLE ITAB INDEX SY-TABIX.
  IF SY-SUBRC <> 0.
    EXIT.
  ENDIF.
  
  IF ITAB-KUNNR = '100'.

  ENDIF.
ENDDO.

But the performance are very bad for this solution, so LOOP/ENDLOOP is better.

Max

Re: read

Former Member — Tue, 08 May 2007 13:44:44 GMT

Hi,

If you want to use the statment READ, then you need to use the perfect condition in the KEY(Where condition of the READ statment), so the perfect value will come . if you have the same records, then use the LOOP AT statment, if you find the correct record then use the EXIT statment to comeout from the LOOP

Regards

Sudheer

Re: read

Former Member — Tue, 08 May 2007 13:49:19 GMT

Hi Surendra,

Use Loop ......Endloop command for reading data of an internal table.

Loop at itab where kunnr = '100'.

write: i_tab-kunnr.

endloop.

Reward points if helpful.

Regards,

Hemant

Re: read

former_member5350 — Tue, 15 May 2007 11:06:20 GMT

hi, you shouldn't use loop...endloop especially for larger tables.

you could do this one:



* Sort the table so that the same kunnr's are close together

SORT itab BY kunnr.

* Using BINARY SEARCH will make the code very fast

READ TABLE itab INTO w_itab1 WITH KEY kunnr = '100' BINARY SEARCH.
indx = sy-tabix. 

* Now you know where the first entry is, and because you sorted before, all same * entries for kunnr = 100 will be beneath 

WHILE sy-subrc = 0.
indx = indx + 1.
READ TABLE itab INTO w_itab2 INDEX indx.

if w_itab2-kunnr <> w_itab-kunnr.
sy-subrc = 99.
else.
* do something
endif.
ENDWHILE.

Please reward, if helpful

Re: read

Former Member — Tue, 15 May 2007 11:09:48 GMT

hi,

loop at itab where kunnr =100.

read table <itab name> with key kunnr = itab-kunnr.

if sy-subrc = 0.

<statements>.

endif.

endloop.

Reward with points if helpful.