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