I have database Z-table
ZPRCTR ZGJAHR ZMONAT RPT_LOC
0000000330 2006 01 0330
0000000330 2006 02 0330
0000000330 2006 03 0330
0000000330 2006 04 0330
If I give ZPRCTR = '0000000330'
then I need to get the record
0000000330 2006 04 0330 which is latest one...because of ZMONAT = '04'.
Right now by using select single or select up to 1 rows
i am getting the oldest record.
0000000330 2006 <b>01</b> 0330
How can I achieve this ?