performance tuning

[Former Member]

HI,

   PLEASE ANYONE SUGGEST TO AVOID THIS PERFORMANCE RELATED ISSUES

"LOOP AT record.

    CHECK record-sys_equnr IS INITIAL.

    SELECT SINGLE hequi

    INTO record-hequi

    FROM equz WHERE equnr EQ record-equnr

    AND datbi = '99991231'.

    MODIFY record.

    CLEAR record.

  ENDLOOP.   "

Moderator message: please do more research before posting.

Message was edited by: Thomas Zloch

[former_member195270]

data lv_index type i.

  LOOP AT record where sys_equnr is initial.

   lv_index = sy-tabix.

    SELECT SINGLE hequi

    INTO record-hequi

    FROM equz WHERE equnr EQ record-equnr

    AND datbi = '99991231'.

    MODIFY record from record index lv_index.

  ENDLOOP.