topic optimize a query in Application Development and Automation Discussions

optimize a query

Former Member — Fri, 02 Nov 2007 06:28:35 GMT

if not lt_sources_invalid[] is initial.

clear: ls_source.

loop at lt_sources_invalid into ls_source.

clear: ls_pto_source.

move-corresponding ls_source to ls_pto_source.

append ls_pto_source to pto_sources_tab_invalid.

clear: ls_source.

endloop.

endif. " invalid sources

Re: optimize a query

Former Member — Fri, 02 Nov 2007 06:32:08 GMT

if lt_sources_invalid and pto_sources_tab_invalid tables having the same structure then you can use directly..

pto_sources_tab_invalid[] = lt_sources_invalid[].

Re: optimize a query

Former Member — Fri, 02 Nov 2007 06:36:27 GMT

it looks ok.....

probably you don't need to mention the clear statement in the loop as the loop will take care of clearing the work area and then populate it with the contents of the next row. may be it makes more sense to use the clear statement after the loop execution is over.

if not lt_sources_invalid[] is initial.

clear: ls_source.

loop at lt_sources_invalid into ls_source.

clear: ls_pto_source.

move-corresponding ls_source to ls_pto_source.

append ls_pto_source to pto_sources_tab_invalid.

endloop.

clear: ls_source.

endif. " invalid sources