topic Re: performance issue in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761416#M1116430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>move the select out of the loop statement and use for all entries</P><P>Use select * into corresponding fields...</P><P></P><P></P><P>Shruthi</P></BODY></HTML> Thu, 13 Nov 2008 04:26:08 GMT Former Member 2008-11-13T04:26:08Z performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761411#M1116425 <HTML><HEAD></HEAD><BODY><P><STRONG><SPAN __default_attr="red" __jive_macro_name="color">Moderator message: please try to use a more meaningful subject for your questions in future. Thank-you</SPAN></STRONG></P><P></P><P>Hi friends,</P><P></P><P>In loop there is select single statement is there i have to improve the performance of this statement</P><P></P><P>please anybody answer this question.</P><P></P><P></P><P></P><P> LOOP AT i_keytab.</P><P></P><P> SELECT SINGLE</P><P> perio</P><P> belnr</P><P> bukrs</P><P> werks</P><P> kstar</P><P> prctr</P><P> ktgrm</P><P> ww008</P><P> paph4</P><P> ww013</P><P> vbund</P><P> ww012</P><P> vv002</P><P> vv003</P><P> vv004</P><P> vv005</P><P> vv006</P><P> vv007</P><P> vv009</P><P> vv010</P><P> vv011</P><P> vv012</P><P> vv013</P><P> vv014</P><P> vv015</P><P> vv016</P><P> vv017</P><P> vv019</P><P> vv021</P><P> vv022</P><P> vv023</P><P> vv024</P><P> vv025</P><P> vv026</P><P> vv027</P><P> vv028</P><P> vv029</P><P> vv030</P><P> vv031</P><P> vv032</P><P> vv033</P><P> vv034</P><P> vv035</P><P> vv036</P><P> vv037</P><P> vv038</P><P> vv039</P><P> vv040</P><P> vv041</P><P> vv042</P><P> vv043</P><P> vv044</P><P> vv045</P><P> vv046</P><P> vv047</P><P> vv048</P><P> vv049</P><P> vv050</P><P> vv051</P><P> vv052</P><P> vv053</P><P> vv054</P><P> vv055</P><P> vv056</P><P> vv057</P><P> vv058</P><P> vv059</P><P> vv060</P><P> vv061</P><P> vv062</P><P> vv063</P><P> vv064</P><P> vv065</P><P> vv066</P><P> vv067</P><P> vv068</P><P> vv069</P><P> vv070</P><P> vv071</P><P> vv073</P><P> vv074</P><P> vv077</P><P> vv078</P><P> vv079</P><P> vv080</P><P> vv081</P><P> vv082</P><P> vv083</P><P> vv084</P><P> vvz01</P><P> vvz02</P><P> vvz03</P><P> vv090</P><P> vv091</P><P> vv092</P><P> vv093</P><P> vv094</P><P> vv109</P><P> vv110</P><P> vv117</P><P> vv118</P><P> vv111</P><P> vv112</P><P> vv113</P><P> vv114</P><P> vv115</P><P> vv116</P><P> ww001</P><P> ww020</P><P> INTO CORRESPONDING FIELDS OF i_tab</P><P> FROM ce12000</P><P> WHERE paledger = i_keytab-paledger</P><P> AND vrgar = i_keytab-vrgar</P><P> AND versi = i_keytab-versi</P><P> AND perio = i_keytab-perio</P><P> AND paobjnr = i_keytab-paobjnr</P><P> AND pasubnr = i_keytab-pasubnr</P><P> AND belnr = i_keytab-belnr</P><P> AND posnr = i_keytab-posnr.</P><P>endloop.</P><P></P><P>Edited by: Matt on Nov 11, 2008 4:57 PM</P></BODY></HTML> Tue, 11 Nov 2008 15:46:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761411#M1116425 Former Member 2008-11-11T15:46:55Z Re: performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761412#M1116426 <HTML><HEAD></HEAD><BODY><P>Read the ABAP help on FOR ALL ENTRIES. Or use a join.</P></BODY></HTML> Tue, 11 Nov 2008 15:58:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761412#M1116426 matt 2008-11-11T15:58:53Z Re: performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761413#M1116427 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Use FOR ALL ENTRIES</P><P></P><P>Try this one</P><P></P><P></P><P>SELECT </P><P>perio</P><P>belnr</P><P>bukrs</P><P>werks</P><P>kstar</P><P>prctr</P><P>ktgrm</P><P>ww008</P><P>paph4</P><P>ww013</P><P>vbund</P><P>ww012</P><P>vv002</P><P>vv003</P><P>vv004</P><P>vv005</P><P>vv006</P><P>vv007</P><P>vv009</P><P>vv010</P><P>vv011</P><P>vv012</P><P>vv013</P><P>vv014</P><P>vv015</P><P>vv016</P><P>vv017</P><P>vv019</P><P>vv021</P><P>vv022</P><P>vv023</P><P>vv024</P><P>vv025</P><P>vv026</P><P>vv027</P><P>vv028</P><P>vv029</P><P>vv030</P><P>vv031</P><P>vv032</P><P>vv033</P><P>vv034</P><P>vv035</P><P>vv036</P><P>vv037</P><P>vv038</P><P>vv039</P><P>vv040</P><P>vv041</P><P>vv042</P><P>vv043</P><P>vv044</P><P>vv045</P><P>vv046</P><P>vv047</P><P>vv048</P><P>vv049</P><P>vv050</P><P>vv051</P><P>vv052</P><P>vv053</P><P>vv054</P><P>vv055</P><P>vv056</P><P>vv057</P><P>vv058</P><P>vv059</P><P>vv060</P><P>vv061</P><P>vv062</P><P>vv063</P><P>vv064</P><P>vv065</P><P>vv066</P><P>vv067</P><P>vv068</P><P>vv069</P><P>vv070</P><P>vv071</P><P>vv073</P><P>vv074</P><P>vv077</P><P>vv078</P><P>vv079</P><P>vv080</P><P>vv081</P><P>vv082</P><P>vv083</P><P>vv084</P><P>vvz01</P><P>vvz02</P><P>vvz03</P><P>vv090</P><P>vv091</P><P>vv092</P><P>vv093</P><P>vv094</P><P>vv109</P><P>vv110</P><P>vv117</P><P>vv118</P><P>vv111</P><P>vv112</P><P>vv113</P><P>vv114</P><P>vv115</P><P>vv116</P><P>ww001</P><P>ww020</P><P>INTO CORRESPONDING FIELDS OF TABLE i_tab</P><P>FROM ce12000 FOR ALL ENTRIES IN i_keytab</P><P>WHERE paledger = i_keytab-paledger</P><P>AND vrgar = i_keytab-vrgar</P><P>AND versi = i_keytab-versi</P><P>AND perio = i_keytab-perio</P><P>AND paobjnr = i_keytab-paobjnr</P><P>AND pasubnr = i_keytab-pasubnr</P><P>AND belnr = i_keytab-belnr</P><P>AND posnr = i_keytab-posnr.</P><P></P><P></P><P></P><P>Regards</P><P>Bala Krishna.</P></BODY></HTML> Tue, 11 Nov 2008 16:35:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761413#M1116427 former_member585060 2008-11-11T16:35:41Z Re: performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761414#M1116428 <HTML><HEAD></HEAD><BODY><P>Use a 'FOR ALL ENTRIES' statement instead of using a select single within a loop.</P><P></P><P>Regards,</P><P>SAPient.</P></BODY></HTML> Wed, 12 Nov 2008 06:47:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761414#M1116428 Former Member 2008-11-12T06:47:27Z Re: performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761415#M1116429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>U can write the Select Statement out side the loop and "Read" that internal table inside the loop.</P></BODY></HTML> Wed, 12 Nov 2008 11:40:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761415#M1116429 Former Member 2008-11-12T11:40:41Z Re: performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761416#M1116430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>move the select out of the loop statement and use for all entries</P><P>Use select * into corresponding fields...</P><P></P><P></P><P>Shruthi</P></BODY></HTML> Thu, 13 Nov 2008 04:26:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761416#M1116430 Former Member 2008-11-13T04:26:08Z Re: performance issue https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761417#M1116431 <HTML><HEAD></HEAD><BODY><P>Hi Santosh,</P><P>For this issue two things keep in mind.</P><P>1.Never use select statement inside a loop. Use 'FOR ALL ENTERIES' in your select statement outside the loop.</P><P>2. Do not use INTO CORRESPONDING FIELDS in select statement.When you are using all the fields name then no need to use this.Declare all the selected fields in the internal table I_KEYTAB in the same order as in the select statement.</P><P></P><P>your code should be like this.</P><P></P><P>SELECT </P><P>perio</P><P>belnr</P><P>bukrs</P><P>werks</P><P>kstar</P><P>prctr</P><P>ktgrm</P><P>ww008</P><P>paph4</P><P>ww013</P><P>vbund</P><P>ww012</P><P>vv002</P><P>vv003</P><P>vv004</P><P>vv005</P><P>vv006</P><P>vv007</P><P>vv009</P><P>vv010</P><P>vv011</P><P>vv012</P><P>vv013</P><P>vv014</P><P>vv015</P><P>vv016</P><P>vv017</P><P>vv019</P><P>vv021</P><P>vv022</P><P>vv023</P><P>vv024</P><P>vv025</P><P>vv026</P><P>vv027</P><P>vv028</P><P>vv029</P><P>vv030</P><P>vv031</P><P>vv032</P><P>vv033</P><P>vv034</P><P>vv035</P><P>vv036</P><P>vv037</P><P>vv038</P><P>vv039</P><P>vv040</P><P>vv041</P><P>vv042</P><P>vv043</P><P>vv044</P><P>vv045</P><P>vv046</P><P>vv047</P><P>vv048</P><P>vv049</P><P>vv050</P><P>vv051</P><P>vv052</P><P>vv053</P><P>vv054</P><P>vv055</P><P>vv056</P><P>vv057</P><P>vv058</P><P>vv059</P><P>vv060</P><P>vv061</P><P>vv062</P><P>vv063</P><P>vv064</P><P>vv065</P><P>vv066</P><P>vv067</P><P>vv068</P><P>vv069</P><P>vv070</P><P>vv071</P><P>vv073</P><P>vv074</P><P>vv077</P><P>vv078</P><P>vv079</P><P>vv080</P><P>vv081</P><P>vv082</P><P>vv083</P><P>vv084</P><P>vvz01</P><P>vvz02</P><P>vvz03</P><P>vv090</P><P>vv091</P><P>vv092</P><P>vv093</P><P>vv094</P><P>vv109</P><P>vv110</P><P>vv117</P><P>vv118</P><P>vv111</P><P>vv112</P><P>vv113</P><P>vv114</P><P>vv115</P><P>vv116</P><P>ww001</P><P>ww020</P><P>INTO TABLE i_tab</P><P>FROM ce12000</P><P>FOR ALL ENTRIES IN TABLE i_keytab</P><P>WHERE paledger = i_keytab-paledger</P><P>AND vrgar = i_keytab-vrgar</P><P>AND versi = i_keytab-versi</P><P>AND perio = i_keytab-perio</P><P>AND paobjnr = i_keytab-paobjnr</P><P>AND pasubnr = i_keytab-pasubnr</P><P>AND belnr = i_keytab-belnr</P><P>AND posnr = i_keytab-posnr.</P><P></P><P>I hope this would help you.</P><P></P><P>Regards,</P><P>Amit</P></BODY></HTML> Thu, 13 Nov 2008 10:39:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue/m-p/4761417#M1116431 Former Member 2008-11-13T10:39:47Z