show only one value which is post on latest

[hossain_rajib55]

Greetings!!!

Can anyone give a suggestion to get a solution.

as per selection screen parameter i fetch data which is in internal table. I need to select only one value which is the max (budat) based on matnr  & werks.

only one data exist in a single plant. how can i solve it.

I try to use read statement as well as At new, but desired result not coming.

internal table value:

result:

[Tomas_Buryanek]

SORT or ORDER by MATNR, WERKS, BUDAT DESCENDING.

Then just LOOP at GROUP BY MATNR + WERKS and separate first entries of each GROUP.

But I think this can be done even just by single SELECT MAX no?

[hossain_rajib55]

Thanks for giving your valuable time.