PERFORMANCE ISSUE

[Former Member]

Hi all,

Here i have some performance issue .

In my program they have used select statement with for all entries form table MSEG based on field EBELN AND EBELP FROM EKPO.

Those filed not not in primary in MSEG.

The problem is it is going to dump in quality system due to heavy data.

Can any body suggest me so that i can filter the the thing

with regards

anand

[Former Member]

Hi,

Could you paste that select query here.

Reward if helpful.

Regards.

[Former Member]

data: begin of imseg occurs 0,

mblnr like mseg-mblnr,

mjahr like mseg-mjahr,

menge like mseg-menge,

ERFMG LIKE MSEG-ERFMG,

erfme like mseg-erfme,

ebeln like mseg-ebeln,

ebelp like mseg-ebelp,

end of imseg.

select mblnr

mjahr

menge

erfmg

erfme

ebeln

ebelp

from mseg into table imseg

for all entries in iekpo

where ebeln = iekpo-ebeln and

ebelp = iekpo-ebelp.

[Former Member]

just send ur select query here.....i will check and let u know

[Former Member]

Hi,

Kindly re-frame your question / give your code here.

jey

[Former Member]

data: begin of imseg occurs 0,

mblnr like mseg-mblnr,

mjahr like mseg-mjahr,

menge like mseg-menge,

erfmg like mseg-erfmg,

erfme like mseg-erfme,

ebeln like mseg-ebeln,

ebelp like mseg-ebelp,

end of imseg.

select mblnr

mjahr

menge

erfmg

erfme

ebeln

ebelp

from mseg into table imseg

for all entries in iekpo

where ebeln = iekpo-ebeln and

ebelp = iekpo-ebelp.