Select Gross weight from LIPS

Hi Gurus,

please someone can help me writing a very simple piece of code to extract into a custom field (TOTALEKG) the gross weight of each single SD Delivery Item.

I'm writing like this:

clear TOTALEKG.

select single BRGEW from LIPS into TOTALEKG

where vbeln = CONSEGNA

and POSNR = ............

but I don't know how to loop into all single items. Report should display gross weight for each item.

Thank you very much

Kind Regards

Andrea.