Skip to Content
0
Aug 14, 2009 at 10:36 AM

performance of select statement

57 Views

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