topic Re: help needed with read statment in Application Development and Automation Discussions

help needed with read statment

Former Member — Mon, 19 Mar 2007 22:16:24 GMT

Hi ,

LOOP AT itab.

READ TABLE itab1 WITH KEY num = itab-NO BINARY SEARCH.

IF SY-SUBRC NE 0.

DELETE ITAB.

ENDIF.

ENDLOOP.

EVEN THOUGH THE RECORD EXIST IN ITAB1 FOR ITAB-NO SOMETIMES ITS RETURNING A SY-SUBRC NE 0.

I thought it is because of binarch search and my data in itab1 is not in a sorted order.

does that causes sy-subrc to be non-zero even though the records exist in internal table itab1

Thanks

Re: help needed with read statment

Former Member — Mon, 19 Mar 2007 22:19:43 GMT

Yes, it does. You must sort when you are reading a table with BINARY SEARCH.

Re: help needed with read statment

RichHeilman — Mon, 19 Mar 2007 22:22:15 GMT

Make sure that you sort the internal table being read before the LOOP. Sort it in the order of which you are accessing it. In this case, sort by NUM. If you remove the BINARY SEARCH extension, it will work without sorting, but will be a little slower.

Regards,

RIch Heilman

Re: help needed with read statment

Former Member — Mon, 19 Mar 2007 22:59:27 GMT

Hi,

You need to sort ITAB, please try this.


SORT ITAB.

LOOP AT ITAB.
  READ TABLE ITAB1 WITH KEY NUM = ITAB-NO BINARY SEARCH.

  IF SY-SUBRC NE 0.
    DELETE ITAB.
  ENDIF.

ENDLOOP.

Regards,

Ferry Lianto

Re: help needed with read statment

suresh_datti — Mon, 19 Mar 2007 23:56:19 GMT

a small correction to Ferry's response.

it should be sort itab1 by .NUM.

ie the internal table must be sorted by the key field with which you READ.

~Suresh