topic nested loop in Application Development and Automation Discussions

nested loop

Former Member — Sat, 10 Mar 2007 04:38:17 GMT

Hi Experts,

This is an performance issue.I received a ticket to resolve it.but the code is using nested loop in each loop it is using the database from one table.how to resolve it .

thanks

Re: nested loop

Former Member — Sat, 10 Mar 2007 04:42:26 GMT

hi,

you can use the statement for all entries for selection of data later you can read that table with specific key so that you can reduce the triggering of the data base more times.

hope it will help u.

Re: nested loop

amit_khare — Sat, 10 Mar 2007 04:44:06 GMT

Hi,

1. Use Inner Joins

2. INTO TABLE

3. No nested loop

4. FOR ALL ENTRIES

5. Use as much of the key as possible

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Regards,

Amit

Reward all helpful replies.

Re: nested loop

former_member194669 — Sat, 10 Mar 2007 04:45:55 GMT

Hi,

You can make initial select using " for all entries" then within the loop, if you seach for only one record then use "read" other wise loop inside loop.

if you want mre specific reply please paste the code

aRs