topic Re: PERFORMANCE ISSUE in Application Development and Automation Discussions

PERFORMANCE ISSUE

Former Member — Tue, 18 Mar 2008 06:11:14 GMT

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

Re: PERFORMANCE ISSUE

Former Member — Tue, 18 Mar 2008 06:16:40 GMT

Hi,

Could you paste that select query here.

Reward if helpful.

Regards.

Re: PERFORMANCE ISSUE

Former Member — Tue, 18 Mar 2008 06:23:41 GMT

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

Re: PERFORMANCE ISSUE

Former Member — Tue, 18 Mar 2008 06:29:09 GMT

Hi,

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

jey

Re: PERFORMANCE ISSUE

Former Member — Tue, 18 Mar 2008 06:46:07 GMT

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.

Re: PERFORMANCE ISSUE

Former Member — Tue, 18 Mar 2008 06:50:31 GMT

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.