topic IH08 : Performance issue in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359675#M1838882 <HTML><HEAD></HEAD><BODY><P><BR />Hello Guys,</P><P></P><P>Need your help in below scenario.</P><P></P><P>User has reported performance issue for IH08 and he is entering below details.</P><P>Equipment Selection -&gt; Equipment descriptn = '*AAA*'</P><P>General Data -&gt; Equipment category = 'M'</P><P>Location Data -&gt; Maintenance plant = '9999'</P><P></P><P>I debugged and found that IH08 is fetching data from view <STRONG style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; font-size: 11pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Calibri','sans-serif'; mso-fareast-font-family: Calibri;">V_EQUI</STRONG><SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"> </SPAN>and it is in include MIEQUI20 (Main Program : RIEQUI20)</P><P></P><P><SPAN class="L0S52">FORM </SPAN>select_v_equi_l</P><P><SPAN class="L0S52"></SPAN> </P><P><SPAN class="L0S52"></SPAN></P><P></P><P>&nbsp;&nbsp; <SPAN class="L0S52">SELECT * <SPAN class="L0S52">FROM </SPAN><SPAN class="L0S55">(</SPAN>g_viewname<SPAN class="L0S55">)</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">INTO </SPAN>CORRESPONDING <SPAN class="L0S52">FIELDS </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">TABLE </SPAN>lt_v_equi_iflos<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">FOR </SPAN><SPAN class="L0S52">ALL </SPAN>ENTRIES <SPAN class="L0S52">IN </SPAN>equnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHERE </SPAN>equnr <SPAN class="L0S55">=&nbsp; </SPAN>equnr<SPAN class="L0S70">-</SPAN>low<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqart <SPAN class="L0S52">IN </SPAN>eqart<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ingrp <SPAN class="L0S52">IN </SPAN>ingrp<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>rbnr&nbsp; <SPAN class="L0S52">IN </SPAN>rbnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>proid <SPAN class="L0S52">IN </SPAN>proid<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>daufn <SPAN class="L0S52">IN </SPAN>daufn<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>aufnr <SPAN class="L0S52">IN </SPAN>aufnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>submt <SPAN class="L0S52">IN </SPAN>submt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>erdat <SPAN class="L0S52">IN </SPAN>erdat<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ernam <SPAN class="L0S52">IN </SPAN>ernam<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>aedat <SPAN class="L0S52">IN </SPAN>aedat<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>aenam <SPAN class="L0S52">IN </SPAN>aenam<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>begru <SPAN class="L0S52">IN </SPAN>begru<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>krfkz <SPAN class="L0S52">LIKE </SPAN>krfkz<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kmatn <SPAN class="L0S52">IN </SPAN>kmatn<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>matnr <SPAN class="L0S52">IN </SPAN>matnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>sernr <SPAN class="L0S52">IN </SPAN>sernr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>charge <SPAN class="L0S52">IN </SPAN>charge<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kunde <SPAN class="L0S52">IN </SPAN>kunde<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>anlnr <SPAN class="L0S52">IN </SPAN>anlnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>hequi <SPAN class="L0S52">IN </SPAN>hequi<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>swerk <SPAN class="L0S52">IN </SPAN>swerk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqfnr <SPAN class="L0S52">IN </SPAN>eqfnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>bukrs <SPAN class="L0S52">IN </SPAN>bukrs<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kokrs <SPAN class="L0S52">IN </SPAN>kokrs<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>gsber <SPAN class="L0S52">IN </SPAN>gsber<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>stort <SPAN class="L0S52">IN </SPAN>stort<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqtyp <SPAN class="L0S52">IN </SPAN>eqtyp<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>liznr <SPAN class="L0S52">IN </SPAN>liznr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kostl <SPAN class="L0S52">IN </SPAN>kostl<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>serge <SPAN class="L0S52">IN </SPAN>serge<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>tidnr <SPAN class="L0S52">IN </SPAN>tidnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kund2 <SPAN class="L0S52">IN </SPAN>kund2<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>anlun <SPAN class="L0S52">IN </SPAN>anlun<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>iwerk <SPAN class="L0S52">IN </SPAN>iwerk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>typbz <SPAN class="L0S52">IN </SPAN>typbz<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>beber <SPAN class="L0S52">IN </SPAN>beber<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>mapar <SPAN class="L0S52">IN </SPAN>mapar<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kund3 <SPAN class="L0S52">IN </SPAN>kund3<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>elief <SPAN class="L0S52">IN </SPAN>elief<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>abckz <SPAN class="L0S52">IN </SPAN>abckz<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>answt <SPAN class="L0S52">IN </SPAN>answt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>waers <SPAN class="L0S52">IN </SPAN>waers<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kund1 <SPAN class="L0S52">IN </SPAN>kund1<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>msgrp <SPAN class="L0S52">IN </SPAN>msgrp<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>herst <SPAN class="L0S52">IN </SPAN>herst<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ansdt <SPAN class="L0S52">IN </SPAN>ansdt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>heqnr <SPAN class="L0S52">IN </SPAN>heqnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>tplnr <SPAN class="L0S52">IN </SPAN>strno<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>vkorg <SPAN class="L0S52">IN </SPAN>vkorg<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>vtweg <SPAN class="L0S52">IN </SPAN>vtweg<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>spart <SPAN class="L0S52">IN </SPAN>spart<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>datab <SPAN class="L0S52">IN </SPAN>gr_datab<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>datbi <SPAN class="L0S52">IN </SPAN>gr_datbi<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>herld <SPAN class="L0S52">IN </SPAN>herld<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>baujj <SPAN class="L0S52">IN </SPAN>baujj<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>invnr <SPAN class="L0S52">IN </SPAN>invnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>groes <SPAN class="L0S52">IN </SPAN>groes<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>brgew <SPAN class="L0S52">IN </SPAN>brgew<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>gewei <SPAN class="L0S52">IN </SPAN>gewei<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqktu <SPAN class="L0S52">IN </SPAN>eqktx<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>auldt <SPAN class="L0S52">IN </SPAN>auldt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>inbdt <SPAN class="L0S52">IN </SPAN>inbdt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>werk&nbsp; <SPAN class="L0S52">IN </SPAN>werk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>lager <SPAN class="L0S52">IN </SPAN>lager<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>gewrk <SPAN class="L0S52">IN </SPAN>i_gewrk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ppsid <SPAN class="L0S52">IN </SPAN>i_ppsid<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>uii&nbsp;&nbsp; <SPAN class="L0S52">IN </SPAN>gr_uii<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN><SPAN class="L0S55">(</SPAN>gt_where<SPAN class="L0S55">) </SPAN><SPAN class="L0S55">.</SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN> </P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN> </P><P><SPAN class="L0S52"><SPAN class="L0S55">Out of these many selection parameter , user is using&nbsp; </SPAN></SPAN><STRONG>eqtyp ,</STRONG><STRONG> swerk </STRONG>and<STRONG> eqktu.</STRONG></P><P>Please advice on how to improve performance.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Mayur</P><P></P><P></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN></P></BODY></HTML> Thu, 05 Jun 2014 12:05:35 GMT Former Member 2014-06-05T12:05:35Z IH08 : Performance issue https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359675#M1838882 <HTML><HEAD></HEAD><BODY><P><BR />Hello Guys,</P><P></P><P>Need your help in below scenario.</P><P></P><P>User has reported performance issue for IH08 and he is entering below details.</P><P>Equipment Selection -&gt; Equipment descriptn = '*AAA*'</P><P>General Data -&gt; Equipment category = 'M'</P><P>Location Data -&gt; Maintenance plant = '9999'</P><P></P><P>I debugged and found that IH08 is fetching data from view <STRONG style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; font-size: 11pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Calibri','sans-serif'; mso-fareast-font-family: Calibri;">V_EQUI</STRONG><SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"> </SPAN>and it is in include MIEQUI20 (Main Program : RIEQUI20)</P><P></P><P><SPAN class="L0S52">FORM </SPAN>select_v_equi_l</P><P><SPAN class="L0S52"></SPAN> </P><P><SPAN class="L0S52"></SPAN></P><P></P><P>&nbsp;&nbsp; <SPAN class="L0S52">SELECT * <SPAN class="L0S52">FROM </SPAN><SPAN class="L0S55">(</SPAN>g_viewname<SPAN class="L0S55">)</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">INTO </SPAN>CORRESPONDING <SPAN class="L0S52">FIELDS </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">TABLE </SPAN>lt_v_equi_iflos<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">FOR </SPAN><SPAN class="L0S52">ALL </SPAN>ENTRIES <SPAN class="L0S52">IN </SPAN>equnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHERE </SPAN>equnr <SPAN class="L0S55">=&nbsp; </SPAN>equnr<SPAN class="L0S70">-</SPAN>low<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqart <SPAN class="L0S52">IN </SPAN>eqart<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ingrp <SPAN class="L0S52">IN </SPAN>ingrp<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>rbnr&nbsp; <SPAN class="L0S52">IN </SPAN>rbnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>proid <SPAN class="L0S52">IN </SPAN>proid<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>daufn <SPAN class="L0S52">IN </SPAN>daufn<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>aufnr <SPAN class="L0S52">IN </SPAN>aufnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>submt <SPAN class="L0S52">IN </SPAN>submt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>erdat <SPAN class="L0S52">IN </SPAN>erdat<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ernam <SPAN class="L0S52">IN </SPAN>ernam<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>aedat <SPAN class="L0S52">IN </SPAN>aedat<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>aenam <SPAN class="L0S52">IN </SPAN>aenam<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>begru <SPAN class="L0S52">IN </SPAN>begru<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>krfkz <SPAN class="L0S52">LIKE </SPAN>krfkz<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kmatn <SPAN class="L0S52">IN </SPAN>kmatn<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>matnr <SPAN class="L0S52">IN </SPAN>matnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>sernr <SPAN class="L0S52">IN </SPAN>sernr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>charge <SPAN class="L0S52">IN </SPAN>charge<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kunde <SPAN class="L0S52">IN </SPAN>kunde<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>anlnr <SPAN class="L0S52">IN </SPAN>anlnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>hequi <SPAN class="L0S52">IN </SPAN>hequi<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>swerk <SPAN class="L0S52">IN </SPAN>swerk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqfnr <SPAN class="L0S52">IN </SPAN>eqfnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>bukrs <SPAN class="L0S52">IN </SPAN>bukrs<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kokrs <SPAN class="L0S52">IN </SPAN>kokrs<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>gsber <SPAN class="L0S52">IN </SPAN>gsber<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>stort <SPAN class="L0S52">IN </SPAN>stort<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqtyp <SPAN class="L0S52">IN </SPAN>eqtyp<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>liznr <SPAN class="L0S52">IN </SPAN>liznr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kostl <SPAN class="L0S52">IN </SPAN>kostl<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>serge <SPAN class="L0S52">IN </SPAN>serge<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>tidnr <SPAN class="L0S52">IN </SPAN>tidnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kund2 <SPAN class="L0S52">IN </SPAN>kund2<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>anlun <SPAN class="L0S52">IN </SPAN>anlun<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>iwerk <SPAN class="L0S52">IN </SPAN>iwerk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>typbz <SPAN class="L0S52">IN </SPAN>typbz<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>beber <SPAN class="L0S52">IN </SPAN>beber<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>mapar <SPAN class="L0S52">IN </SPAN>mapar<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kund3 <SPAN class="L0S52">IN </SPAN>kund3<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>elief <SPAN class="L0S52">IN </SPAN>elief<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>abckz <SPAN class="L0S52">IN </SPAN>abckz<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>answt <SPAN class="L0S52">IN </SPAN>answt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>waers <SPAN class="L0S52">IN </SPAN>waers<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>kund1 <SPAN class="L0S52">IN </SPAN>kund1<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>msgrp <SPAN class="L0S52">IN </SPAN>msgrp<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>herst <SPAN class="L0S52">IN </SPAN>herst<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ansdt <SPAN class="L0S52">IN </SPAN>ansdt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>heqnr <SPAN class="L0S52">IN </SPAN>heqnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>tplnr <SPAN class="L0S52">IN </SPAN>strno<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>vkorg <SPAN class="L0S52">IN </SPAN>vkorg<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>vtweg <SPAN class="L0S52">IN </SPAN>vtweg<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>spart <SPAN class="L0S52">IN </SPAN>spart<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>datab <SPAN class="L0S52">IN </SPAN>gr_datab<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>datbi <SPAN class="L0S52">IN </SPAN>gr_datbi<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>herld <SPAN class="L0S52">IN </SPAN>herld<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>baujj <SPAN class="L0S52">IN </SPAN>baujj<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>invnr <SPAN class="L0S52">IN </SPAN>invnr<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>groes <SPAN class="L0S52">IN </SPAN>groes<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>brgew <SPAN class="L0S52">IN </SPAN>brgew<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>gewei <SPAN class="L0S52">IN </SPAN>gewei<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>eqktu <SPAN class="L0S52">IN </SPAN>eqktx<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>auldt <SPAN class="L0S52">IN </SPAN>auldt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>inbdt <SPAN class="L0S52">IN </SPAN>inbdt<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>werk&nbsp; <SPAN class="L0S52">IN </SPAN>werk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>lager <SPAN class="L0S52">IN </SPAN>lager<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>gewrk <SPAN class="L0S52">IN </SPAN>i_gewrk<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>ppsid <SPAN class="L0S52">IN </SPAN>i_ppsid<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN>uii&nbsp;&nbsp; <SPAN class="L0S52">IN </SPAN>gr_uii<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">AND&nbsp;&nbsp; </SPAN><SPAN class="L0S55">(</SPAN>gt_where<SPAN class="L0S55">) </SPAN><SPAN class="L0S55">.</SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN> </P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN> </P><P><SPAN class="L0S52"><SPAN class="L0S55">Out of these many selection parameter , user is using&nbsp; </SPAN></SPAN><STRONG>eqtyp ,</STRONG><STRONG> swerk </STRONG>and<STRONG> eqktu.</STRONG></P><P>Please advice on how to improve performance.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Mayur</P><P></P><P></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN></P><P><SPAN class="L0S52"><SPAN class="L0S55"></SPAN></SPAN></P></BODY></HTML> Thu, 05 Jun 2014 12:05:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359675#M1838882 Former Member 2014-06-05T12:05:35Z Re: IH08 : Performance issue https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359676#M1838883 <HTML><HEAD></HEAD><BODY><P>This message was moderated.</P></BODY></HTML> Thu, 05 Jun 2014 12:19:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359676#M1838883 shah_viraj 2014-06-05T12:19:10Z Re: IH08 : Performance issue https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359677#M1838884 <HTML><HEAD></HEAD><BODY><P>Have a look at below OSS notes:</P><P>782017</P><P>771364</P><P>871622</P><P>385914</P><P>407169</P></BODY></HTML> Thu, 05 Jun 2014 12:34:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359677#M1838884 shah_viraj 2014-06-05T12:34:26Z Re: IH08 : Performance issue https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359678#M1838885 <HTML><HEAD></HEAD><BODY><P>Hi Viraj,</P><P></P><P>I checked above but nothing&nbsp; is useful <SPAN __jive_emoticon_name="sad" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.sap.com/877/images/emoticons/sad.gif"></SPAN> . Do you know any other way to improve performance.</P></BODY></HTML> Fri, 06 Jun 2014 06:55:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359678#M1838885 Former Member 2014-06-06T06:55:31Z Re: IH08 : Performance issue https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359679#M1838886 <HTML><HEAD></HEAD><BODY><P>As it is a standard report, look for and read (even if old) OSS notes (*) on IH08 and performance.</P><P>(check for version and database)</P><P></P><P>Then if none is useful, you could consider changing user, creation of secondary index, some modification to force selection of more criteria or implementation of hints, or upgrade of servers...</P><P></P><P>Regards,</P><P>Raymond</P><P></P><P>(*) Last note seems to be <A href="http://service.sap.com/sap/support/notes/723484" title="723484 - Lists: Selection with status long runtime"><SPAN class="title">723484 - Lists: Selection with status long runtime</SPAN></A>.</P></BODY></HTML> Fri, 06 Jun 2014 07:05:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ih08-performance-issue/m-p/10359679#M1838886 RaymondGiuseppi 2014-06-06T07:05:06Z