topic Re: Sorting Internal table by Color Code in Application Development and Automation Discussions

Sorting Internal table by Color Code

Former Member — Wed, 19 Apr 2006 12:43:27 GMT

Hi Friends

I need a help in sorting the internal table by color_code.

I have an Internal Table with the field Color_code.

The Color_code Contains HTML Color values, like

1.'#FF0000' - Red

2.'#FFFF00' - Yellow

3.'#008000' - Green

I need to sort the color code by red,yellow than green

*Sort I_PARTS by color_code (red, yellow then green boxes)

Pls let me know how to do this.

Regards

karthik

Re: Sorting Internal table by Color Code

naimesh_patel — Wed, 19 Apr 2006 12:45:54 GMT

hello,

Take one field sort in itab.

Modify itab like,

itab-sort = 1 where color = '#FF0000'

itab-sort = 2 where color = '#FFFF00'

itab-sort = 3 where color = '#008000'

Sort Itab.

Regards,

Naimesh

Re: Sorting Internal table by Color Code

Former Member — Wed, 19 Apr 2006 12:48:04 GMT

As the color code values will NOT help you SORTING the way you want, have an additional field and assign appropriate values and SORT by that field.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Sorting Internal table by Color Code

RichHeilman — Wed, 19 Apr 2006 12:49:47 GMT

You will need to use a special sort field here. Have a field in your internal to hold the sequence that you desire.

case itab-color .
when '#FF00000'.
itab-sortseq = 1.
 

when '#FFFF000'.
itab-sortseq = 2.
 

when '#008000'.
itab-sortseq = 3.
 
endcase.

modify itab.

.....

sort itab ascending by sortseq.

Regards,

RIch Heilman