topic simple itab question in Application Development and Automation Discussions

simple itab question

Former Member — Wed, 23 May 2007 19:52:23 GMT

i have two itabs

ITAB1 with NAME field.

ITAB2 with NAME and MARKS fields.

if name in itab2 matches name in itab1 , i should assign marks 100 to that name.

i thought of coding this way.

loop at itab1.

loop at itab2 where name = itab1-name.

itab2-marks = 100.

endloop.

modify itab2.

endloop.

is it a right way of using modify command.

is there any way i can improve performance by sort method.

Former Member — Wed, 23 May 2007 19:54:11 GMT

sort itab1 by name

sort itab2 by name.

loop at itab2.

read table itab1 with key name = itab2-name binary search.

if sy-subrc eq 0.

itab2-marks = 100.

<<update itab2.

endif.

endloop.

Former Member — Wed, 23 May 2007 19:54:25 GMT

HI,

check this..

loop at itab1.

loop at itab2 where name = itab1-name.

itab2-marks = 100.

<b>modify itab2 transporting marks.</b>

endloop.

Regards

SAB

ferry_lianto — Wed, 23 May 2007 19:55:06 GMT

Hi,

Please try this.


LOOP AT ITAB2.
  READ TABLE ITAB1 WITH KEY NAME = ITAB2-NAME.
  IF SY-SUBRC = 0.
    ITAB2-MARKS = 100.
    MODIFY ITAB2.
  ENDIF.
ENDLOOP.

Regards,

Ferry Lianto

Former Member — Wed, 23 May 2007 19:58:12 GMT

thanks friends.