Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to avoid embedded loops?

Hi All,

I am not an expert and dealing with a performance issue. When a debugged the code I figured that a embedded loop was causing the performance issue and I am looking for analternative way to write that piece of the code.

The code is:

loop at SOURCE_PACKAGE assigning <source_fields>.

loop at i_t_d032 into i_l_d032 where

/bic/zfield1 = <source_fields>-/bic/zfield1 and

/bic/zfield2 = <source_fields>-/bic/zfield2 and

/bic/zfield3 = <source_fields>-/bic/zfield3 and

/bic/zfield4 <= <source_fields>-/bic/zfield4 .

delete SOURCE_PACKAGE.

exit.

endloop.

endloop.

FYI - I_t_d032 has 30 million records.

I apprciate your help.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question