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 AssetBut 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?