Kindly suggest a better way (consider performance) of coding this

Hi ,

This statement block will be accessed by a transaction for several times.

If possible, I want this block to be very effiicient in terms of performance.

Do you have any suggestions on how to re-code this, so that this will gain a better performance?

      LOOP AT tb_spers_obj2 INTO wa_spers_obj3.
        SELECT SINGLE uname FROM agr_users INTO lv_uname
          WHERE agr_name = wa_spers_obj3-object_id.

        ls_app_table-fieldvalue = wa_spers_obj3-fieldvalue.
        ls_app_table-uname = lv_uname.
        APPEND ls_app_table TO it_app_table.
      ENDLOOP.

Thanks and regards!

Reymar