topic Re: Alternative performance code for AFKO and AKRU tables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181794#M1713182 <HTML><HEAD></HEAD><BODY><P>Hi Ravi,</P><P></P><P>Why don't you try using FOR ALL ENTRIES on AUFNR??</P></BODY></HTML> Mon, 14 Jan 2013 14:02:06 GMT former_member491621 2013-01-14T14:02:06Z Alternative performance code for AFKO and AKRU tables https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181793#M1713181 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can any one suggest me the better alternative performance for fallowing code.</P><P></P><P>Taking too much time for execution.</P><P></P><P> types:&nbsp; <SPAN class="L0S52">BEGIN <SPAN class="L0S52">OF </SPAN>y_afru,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rueck <SPAN class="L0S52">TYPE </SPAN>co_rueck,&nbsp;&nbsp; <SPAN class="L0S31">"confirmation number for the operation</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rmzhl <SPAN class="L0S52">TYPE </SPAN>co_rmzhl,&nbsp;&nbsp; <SPAN class="L0S31">"Confirmation counter</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; budat <SPAN class="L0S52">TYPE </SPAN>buchdatum,&nbsp; <SPAN class="L0S31">"Posting date</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arbid <SPAN class="L0S52">TYPE </SPAN>objektid,&nbsp;&nbsp; <SPAN class="L0S31">"Object ID</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; werks <SPAN class="L0S52">TYPE </SPAN>werks_d,&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Plant</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gmnga <SPAN class="L0S52">TYPE </SPAN>ru_gmnga,&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Previously confirmed yield in order unit of measure</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lmnga <SPAN class="L0S52">TYPE </SPAN>ru_lmnga,&nbsp;&nbsp; <SPAN class="L0S31">"Yield to Be Confirmed</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmnga <SPAN class="L0S52">TYPE </SPAN>ru_xmnga,&nbsp;&nbsp; <SPAN class="L0S31">"Scrap to Be Confirmed</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aufnr <SPAN class="L0S52">TYPE </SPAN>aufnr,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Order number</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stzhl <SPAN class="L0S52">TYPE </SPAN>co_stzhl,&nbsp;&nbsp; <SPAN class="L0S31">"Confirmation counter of cancelled confirmation</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>y_afru,</SPAN></P><P></P><P> data: wt_afru <SPAN class="L0S52">TYPE <SPAN class="L0S52">HASHED </SPAN><SPAN class="L0S52">TABLE </SPAN><SPAN class="L0S52">of </SPAN>y_afru<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">with </SPAN><SPAN class="L0S52">unique </SPAN><SPAN class="L0S52">key </SPAN>RUECK RMZHL,<BR /></SPAN></P><P>&nbsp;&nbsp; <SPAN class="L0S52">SELECTION-SCREEN <SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">BLOCK </SPAN>b1 <SPAN class="L0S52">WITH </SPAN><SPAN class="L0S52">FRAME </SPAN><SPAN class="L0S52">TITLE </SPAN>text-011.<BR /><BR />PARAMETERS: p_werks <SPAN class="L0S52">TYPE </SPAN>werks_d OBLIGATORY.<BR /><BR /><SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">BLOCK </SPAN>b1.</SPAN></P><P><SPAN class="L0S52"></SPAN> </P><P>Oldcode:</P><P>&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">SELECT <SPAN class="L0S52">DISTINCT</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; afru~rueck&nbsp;&nbsp;&nbsp;&nbsp; "confirmation number for the operation</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; afru~rmzhl&nbsp;&nbsp;&nbsp;&nbsp; "Confirmation counter</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; budat&nbsp;&nbsp;&nbsp;&nbsp; "Posting date</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arbid&nbsp;&nbsp;&nbsp;&nbsp; "Object ID</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; werks&nbsp;&nbsp;&nbsp;&nbsp; "Plant</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gmnga&nbsp;&nbsp;&nbsp;&nbsp; "Previously confirmed yield in order unit of measure</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lmnga&nbsp;&nbsp;&nbsp;&nbsp; "Yield to Be Confirmed</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmnga&nbsp;&nbsp;&nbsp;&nbsp; "Scrap to Be Confirmed</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; afru~aufnr&nbsp;&nbsp;&nbsp;&nbsp; "Order number</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stzhl&nbsp;&nbsp;&nbsp;&nbsp; "Cancellled confrimation counter</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM afru</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INNER JOIN afko</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; on afru~AUFNR = AFKO~AUFNR</SPAN><BR /><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTO TABLE wt_afru</SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S31"></SPAN><SPAN class="L0S31">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE WERKS EQ P_WERKS.</SPAN></SPAN></P><P></P><P>Newcode:Where i have improved some performance still need to improve performance</P><P>&nbsp; <SPAN class="L0S52">SELECT<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; afru~rueck&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"confirmation number for the operation</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; afru~rmzhl&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Confirmation counter</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; budat&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Posting date</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arbid&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Object ID</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; werks&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Plant</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gmnga&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Previously confirmed yield in order unit of measure</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lmnga&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Yield to Be Confirmed</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmnga&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Scrap to Be Confirmed</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; afru~aufnr&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Order number</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stzhl&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S31">"Cancellled confrimation counter</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">FROM </SPAN>afru<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">INTO </SPAN><SPAN class="L0S52">TABLE </SPAN>&nbsp;&nbsp;&nbsp; wt_afru</SPAN></P><P><SPAN class="L0S52"></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S52">WHERE </SPAN>EXISTS ( <SPAN class="L0S52">SELECT </SPAN>* <SPAN class="L0S52">FROM </SPAN>AFKO <SPAN class="L0S52">WHERE </SPAN>AUFNR = AFKO~AUFNR )<BR /><SPAN class="L0S52">and&nbsp; </SPAN>WERKS <SPAN class="L0S52">EQ </SPAN>P_WERKS<BR />&nbsp;&nbsp;&nbsp;&nbsp; %_HINTS ORACLE <SPAN class="L0S33">'INDEX("AFRU" "AFRU~004")'</SPAN>.</SPAN></P><P><SPAN class="L0S52"></SPAN> </P><P>&nbsp;&nbsp; <SPAN class="L0S52">IF sy-subrc <SPAN class="L0S52">EQ </SPAN><SPAN class="L0S32">0.</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">SORT </SPAN>p_wt_afru[] <SPAN class="L0S52">BY </SPAN>aufnr rmzhl.<BR />&nbsp;&nbsp; <SPAN class="L0S52">delete </SPAN><SPAN class="L0S52">adjacent </SPAN><SPAN class="L0S52">duplicates </SPAN><SPAN class="L0S52">from&nbsp; </SPAN>p_wt_afru.<BR />&nbsp; ENDIF.</SPAN></P><P><SPAN class="L0S52"></SPAN> </P><P><SPAN class="L0S52">Still i need to improve the performance of my program for this block of code.</SPAN></P><P><SPAN class="L0S52"></SPAN> </P><P><SPAN class="L0S52">any help from anyone.</SPAN></P><P><SPAN class="L0S52"></SPAN> </P><P><SPAN class="L0S52">Thanks</SPAN></P><P><SPAN class="L0S52">Raviteja</SPAN></P><P></P></BODY></HTML> Mon, 14 Jan 2013 13:54:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181793#M1713181 Former Member 2013-01-14T13:54:48Z Re: Alternative performance code for AFKO and AKRU tables https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181794#M1713182 <HTML><HEAD></HEAD><BODY><P>Hi Ravi,</P><P></P><P>Why don't you try using FOR ALL ENTRIES on AUFNR??</P></BODY></HTML> Mon, 14 Jan 2013 14:02:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181794#M1713182 former_member491621 2013-01-14T14:02:06Z Re: Alternative performance code for AFKO and AKRU tables https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181795#M1713183 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>take 2&nbsp; internal tables and use for all entries, it will work.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 14 Jan 2013 14:02:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-performance-code-for-afko-and-akru-tables/m-p/9181795#M1713183 former_member391265 2013-01-14T14:02:41Z