Skip to Content
0
Former Member
Apr 23, 2013 at 02:04 AM

How to choose in Delete Duplicates from internal table?

663 Views

Now I need to delete Duplicates from internal table,

So at first I sort

than I delete duplicate

Sort itab1 BY Company_Code Asset_No Capital_Date.

DELETE ADJACENT DUPLICATES FROM itab1 COMPARING Company_Code Asset_No Capital_Date

Company_Code Asset_No Capital_Date Remark BC35 1515593 20021225 Helen BC35 1515593 20021225 Common Asset BC35 1515594 20030109 Judy BC35 1515594 20030109 Common Asset

But here comes my problem~If I want to delete the Common Asset in Remark Column,how I let it choose the right one to do it?