https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278581#M1988528 <P>I hope you have checked that the internal table used in the FOR ALL ENTRIES clause is not empty.</P><P>Do you have the possibility to either</P><UL> <LI>Replace the FOR ALL ENTRIES with a JOIN or a SUBQUERY with the query that previously extracted the list of delivery numbers (Enhance the DataSource extractor?)</LI><LI>Split the list of items into smaller packages and either execute them in sequence (better use of memory) or in parallel (Select data in a RFC FM called DESTINATION 'NONE').</LI><LI>Check with basis for performance of FOR ALL ENTRIES (use of hints in emergency situations) such as system parameters : rsdb/max_blocking_factor, rsdb/max_in_blocking_factor, rsdb/prefer_join, rsdb/prefer_union_all.</LI><LI>If this is a transformation rule, define the required fields as attributes of some delivery item InfoObject and don't map those at loading.</LI></UL> Mon, 19 Oct 2020 04:29:09 GMT RaymondGiuseppi 2020-10-19T04:29:09Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278578#M1988525 <P>SELECT deliv_numb deliv_item doc_number s_ord_item /bic/zsdkonnr /bic/zsdkonit<BR /> act_gi_dte material sales_unit base_uom doc_currcy<BR /> dlv_qty /bic/zdlvqty /bic/zdlvval item_del<BR />* &amp;0001 &gt; F5645557 CHG0015956<BR /> ship_date<BR />* &amp;0001 &gt; F5645557 CHG0015956<BR /> FROM (l_tabname)<BR /> INTO CORRESPONDING FIELDS OF TABLE l_t_deliveries<BR /> FOR ALL ENTRIES IN l_t_deliveries_keys<BR /> WHERE doc_number = l_t_deliveries_keys-doc_number<BR /> AND s_ord_item = l_t_deliveries_keys-s_ord_item.<BR /><BR /> INSERT LINES OF l_t_deliveries INTO TABLE g_st_deliveries_vbeln.</P> Sun, 18 Oct 2020 16:38:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278578#M1988525 anuja_s 2020-10-18T16:38:58Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278579#M1988526 <P>Hi for quick response on question related to code. please use Code button in the editor...</P> Sun, 18 Oct 2020 17:27:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278579#M1988526 Abinathsiva 2020-10-18T17:27:52Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278580#M1988527 <UL> </UL><P>You leave us guessing on what the problem is and how to fix it.</P><UL><LI>Why replace it and replace it with what?</LI><LI>There are several possibilities to 'replace' it, those can be based on an SQL alone but also a solution in SQL as well as ABAP (e.g. select more and reduce in ABAP)</LI><LI>Also it depends on your current ABAP version (e.g. select from l_t_deliveries and join with l_tabname)</LI></UL> Mon, 19 Oct 2020 04:17:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278580#M1988527 michael_piesche 2020-10-19T04:17:15Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278581#M1988528 <P>I hope you have checked that the internal table used in the FOR ALL ENTRIES clause is not empty.</P><P>Do you have the possibility to either</P><UL> <LI>Replace the FOR ALL ENTRIES with a JOIN or a SUBQUERY with the query that previously extracted the list of delivery numbers (Enhance the DataSource extractor?)</LI><LI>Split the list of items into smaller packages and either execute them in sequence (better use of memory) or in parallel (Select data in a RFC FM called DESTINATION 'NONE').</LI><LI>Check with basis for performance of FOR ALL ENTRIES (use of hints in emergency situations) such as system parameters : rsdb/max_blocking_factor, rsdb/max_in_blocking_factor, rsdb/prefer_join, rsdb/prefer_union_all.</LI><LI>If this is a transformation rule, define the required fields as attributes of some delivery item InfoObject and don't map those at loading.</LI></UL> Mon, 19 Oct 2020 04:29:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278581#M1988528 RaymondGiuseppi 2020-10-19T04:29:09Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278582#M1988529 <P>How did you populatethe table l_t_deliveries_key ?</P> Mon, 19 Oct 2020 05:29:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-replace-select-for-all-entries-statement-in-the-below-code-in-ecc/m-p/12278582#M1988529 FredericGirod 2020-10-19T05:29:15Z