Skip to Content
0
Former Member
Dec 31, 2007 at 08:51 AM

Select statement ...........

134 Views

Hi Experts,

Loop at itab.

SELECT sum( lfimg ) INTO itab-lfimg FROM lips

WHERE vgbel = itab-vbeln AND vgpos = itab-posnr AND

pstyv = 'TAN' AND werks = 'HIP' AND lgort = 'BSR'.

Modify itab.

Endloop.

This query is take long time to execute becaz of i lips table vgbel and vgpos ot an primary key. Pl. guide what to do?

Yusuf