Skip to Content
avatar image
Former Member

how to remove duplicate amount in report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 24, 2010 at 10:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2010 at 11:18 AM

    HI,

    after

    append wa_final.

    add

    clear wa_final.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 24, 2010 at 11:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded