Hi all,
I doing performance tuning for report .
when i checked in ST05 , the below 2 statements is taking more time eventhough i tried to reduce as much as possible .
SELECT ebeln
EBELP
BEWTP
BWART
budat
MATNR
werks
FROM EKBE INTO TABLE T_EKBE
WHERE BUDAT IN S_EINDT
AND matnr in so_matnr
AND WERKS IN S_WERKS
AND BEWTP EQ 'E'
AND BWART IN ('101','105').
IF NOT t_ekbe[] IS INITIAL.
SELECT ebeln
ebelp
etenr
eindt
menge
wemng
FROM EKET INTO TABLE T_EKET
FOR ALL ENTRIES IN T_EKBE
WHERE EBELN = T_EKBE-EBELN
AND EBELP = T_EKBE-EBELP.
Please suggest how to reduce the time taken.
regards
chetan