Skip to Content
0
Mar 20, 2009 at 07:27 AM

Select Query is Taking lot of Time.

762 Views

Hi All,

I have written a select query in my program which is taking a lot of time to execute because of which the report is taking a significant amount of time to show the output.

The Select Query is as follows :

Its fine in Development , but taking lot of time in Quality Testing.

SELECT KOKRS GJAHR KSTAR WRTTP OBJNR PERIO WTGBTR

FROM COEP

INTO TABLE WT_COEP

FOR ALL ENTRIES IN WT_AUFK

WHERE KOKRS EQ 'UB00'

AND KSTAR IN P_KSTAR

AND WRTTP EQ '04'

AND OBJNR EQ WT_AUFK-OBJNR

AND BEKNZ <> 'A'.

Thanks in Advance

Bhavika