We are having one custom table and am picking the data from that table into itab, itab contains the values like below
field1 field2 field3 field4 field5 field6
A071458 Retail 0005002694 1200 Y010 1200000000
CMR1202576 CMR 0005002694 1100 Y001 1100000000
CMR1706299 CMR 0005002694 1100 Y001 1100000000
CMR3001127 CMR 0005002694 1100 Y001 1100000000
CMR3001991 CMR 0005002694 1100 Y001 1100000000
L018879 Retail 0005002694 1100 Y003 1100000000
from the above internal table i have to fetch the field1 starting with CMR30 and i have to pass the highest value from them into one variable. Means
CMR3001991 from these i have to find highest value and pass it to another variable. As i am fresher am not able to find the solution.
Please light me on this.
Thanks and Regards,