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.