the max value for a key in an ODS

hi,

i want to link 2 ODS (Historic PRICE and PRICE)

the key fields in Historic price ODS are : "material", "vendor" , and a field name "AVN"

I want to create a start routine in order to find the data with the maximum value for the field "AVN" among data with the same key "material, vendor"

Once this value found, i want to send it in the ODS : "PRIX"

But how can i do it ?

should i sort the ODS table ? what is the Abap fonction ?

Than you very much for your help.

Jacques