topic Re: Internal table Modification in Application Development and Automation Discussions

Internal table Modification

Former Member — Thu, 07 Aug 2008 14:08:50 GMT

Hello experts,

If have an Internal table it_test having data.

romm_no name

53 Anil

40 Michael

40 Alex

40 Matheaw

40 Ringo

67 Lex

I want to sort the name of room 40 without sorting the room_no.

e.i.

i want the data in the order

romm_no name

53 Anil

40 Alex

40 Matheaw

40 Michael

40 Ringo

67 Lex

how do i acheive that?

Thanks in advance.

Re: Internal table Modification

Former Member — Thu, 07 Aug 2008 14:15:04 GMT

Hi,

there is no direct sort command to achieve this type of result. Though you can do it and fill your internal table in the loop.

Transfer the data of romm_no = 40 to another internal table and sort it by name.

loop at first_table where romm_no <> 40.

fill new table here

at last.

loop at second_table ( which onatin record of room number 40 )

fill new table here for sorted records of room number 40

endloop.

endat.

endloop.

thanks,

Kamesh

Re: Internal table Modification

rainer_hbenthal — Thu, 07 Aug 2008 14:15:56 GMT

Add a column containing the sequence the rooms will show, the sort by the sequence and then by the name

1 53 Anil

2 40 Michael

2 40 Alex

2 40 Matheaw

2 40 Ringo

3 67 Lex

Re: Internal table Modification

Former Member — Thu, 07 Aug 2008 14:17:55 GMT

You need to have 2 tables of same type.

Suppose 1st table is IT_TAB and the sorted data will be in IT_SORT.

it_sort = it_tab.

sort it_sort by name.

Loop at it_tab.

it_sort-room = it_tab-room.

modify it_tab.

endloop.

This will keep the room no. as it is but name will be sorted.

Hope this helps.

Re: Internal table Modification

ingo_barschow — Thu, 07 Aug 2008 14:20:29 GMT

Hi,

I would suggest to change the table type description, splitting roomnumber and prename in two fields. Afterwards it will me much easier to sort the table by several fields.

Re: Internal table Modification

Former Member — Fri, 08 Aug 2008 07:19:14 GMT

Thanks you all. My issue got resolve

Re: Internal table Modification

Former Member — Fri, 08 Aug 2008 14:46:57 GMT

Hi,

Could you please tell what did you do finally to resolve your issue?

Thanks,

Kamesh Bathla