Hi All,
I have an internal table containing Sales Order Number, Item Number and Change date.
1001 10 20.01.2009
1001 20 20.01.2009
1001 10 15.01.2009
1001 20 15.01.2009
1002 10 12.01.2009
1002 20 12.01.2009
1002 10 08.01.2009
1002 20 08.01.2009
Now, my requirement is to consider only latest change date for each Sales order.
Rest other lines should be deleted from the table.
So, I need to delete 3rd, 4th, 7th and 8th lines of above table.
How to carry out this task?
Can any one provide me the logic for this requirement?
Your help will be certainly appreciated....
Regards
Pavan