Skip to Content
0
Former Member
Feb 23, 2010 at 01:29 PM

SELECT take more time ONLY in one environment

19 Views

Hi

I have the following code in a fct module

DATA : BEGIN OF ls_hu_info,

werks TYPE werks_d,

lgnum TYPE lgnum,

matnr TYPE matnr,

charg TYPE charg_d,

lgort TYPE lgort_d,

lfart TYPE lfart,

bwlvs TYPE bwlvs,

bwart TYPE bwart,

statu TYPE zqm_qa_status.

DATA : END OF ls_hu_info.

SELECT SINGLE dwerks algnum dmatnr dcharg d~lgort

blfart ebwlvs e~bwart

INTO CORRESPONDING FIELDS OF ls_hu_info

FROM vekp AS a

INNER JOIN vepo AS d ON dvenum EQ avenum

INNER JOIN likp AS b ON bvbeln EQ dvbeln

INNER JOIN lips AS e ON evbeln EQ dvbeln AND

eposnr EQ dposnr

WHERE a~exidv EQ p_exidv.

My problem is that in one of my SAP environmment, this select statement take more than 5 minutes

In the other environments, the result is instantanous (1 seconde)

How is it possible ?

Thanks