Skip to Content
0
Feb 03, 2009 at 05:04 AM

performance issue

32 Views

Moderator message: please use more informative subject in future

how can i improve the performance of the following select statement

g_viewname = VIAUF_AFVC

SELECT * FROM (g_viewname)

INTO CORRESPONDING FIELDS OF TABLE lt_task

FOR ALL ENTRIES IN lt_aufrueck

WHERE aufnr = lt_aufrueck-aufnr

AND rueck = lt_aufrueck-rueck

AND auart IN auart_o

AND iphas IN r_iphas

AND arbid IN arbid_o

AND werks IN werks_o

AND equnr IN equnr_o

AND tplnr IN strno_o

AND larnt IN larnt_o.

Edited by: Matt on Feb 3, 2009 9:56 AM