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