i am creating a report in that i have to fetch gross and net weight of all the items of a delivery order..
for e.g if a DO has single item then there is no issue.but if have a DO number say 10 and if in this DO, 10 items associated with it
Than in report i have to show total weight of all the items of this DO.
i am applying
sELECT vbeln ntgew brgew FROM lips INTO TABLE it_lips
FOR ALL ENTRIES IN it_likp
WHERE vbeln = it_likp-vbeln.
by this i am getting weight of only first item...
how can i get weight of all the items??