topic Re: What is causing bad performance? in Application Development and Automation Discussions

topic Re: What is causing bad performance? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330352#M1919801 <HTML><HEAD></HEAD><BODY><P>Could you try to JOIN LIKP and LIPS in second case, so optimizer may use of actual criteria of both tables to choose the best index.</P><P></P><P>Did you execute a SQL trace (ST05) to analyze access plan ?</P><P></P><P>Regards,</P><P>Raymond</P></BODY></HTML> Mon, 05 Oct 2015 15:03:30 GMT RaymondGiuseppi 2015-10-05T15:03:30Z What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330348#M1919797 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am writing an extract program and it runs very slow when I give a date range. When I just give one date it runs in 2 seconds... a range of dates can take 5-6 minutes. Do you have any ideas of how to improve performance?</P><P></P><P><SPAN class="L0S52">TABLES</SPAN><SPAN class="L0S55">: </SPAN>likp<SPAN class="L0S55">,</SPAN></P><P>         lips<SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S52">DATA</SPAN><SPAN class="L0S55">: </SPAN>lv_filepath   <SPAN class="L0S52">TYPE </SPAN>char100<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S31">* INITIALIZATION *</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S52">INITIALIZATION</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">CONCATENATE</SPAN><SPAN class="L0S55">: </SPAN><SPAN class="L0S33">'/usr/sap' </SPAN>sy<SPAN class="L0S70">-</SPAN>sysid <SPAN class="L0S33">'interfaces/fi' </SPAN><SPAN class="L0S52">INTO </SPAN>lv_filepath <SPAN class="L0S52">SEPARATED </SPAN><SPAN class="L0S52">BY </SPAN><SPAN class="L0S33">'/'</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S31">* SELECTION SCREEN *</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">BLOCK </SPAN>a1 <SPAN class="L0S52">WITH </SPAN><SPAN class="L0S52">FRAME </SPAN><SPAN class="L0S52">TITLE </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">001</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Outbound delivery type</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">002</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECT-OPTIONS </SPAN>s_lfart <SPAN class="L0S52">FOR </SPAN>likp<SPAN class="L0S70">-</SPAN>lfart OBLIGATORY <SPAN class="L0S52">DEFAULT </SPAN><SPAN class="L0S33">'ZNL1'</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Shipping point</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">003</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECT-OPTIONS </SPAN>s_vstel <SPAN class="L0S52">FOR </SPAN>likp<SPAN class="L0S70">-</SPAN>vstel OBLIGATORY<SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Outbound delivery #</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">004</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECT-OPTIONS </SPAN>s_vbeln <SPAN class="L0S52">FOR </SPAN>likp<SPAN class="L0S70">-</SPAN>vbeln<SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Actual PGI date</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">005</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECT-OPTIONS </SPAN>s_wadat <SPAN class="L0S52">FOR </SPAN>likp<SPAN class="L0S70">-</SPAN>wadat_ist OBLIGATORY<SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Material number</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">006</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECT-OPTIONS </SPAN>s_matnr <SPAN class="L0S52">FOR </SPAN>lips<SPAN class="L0S70">-</SPAN>matnr<SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Goods movement status for header (unchangeable)</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">008</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">PARAMETERS </SPAN>p_wbstk <SPAN class="L0S52">TYPE </SPAN>wbstk <SPAN class="L0S52">DEFAULT </SPAN><SPAN class="L0S33">'C' </SPAN>OBLIGATORY MODIF <SPAN class="L0S52">ID </SPAN><SPAN class="L0S32">001</SPAN><SPAN class="L0S55">.</SPAN></P><P>   p_wbstk <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'C'</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Goods movement status for material (unchangeable)</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">009</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">PARAMETERS </SPAN>p_wbsta <SPAN class="L0S52">TYPE </SPAN>wbsta <SPAN class="L0S52">DEFAULT </SPAN><SPAN class="L0S33">'C' </SPAN>OBLIGATORY MODIF <SPAN class="L0S52">ID </SPAN><SPAN class="L0S32">001</SPAN><SPAN class="L0S55">.</SPAN></P><P>   p_wbsta <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'C'</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*File path</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">007</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">PARAMETERS </SPAN>p_file <SPAN class="L0S52">TYPE </SPAN>char100 <SPAN class="L0S52">DEFAULT </SPAN>lv_filepath <SPAN class="L0S52">LOWER </SPAN><SPAN class="L0S52">CASE </SPAN>OBLIGATORY<SPAN class="L0S55">.</SPAN></P><P>   p_file <SPAN class="L0S55">= </SPAN>lv_filepath<SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Job log with detail</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">COMMENT </SPAN><SPAN class="L0S32">2</SPAN><SPAN class="L0S55">(</SPAN><SPAN class="L0S32">48</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">text</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S32">010</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">PARAMETERS </SPAN>p_check <SPAN class="L0S52">AS </SPAN><SPAN class="L0S52">CHECKBOX</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">BLOCK </SPAN>a1<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*Make goods movement status unchangeable</SPAN></P><P> <SPAN class="L0S52">AT </SPAN><SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">OUTPUT</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">LOOP </SPAN><SPAN class="L0S52">AT </SPAN><SPAN class="L0S52">SCREEN</SPAN><SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">IF </SPAN><SPAN class="L0S52">screen</SPAN><SPAN class="L0S70">-</SPAN>group1 <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'001'</SPAN><SPAN class="L0S55">.</SPAN></P><P>       <SPAN class="L0S52">screen</SPAN><SPAN class="L0S70">-</SPAN><SPAN class="L0S52">input </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S32">0</SPAN><SPAN class="L0S55">.</SPAN></P><P>       <SPAN class="L0S52">MODIFY </SPAN><SPAN class="L0S52">SCREEN</SPAN><SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">ENDIF</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">ENDLOOP</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S31">* START OF SELECTION *</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S52">START-OF-SELECTION</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S31">* DATA DECLARATION *</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P>   <SPAN class="L0S52">TYPES</SPAN><SPAN class="L0S55">: </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>ty_matinfo<SPAN class="L0S55">,</SPAN></P><P>            werks     <SPAN class="L0S52">TYPE </SPAN>werks<SPAN class="L0S55">,</SPAN></P><P>            matnr     <SPAN class="L0S52">TYPE </SPAN>matnr<SPAN class="L0S55">,</SPAN></P><P>            comp      <SPAN class="L0S52">TYPE </SPAN>matnr<SPAN class="L0S55">,</SPAN></P><P>            maktx     <SPAN class="L0S52">TYPE </SPAN>maktx<SPAN class="L0S55">, </SPAN><SPAN class="L0S31">"component description</SPAN></P><P>            gamng     <SPAN class="L0S52">TYPE </SPAN>bdmng<SPAN class="L0S55">,</SPAN></P><P>            sto       <SPAN class="L0S52">TYPE </SPAN>lips<SPAN class="L0S70">-</SPAN>vgbel<SPAN class="L0S55">,</SPAN></P><P>            sto_pos   <SPAN class="L0S52">TYPE </SPAN>lips<SPAN class="L0S70">-</SPAN>vgpos<SPAN class="L0S55">,</SPAN></P><P>            deliv     <SPAN class="L0S52">TYPE </SPAN>lips<SPAN class="L0S70">-</SPAN>vbeln<SPAN class="L0S55">,</SPAN></P><P>            deliv_pos <SPAN class="L0S52">TYPE </SPAN>lips<SPAN class="L0S70">-</SPAN>posnr<SPAN class="L0S55">,</SPAN></P><P>            po_num    <SPAN class="L0S52">TYPE </SPAN>lips<SPAN class="L0S70">-</SPAN>vbelv<SPAN class="L0S55">,</SPAN></P><P>            po_pos    <SPAN class="L0S52">TYPE </SPAN>lips<SPAN class="L0S70">-</SPAN>posnv<SPAN class="L0S55">,</SPAN></P><P>            uom       <SPAN class="L0S52">TYPE </SPAN>meins<SPAN class="L0S55">,</SPAN></P><P>          <SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>ty_matinfo<SPAN class="L0S55">.</SPAN></P><P></P><P>   <SPAN class="L0S52">TYPES</SPAN><SPAN class="L0S55">: </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>ty_likp<SPAN class="L0S55">,</SPAN></P><P>            vbeln <SPAN class="L0S52">TYPE </SPAN>vbeln<SPAN class="L0S55">,</SPAN></P><P>            vstel <SPAN class="L0S52">TYPE </SPAN>vstel<SPAN class="L0S55">,</SPAN></P><P>          <SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>ty_likp<SPAN class="L0S55">.</SPAN></P><P></P><P>   <SPAN class="L0S52">TYPES</SPAN><SPAN class="L0S55">: </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>ty_lips<SPAN class="L0S55">,</SPAN></P><P>            vbeln <SPAN class="L0S52">TYPE </SPAN>vbeln<SPAN class="L0S55">,</SPAN></P><P>            posnr <SPAN class="L0S52">TYPE </SPAN>posnr<SPAN class="L0S55">,</SPAN></P><P>            matnr <SPAN class="L0S52">TYPE </SPAN>matnr<SPAN class="L0S55">,</SPAN></P><P>            werks <SPAN class="L0S52">TYPE </SPAN>werks<SPAN class="L0S55">,</SPAN></P><P>            vbelv <SPAN class="L0S52">TYPE </SPAN>vbelv<SPAN class="L0S55">,</SPAN></P><P>            posnv <SPAN class="L0S52">TYPE </SPAN>posnv<SPAN class="L0S55">,</SPAN></P><P>            vgbel <SPAN class="L0S52">TYPE </SPAN>vgbel<SPAN class="L0S55">,</SPAN></P><P>            vgpos <SPAN class="L0S52">TYPE </SPAN>vgpos<SPAN class="L0S55">,</SPAN></P><P>            mtart <SPAN class="L0S52">TYPE </SPAN>mtart<SPAN class="L0S55">,</SPAN></P><P>          <SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>ty_lips<SPAN class="L0S55">.</SPAN></P><P></P><P>   <SPAN class="L0S52">DATA</SPAN><SPAN class="L0S55">: </SPAN>it_matinfo   <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">TABLE </SPAN><SPAN class="L0S52">OF </SPAN>ty_matinfo<SPAN class="L0S55">,</SPAN></P><P>         wa_matinfo   <SPAN class="L0S52">LIKE </SPAN><SPAN class="L0S52">LINE </SPAN><SPAN class="L0S52">OF </SPAN>it_matinfo<SPAN class="L0S55">,</SPAN></P><P>         it_lips      <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">TABLE </SPAN><SPAN class="L0S52">OF </SPAN>ty_lips<SPAN class="L0S55">,</SPAN></P><P>         wa_lips      <SPAN class="L0S52">LIKE </SPAN><SPAN class="L0S52">LINE </SPAN><SPAN class="L0S52">OF </SPAN>it_lips<SPAN class="L0S55">,</SPAN></P><P>         it_likp      <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">TABLE </SPAN><SPAN class="L0S52">OF </SPAN>ty_likp<SPAN class="L0S55">,</SPAN></P><P>         wa_likp      <SPAN class="L0S52">LIKE </SPAN><SPAN class="L0S52">LINE </SPAN><SPAN class="L0S52">OF </SPAN>it_likp<SPAN class="L0S55">,</SPAN></P><P>         lv_wbstk     <SPAN class="L0S52">TYPE </SPAN>bestk<SPAN class="L0S55">,</SPAN></P><P>         lv_wbsta     <SPAN class="L0S52">TYPE </SPAN>wbsta<SPAN class="L0S55">,</SPAN></P><P>         lv_aufnr     <SPAN class="L0S52">TYPE </SPAN>aufnr<SPAN class="L0S55">,</SPAN></P><P>         lv_posnr     <SPAN class="L0S52">TYPE </SPAN>posnr<SPAN class="L0S55">,</SPAN></P><P>         it_component <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">TABLE </SPAN><SPAN class="L0S52">OF </SPAN>bapi_order_component<SPAN class="L0S55">,</SPAN></P><P>         wa_component <SPAN class="L0S52">LIKE </SPAN><SPAN class="L0S52">LINE </SPAN><SPAN class="L0S52">OF </SPAN>it_component<SPAN class="L0S55">,</SPAN></P><P>         lv_quantity  <SPAN class="L0S52">TYPE </SPAN>char25<SPAN class="L0S55">,</SPAN></P><P>         file         <SPAN class="L0S52">TYPE </SPAN>string<SPAN class="L0S55">,</SPAN></P><P>         wa_bapi      <SPAN class="L0S52">TYPE </SPAN>bapi_pp_order_objects<SPAN class="L0S55">,</SPAN></P><P>         lv_count<SPAN class="L0S55">(</SPAN><SPAN class="L0S32">15</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c</SPAN><SPAN class="L0S55">,</SPAN></P><P>         lv_message   <SPAN class="L0S52">TYPE </SPAN>char100<SPAN class="L0S55">,</SPAN></P><P>         <SPAN class="L0S52">count        </SPAN><SPAN class="L0S52">TYPE </SPAN>int4<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P> <SPAN class="L0S31">* SELECT STATEMENTS *</SPAN></P><P> <SPAN class="L0S31">*================================================================================*</SPAN></P><P>   <SPAN class="L0S52">IF </SPAN>s_vbeln <SPAN class="L0S52">IS </SPAN><SPAN class="L0S52">NOT </SPAN><SPAN class="L0S52">INITIAL</SPAN><SPAN class="L0S55">. </SPAN><SPAN class="L0S31">"If user provided deliveries go directly to LIPS</SPAN></P><P>     <SPAN class="L0S52">SELECT </SPAN>vbeln posnr matnr werks vbelv posnv vgbel vgpos mtart <SPAN class="L0S52">FROM </SPAN>lips</P><P>       <SPAN class="L0S52">INTO </SPAN>CORRESPONDING <SPAN class="L0S52">FIELDS </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">TABLE </SPAN>it_lips</P><P>       <SPAN class="L0S52">WHERE </SPAN>vbeln <SPAN class="L0S52">IN </SPAN>s_vbeln</P><P>       <SPAN class="L0S52">AND   </SPAN>matnr <SPAN class="L0S52">IN </SPAN>s_matnr<SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">IF </SPAN>it_lips <SPAN class="L0S52">IS </SPAN><SPAN class="L0S52">INITIAL</SPAN><SPAN class="L0S55">.</SPAN></P><P>       <SPAN class="L0S52">MESSAGE </SPAN><SPAN class="L0S33">'No deliveries found. Please check selection criteria.' </SPAN><SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S33">'I'</SPAN><SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">ENDIF</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">ELSE</SPAN><SPAN class="L0S55">. </SPAN><SPAN class="L0S31">"If no deliveries were provided we need to first go into LIKP</SPAN></P><P>     <SPAN class="L0S52">SELECT </SPAN>vbeln vstel <SPAN class="L0S52">FROM </SPAN>likp</P><P>       <SPAN class="L0S52">INTO </SPAN>CORRESPONDING <SPAN class="L0S52">FIELDS </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">TABLE </SPAN>it_likp</P><P>       <SPAN class="L0S52">WHERE </SPAN>wadat_ist <SPAN class="L0S52">IN </SPAN>s_wadat</P><P>       <SPAN class="L0S52">AND   </SPAN>vstel <SPAN class="L0S52">IN </SPAN>s_vstel</P><P>       <SPAN class="L0S52">AND   </SPAN>lfart <SPAN class="L0S52">IN </SPAN>s_lfart<SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">IF </SPAN>it_likp <SPAN class="L0S52">IS </SPAN><SPAN class="L0S52">INITIAL</SPAN><SPAN class="L0S55">.</SPAN></P><P>       <SPAN class="L0S52">MESSAGE </SPAN><SPAN class="L0S33">'No deliveries found. Please check selection criteria.' </SPAN><SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S33">'I'</SPAN><SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">ELSE</SPAN><SPAN class="L0S55">.</SPAN></P><P>       <SPAN class="L0S52">SELECT </SPAN>vbeln posnr matnr werks vbelv posnv vgbel vgpos mtart <SPAN class="L0S52">FROM </SPAN>lips</P><P>         <SPAN class="L0S52">INTO </SPAN>CORRESPONDING <SPAN class="L0S52">FIELDS </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">TABLE </SPAN>it_lips</P><P>         <SPAN class="L0S52">FOR </SPAN><SPAN class="L0S52">ALL </SPAN>ENTRIES <SPAN class="L0S52">IN </SPAN>it_likp</P><P>         <SPAN class="L0S52">WHERE </SPAN>vbeln <SPAN class="L0S55">= </SPAN>it_likp<SPAN class="L0S70">-</SPAN>vbeln</P><P>         <SPAN class="L0S52">AND   </SPAN>matnr <SPAN class="L0S52">IN </SPAN>s_matnr</P><P>         <SPAN class="L0S52">AND   </SPAN>mtart <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'KMAT'</SPAN><SPAN class="L0S55">. </SPAN><SPAN class="L0S31">"Only want KMAT records</SPAN></P><P>       <SPAN class="L0S52">IF </SPAN>it_lips <SPAN class="L0S52">IS </SPAN><SPAN class="L0S52">INITIAL</SPAN><SPAN class="L0S55">.</SPAN></P><P>         <SPAN class="L0S52">MESSAGE </SPAN><SPAN class="L0S33">'No deliveries found. Please check selection criteria.' </SPAN><SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S33">'I'</SPAN><SPAN class="L0S55">.</SPAN></P><P>       <SPAN class="L0S52">ENDIF</SPAN><SPAN class="L0S55">.</SPAN></P><P>     <SPAN class="L0S52">ENDIF</SPAN><SPAN class="L0S55">.</SPAN></P><P>   <SPAN class="L0S52">ENDIF</SPAN><SPAN class="L0S55">.</SPAN></P></BODY></HTML> Fri, 18 Sep 2015 19:45:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330348#M1919797 former_member447950 2015-09-18T19:45:34Z Re: What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330349#M1919798 <HTML><HEAD></HEAD><BODY><P>Range of dates in large tables usually have bad performance, considering tha date is stored as char in the DB.</P><P>How many records are in your LIKP table and how many are retrieved with a range of dates?</P><P>Would it be possible to include some key or index field in your selection?</P><P></P><P>Regards</P></BODY></HTML> Fri, 18 Sep 2015 19:58:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330349#M1919798 Former Member 2015-09-18T19:58:05Z Re: What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330350#M1919799 <HTML><HEAD></HEAD><BODY><P>Hi Luis - That is what I assumed. Unfortunately, the only key field in LIKP is delivery which is why we are selecting from LIKP anyways. Many entries are stored in LIKP and many are retrieved within a date which is what I assumed was causing performance issues.</P></BODY></HTML> Fri, 18 Sep 2015 20:02:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330350#M1919799 former_member447950 2015-09-18T20:02:10Z Re: What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330351#M1919800 <HTML><HEAD></HEAD><BODY><P>Hi Jess,</P><P></P><P>Create View for LIKP Table, and use it instead of LIKP table you will get the more performance.</P><P></P><P>Regards,</P><P>Sivanadh</P></BODY></HTML> Mon, 05 Oct 2015 14:54:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330351#M1919800 former_member210963 2015-10-05T14:54:12Z Re: What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330352#M1919801 <HTML><HEAD></HEAD><BODY><P>Could you try to JOIN LIKP and LIPS in second case, so optimizer may use of actual criteria of both tables to choose the best index.</P><P></P><P>Did you execute a SQL trace (ST05) to analyze access plan ?</P><P></P><P>Regards,</P><P>Raymond</P></BODY></HTML> Mon, 05 Oct 2015 15:03:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330352#M1919801 RaymondGiuseppi 2015-10-05T15:03:30Z Re: What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330353#M1919802 <HTML><HEAD></HEAD><BODY><P>Hi Jess,</P><P></P><P>do you have any active LIKP secondary index for fields LFART, WADAT_ISt or VSTEL? For example in our systems we have a Z index for fields MANDT / LFART. Any of them might be helpful.</P><P></P><P>Regards,</P><P></P><P>Klaus</P><P></P><P><BR /> </P></BODY></HTML> Tue, 06 Oct 2015 04:48:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330353#M1919802 Former Member 2015-10-06T04:48:04Z Re: What is causing bad performance? https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330354#M1919803 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Thank you all for the responses.</P><P>I ran a SQL trace and found the select query on LIKP was taking a while. It is because delivery number is the only key.</P><P>We have elected to run the program in the background. It takes ~5 minutes each time but is not a major issue. I appreciate all of your advice. If I run into this again, I will try other options. </P></BODY></HTML> Wed, 07 Oct 2015 14:48:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-causing-bad-performance/m-p/11330354#M1919803 former_member447950 2015-10-07T14:48:09Z