Skip to Content
author's profile photo Muralikrishna Peravali
0
Muralikrishna Peravali
Jul 31, 2013 at 08:18 PM

Choosing the highest alpha numeric value in itab and display in variable

31 Views

Hello Gurus,

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

field1

CMR3001127

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,

Muralikrishna Peravali