how to remove duplicate amount in report

[Former Member]

Hello,

I created PO wise details and my layout is

VENDOR CODE

VENDOR NAME

PURCHASE DOC.

PURCHASE AMOUNT

PURCHASE DATE

INVOICE NUMBER

INVOICE DATE

INVOICE AMOUNT

PAYMENT NUMBER

PAYMENT DATE

PAYMENT AMOUNT

In my output payment amount is repeting for same payment number and payment date

i used ON CHANGE OF wa_final1-augbl OR wa_final1-augdt OR wa_final1-dmbtr1.

MOVE wa_final1-dmbtr1 TO wa_final-dmbtr1. "IR ACC Amt - Pay Clear Amt

endon.

in the loop,so wat can i do further inorder to avoide duplicate

thanx in advance

[Former Member]

Hi,

You can sort your itab by PAYMENT NUMBER, PAYMENT DATE, PAYMENT AMOUNT.

Delete adjacent duplicates from itab comparing PAYMENT NUMBER, PAYMENT DATE, PAYMENT AMOUNT.

Regards,

Md Ziauddin.

[Former Member]

HI,

after

append wa_final.

add

clear wa_final.

[Former Member]

Hi,

I hope below of code help for your solution .

sort your itab by pay_no, pay_date, pay_amy.

Delete adjacent duplicates from t_final comparing pay_no, pay_date, pay_amy.

Thanks

Best Regards

I.Muthukumar.