i just want to get the Condition record number for the most recent date(DATAB) from the table a073

[aravindcsebe]

SELECT MAX( DATAB ) AS recent_date, knumh from a073

INTO TABLE @data(it_a073) GROUP BY knumh ORDER BY knumh ASCENDING.

I have tried the above code but it brings all the dates.

SELECT MAX( DATAB ) AS recent_date, matnr from a073

INTO TABLE @data(it_a073) GROUP BY matnr ORDER BY matnr ASCENDING.

when I tried the above code it brings the max date but not allowing me to get the condition record number(knumh).

pls help me.