topic Re: *More time to Execute* in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004408#M956674 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For each end every employye there may not be data for all the 20 wage types from lga01 bet01..................lga20 and bet20.</P><P></P><P>in your code it is better to exit the do loop IF wa_p8wage-lgart IS INITIAL rather than looping 20 times even there is no data.</P><P></P><P>Because wage types will be assigned to an employee in the same sequence form 1,2......20</P><P></P><P>if the lga03 is initial there there will not be data for lga04 to lga 20.</P><P></P><P>This may not be the excat reason for slow response time of ur report but may be usefull.</P><P></P><P>look at the below code for the chane i suggested</P><P></P><P>LOOP AT p0008.</P><P>DO 20 TIMES</P><P>VARYING wa_p8wage-lgart FROM p0008-lga01 NEXT p0008-lga02</P><P>VARYING wa_p8wage-betrg FROM p0008-bet01 NEXT p0008-bet02.</P><P>IF wa_p8wage-lgart IS INITIAL.</P><P> exit. " this will exit the do loop</P><P>ENDIF.</P><P></P><P>IF wa_p8wage-lgart IN lgartahm</P><P>AND NOT wa_p8wage IS INITIAL.</P><P>MOVE: 'X' TO p8wage_flag,</P><P>p0008-waers TO wa_p8wage-waers.</P><P>INSERT wa_p8wage INTO TABLE it_p8wage.</P><P>CLEAR wa_p8wage.</P><P>ENDIF.</P><P>ENDDO.</P><P>ENDLOOP.</P></BODY></HTML> Tue, 17 Jun 2008 14:19:04 GMT Former Member 2008-06-17T14:19:04Z *More time to Execute* https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004406#M956672 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The following code is taking more time to execute...</P><P></P><P>Kindly assist..</P><P></P><UL><LI level="1" type="ul"><P>check wagetype selection</P></LI></UL><P> REFRESH it_p8wage.</P><P> CLEAR: it_p8wage, wa_p8wage, p8wage_flag.</P><P> LOOP AT p0008.</P><P> DO 20 TIMES</P><P> VARYING wa_p8wage-lgart FROM p0008-lga01 NEXT p0008-lga02</P><P> VARYING wa_p8wage-betrg FROM p0008-bet01 NEXT p0008-bet02.</P><P> IF wa_p8wage-lgart IN lgartahm</P><P> AND NOT wa_p8wage IS INITIAL.</P><P> MOVE: 'X' TO p8wage_flag,</P><P> p0008-waers TO wa_p8wage-waers.</P><P> INSERT wa_p8wage INTO TABLE it_p8wage.</P><P> CLEAR wa_p8wage.</P><P> ENDIF.</P><P> ENDDO.</P><P> ENDLOOP.</P><UL><LI level="1" type="ul"><P>no wagetype mathing found</P></LI></UL><P> IF p8wage_flag IS INITIAL.</P><P> READ TABLE lgartahm.</P><P> IF sy-subrc EQ 0.</P><P> REJECT.</P><P> ENDIF.</P><P> ENDIF.</P></BODY></HTML> Tue, 17 Jun 2008 14:04:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004406#M956672 Former Member 2008-06-17T14:04:23Z Re: *More time to Execute* https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004407#M956673 <HTML><HEAD></HEAD><BODY><P>set a breakpoint in your code and find out where the bottle neck is.</P></BODY></HTML> Tue, 17 Jun 2008 14:08:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004407#M956673 Former Member 2008-06-17T14:08:02Z Re: *More time to Execute* https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004408#M956674 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For each end every employye there may not be data for all the 20 wage types from lga01 bet01..................lga20 and bet20.</P><P></P><P>in your code it is better to exit the do loop IF wa_p8wage-lgart IS INITIAL rather than looping 20 times even there is no data.</P><P></P><P>Because wage types will be assigned to an employee in the same sequence form 1,2......20</P><P></P><P>if the lga03 is initial there there will not be data for lga04 to lga 20.</P><P></P><P>This may not be the excat reason for slow response time of ur report but may be usefull.</P><P></P><P>look at the below code for the chane i suggested</P><P></P><P>LOOP AT p0008.</P><P>DO 20 TIMES</P><P>VARYING wa_p8wage-lgart FROM p0008-lga01 NEXT p0008-lga02</P><P>VARYING wa_p8wage-betrg FROM p0008-bet01 NEXT p0008-bet02.</P><P>IF wa_p8wage-lgart IS INITIAL.</P><P> exit. " this will exit the do loop</P><P>ENDIF.</P><P></P><P>IF wa_p8wage-lgart IN lgartahm</P><P>AND NOT wa_p8wage IS INITIAL.</P><P>MOVE: 'X' TO p8wage_flag,</P><P>p0008-waers TO wa_p8wage-waers.</P><P>INSERT wa_p8wage INTO TABLE it_p8wage.</P><P>CLEAR wa_p8wage.</P><P>ENDIF.</P><P>ENDDO.</P><P>ENDLOOP.</P></BODY></HTML> Tue, 17 Jun 2008 14:19:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/more-time-to-execute/m-p/4004408#M956674 Former Member 2008-06-17T14:19:04Z