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