topic Re: performance issue in Application Development and Automation Discussions

performance issue

Former Member — Tue, 24 Feb 2009 11:53:00 GMT

Hi Experts,

I want to improve one report performance.

LOOP AT it_data.

SELECT SUM( omeng ) AS omeng

FROM vbbe INTO it_data-op_so_qty

WHERE matnr = it_data-matnr

AND werks = it_data-werks

AND lgort = it_data-lgort

AND ( vbtyp = 'C' OR vbtyp = 'I' )

AND sobkz = ' '.

by using matnr we have to calculate total amounts(OMENG) for each material number which we got values from loop.

How to improve performance for these statements.

Pls help me.

THanks,

Madhu.

Please provide a more informative subject. there are lots of performance issues in the forums.

Moving to the correct forum.

Edited by: Rob Burbank on Feb 24, 2009 9:58 AM

Re: performance issue

Former Member — Tue, 24 Feb 2009 11:55:05 GMT

Hi:

Do like this

SELECT matnr SUM( omeng ) AS omeng

FROM vbbe INTO it_data-op_so_qty

for all entries of it_data

WHERE matnr = it_data-matnr

AND werks = it_data-werks

AND lgort = it_data-lgort

AND ( vbtyp = 'C' OR vbtyp = 'I' )

AND sobkz = ' '

group by matnr

Regards

Shashi

Re: performance issue

jyothi_anagani — Tue, 24 Feb 2009 11:55:08 GMT

Hi,

Dont use select statement in LOOP,

just use select with for all entries of it_data.

Regards,

Jyothi

Re: performance issue

former_member404244 — Tue, 24 Feb 2009 11:58:41 GMT

Hi,

try like this..use one more internal table like it_data1 which is of type it_data

if not it_data[] is initial.

SELECT SUM( omeng ) AS omeng

FROM vbbe INTO it_data1

for all entries in it_data

WHERE matnr = it_data-matnr

AND werks = it_data-werks

AND lgort = it_data-lgort

AND ( vbtyp = 'C' OR vbtyp = 'I' )

AND sobkz = ' '.

endif.

regards,

Nagaraj

Re: performance issue

Former Member — Tue, 24 Feb 2009 11:59:43 GMT

Hi,

Try the below code,

select matnr werks lgort vbtyp from vbbe

INTO it_data-op_so_qty

for all entries in it_data

WHERE matnr = it_data-matnr

AND werks = it_data-werks

AND lgort = it_data-lgort

AND ( vbtyp = 'C' OR vbtyp = 'I' )

AND sobkz = ' '.

if sy-subrc = 0.

loop at in it_data into wa_in it_data.

at end of lgort.

SUM.

Append to other temp ITAB

endloop.

endif.

When preparing final ITAB.

loop at it_data.

Read data from it_data-op_so_qty

endloop.

Regards,

Sunil

Re: performance issue

Former Member — Tue, 24 Feb 2009 12:01:46 GMT

You can use this in case you dont need to perform any operations on the data

SELECT matnr SUM( omeng ) AS omeng
FROM vbbe INTO it_data-op_so_qty
for all entries of it_data
WHERE matnr = it_data-matnr
AND werks = it_data-werks
AND lgort = it_data-lgort
AND ( vbtyp = 'C' OR vbtyp = 'I' )
AND sobkz = ' '

or else

Rather than writing the select statement inside the loop .
Fetch all the records before loop using select statement once.
Then during the loop you can read the table for the data and you can manupulate the data and then update the internal table.

Hope this serves your purpose

Thanks & Regards,

Lalit Mohan Gupta.

Re: performance issue

Former Member — Tue, 24 Feb 2009 12:08:06 GMT

Hi Experts,

By using above code i am getting error like

' The field "VBBE_{MATNR from the select list is missing in the group BY clause. is missing in the group by clause. is missing in the GROUP BY clause is "VBBE}MANDT" .

Thanks,

Kaladhar.

Edited by: madhu on Feb 24, 2009 1:08 PM

Re: performance issue

former_member404244 — Tue, 24 Feb 2009 12:14:51 GMT

Hi,

take a differnt internal table as itab1 which will have only two fields

matnr and omeng.

i belive the internal table it_Data has the folliwng fields.

matnr

werks

lgort

SELECT matnr SUM( omeng ) AS omeng

FROM vbbe INTO it_data1

for all entries of it_data

WHERE matnr = it_data-matnr

AND werks = it_data-werks

AND lgort = it_data-lgort

AND ( vbtyp = 'C' OR vbtyp = 'I' )

AND sobkz = '

Regards,

Nagaraj

Re: performance issue

former_member222860 — Tue, 24 Feb 2009 13:03:17 GMT

Try with this

SELECT matnr SUM( omeng ) AS omeng
FROM vbbe INTO it_data-op_so_qty
for all entries of it_data
WHERE matnr = it_data-matnr
AND werks = it_data-werks
AND lgort = it_data-lgort
AND ( vbtyp = 'C' OR vbtyp = 'I' )
AND sobkz = ' '
group by vbbe~matnr.

Re: performance issue

Former Member — Fri, 06 Mar 2009 09:51:58 GMT

Hi,

dont write select statement in the loop.

check below links for preformance tunning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/performance%2btuning

Regards,

Madhu

Re: performance issue

Former Member — Fri, 06 Mar 2009 10:50:32 GMT

instead using select sum(........) populate all data into internal table and then use control break (at end of ....sum endat)statements in loop and endloop