How to filter repeated qty of item

22 Views

Hi BW Expert

I have a query based on the InfoSet. Since one delivery note item could have more than one invoice items or shipment cost items, the qyt of DN item is repeated.

for example:

DN--

DN item ~~Delivery qty~~ ~~Invoice No.~~ ~~-Invoice Item~~ ---Invoice value

100046-- ~~-0001~~

100
~~900001~~
10 --

26

-

100--

20--

32

-

100--

30--

58

How can I avoid the repeated delivery qty (100) in the report?