hi,
i have a requirement that i have to improve the performance of report . this the code below.
SELECT A~VBELN A~BSTNK A~AUDAT A~KUNNR B~MATNR B~WERKS B~KWMENG FROM VBAK AS A INNER JOIN VBAP AS B ON A~VBELN = B~VBELN INTO CORRESPONDING FIELDS OF TABLE ITEKKo WHERE B~MATKL IN S_MATKL AND A~AUDAT IN S_BEDAT AND A~VKORG IN S_VKORG AND A~VTWEG IN S_VTWEG AND B~WERKS IN S_WERKS . LOOP AT ITEKKO. SELECT SINGLE MVGR1 MVGR5 FROM MVKE INTO (ITEKKO-MATKL, ITEKKO-MVGR5) WHERE MATNR = ITEKKO-MATNR. SELECT SINGLE INCO2 FROM VBKD INTO ITEKKO-NAME1 WHERe VBELN = ITEKKO-VBELN. SELECT SINGLE LAND1 FROM KNA1 INTO CCODE WHERE KUNNR = ITEKKO-KUNNR. SELECT SINGLE LANDX50 FROM T005T INTO ITEKKO-CNAME WHERE LAND1 = CCODE AND SPRAS = 'E'. MODIFY ITEKKO. ENDLOOP.
SELECT C~BLDAT D~VBELN D~POSNR D~VGBEL D~MATKL D~MFRGR D~LFIMG D~MEINS D~MATNR FROM LIKP AS C INNER JOIN LIPS AS D ON C~VBELN = D~VBELN INNER JOIN VBAK AS A ON D~VGBEL = A~VBELN INTO CORRESPONDING FIELDS OF TABLE IT_LIPS WHERE A~AUDAT IN S_BEDAT ORDER BY D~VGBEL D~MFRGR. LOOP AT IT_LIPS. SELECT SINGLE MVGR5 FROM MVKE INTO IT_LIPS-MVGR5 WHERE MATNR = IT_LIPS-MATNR. MODIFY IT_LIPS. ENDLOOP.
it is taking very long time when the loops r executing.
can anybody please help.