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