We have a requirement where we need to access the highest Partner number present in table BUT000. But along with the partner number we would also like to check on another particular field called BU_GROUP (which determines the grouping of the partner). So we need to retreive the highest partner number for a particular group from table BUT000.
Can you help in writing a most effective query on selecting the Max partner number (Field - PARTNER) along with a particular grouping (Field - BU_GROUP).
Any help in this regard will be highly appreciated.
Warm Regards, Vinay