Skip to Content
0
Former Member
Oct 18, 2005 at 09:19 AM

SQL - Running slow..

60 Views

Hi,

I've some performance problem in our production system.

It seems that the table EKPO takes long time...

I've tried some index stuff but with no luck.

Any pointers ?

select x_ekpo~ebeln

x_ekpo~lgort

x_ekpo~matnr

from ekpo as x_ekpo

inner join ekko as x_ekko on x_ekkoebeln = x_ekpoebeln

into corresponding fields of table i_ekpo_forbidden

for all entries in i_zpo_filter

where

(where_clause)

AND x_ekko~lifnr = i_zpo_filter-lifnr

AND x_ekpo~werks = v_werks

AND x_ekpo~bstyp = 'F' " Purchasing doc.

AND x_ekpo~loekz = space " Deletion indicator

AND x_ekpo~elikz = space. " Delivery Completed indicator

//Martin