Skip to Content
0
Former Member
Feb 24, 2009 at 11:53 AM

performance issue

31 Views

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