HOW TO FINE TUNE QUERY

[Former Member]

Hi,

I am having below two queries. 2nd query is taking more time & it gives time out error. Can anybody tell how to fine tune below query. Thanks.

• 1st Query.

SELECT EKET_{EBELN EKET}EBELP EKET_{ETENR EKET}EINDT

EKET_{MENGE EKET}WEMNG

INTO TABLE I_EKET

FROM EKET

WHERE EKET_{MENGE <> EKET}WEMNG

AND

EKET~EINDT IN S_EINDT.

DESCRIBE TABLE I_EKET LINES V_ZLINES.

IF V_ZLINES > 0.

• 2nd Query.

SELECT EKKO_{EBELN EKKO}AEDAT EKKO_{LIFNR EKPO}EBELP EKPO~MATNR

EKPO~WERKS

EKPO_{LOEKZ EKPO}ELIKZ EKPO_{TXZ01 EKPO}NETPR LFA1~NAME1

INTO TABLE I_PODEL

FROM EKKO

INNER JOIN EKPO ON EKKO_{EBELN = EKPO}EBELN

INNER JOIN LFA1 ON EKKO_{LIFNR = LFA1}LIFNR

FOR ALL ENTRIES IN I_EKET

WHERE EKKO~EBELN = I_EKET-EBELN AND

EKPO~EBELP = I_EKET-EBELP AND

EKPO~MATNR IN S_MATNR AND

EKPO~WERKS IN S_WERKS AND

EKPO~WERKS NE 'W001' AND

EKKO~EKORG = P_EKORG AND

EKKO~LIFNR IN S_LIFNR AND

EKKO~LOEKZ NE 'X' AND

EKPO~LOEKZ NE 'S' AND

EKPO~ELIKZ NE 'X' AND

EKPO~LOEKZ NE 'L' AND

EKKO~AEDAT IN S_AEDAT.

ELSE.

WRITE 'No POs found for the selection criteria!'.

ENDIF.

[VijayKonam]

Not the right forum to ask this question.

VJ