Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance problem code ABAP

Hi, I have a program, which has performance problems. Ztmm_0208 table contains millions of rows, to which I have access to all. I need to find a way to improve performance. I don't know many tecnicals (parallel cursor, etc),I'm new to this, can you help with this code? thanks in advance

FORM f_repro_ser.

* recovery series that have not yet guarantee date

   SELECT *

     FROM ztmm_0208

     INTO TABLE i_reproc.                               

   LOOP AT i_reproc INTO w_reproc.

* Recover Object Number

     SELECT SINGLE objnr FROM equi

       INTO w_equi_reproc

       WHERE equnr EQ w_reproc-equnr.

     IF sy-subrc EQ 0.

* Recovery of warranty start date

       SELECT SINGLE gwldt

         FROM bgmkobj

         INTO w_bgmkobj

         WHERE j_objnr EQ w_equi_reproc-objnr AND

               gaart EQ dc_4 AND

               gwldt NE space.

       IF sy-subrc EQ 0.

          CLEAR w_envio.

          w_envio-sernr = p_w_objk_sernr.

          w_envio-gwldt = p_w_bgmkobj_gwldt.

          APPEND w_envio TO i_envio.

          CLEAR w_noserie.

          w_noserie-sernr p_w_objk_sernr.

          w_noserie-equnr p_w_objk_equnr.

          APPEND w_noserie TO i_noserie.

       ENDIF.

     ENDIF.

   ENDLOOP.

Former Member
Not what you were looking for? View more on this topic or Ask a question