Skip to Content
0
Former Member
Sep 07, 2007 at 06:19 AM

internal table deletion of records

16 Views

Hi SDN's

I have some records in a internal table like this

----------------------------------------------------------------------------
|BUKRS|ANLN1       |ANLN2|GJAHR|KANSW          |KNAFA			   |
|---------------------------------------------------------------------------
|SAP1 |000000100003|0000 |2000 |      99000.00 |       2010.10-            |
|SAP1 |000000100003|0000 |2001 |      99200.00 |       4022.24-            |
|SAP1 |000000100006|0000 |1999 |      90000.00 |        909.09-            |
|SAP1 |000000100008|0000 |1999 |      99000.00 |       1000.00-            |
|SAP1 |000000100008|0000 |2000 |      99000.00 |       2000.00-            |
|SAP1 |000000100008|0000 |2001 |      99000.00 |       3000.00-            |
|SAP1 |000000100010|0000 |2000 |     560000.00 |       5656.57-            |
|SAP1 |000000100010|0000 |2001 |     560000.00 |      11313.14-            |
|SAP1 |000000100013|0000 |1998 |      99000.00 |        990.00             |
|SAP1 |000000100013|0000 |1999 |      99000.00 |         85.16-            |
|SAP1 |000000100013|0000 |2004 | 1000085619.82 |   11364609.37-            |
----------------------------------------------------------------------------

I need the records being sorted on the GJAHR and need the latest record only ie i needed like this

----------------------------------------------------------------------------
|BUKRS|ANLN1       |ANLN2|GJAHR|KANSW          |KNAFA			   |
|---------------------------------------------------------------------------
|SAP1 |000000100003|0000 |2001 |      99200.00 |       4022.24-            |
|SAP1 |000000100006|0000 |1999 |      90000.00 |        909.09-            |
|SAP1 |000000100008|0000 |2001 |      99000.00 |       3000.00-            |
|SAP1 |000000100010|0000 |2001 |     560000.00 |      11313.14-            |
|SAP1 |000000100013|0000 |2004 | 1000085619.82 |   11364609.37-            |
----------------------------------------------------------------------------

Regards

Pratyusha