topic Re: how to sort a sorted internal table . in Application Development and Automation Discussions

how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 18:25:18 GMT

There is an internal table which is sorted

sort IS_DLV_DELNOTE-it_gen[] by material.

then its giving an error as

@8O@ Global Definitions "IS_DLV_DELNOTE-IT_GEN[]" is a table of the kind SORTED. You cannot use the SORT command with this type of table.

how to use the command..?

Re: how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 18:28:51 GMT

By default when you define a sorted table you are already telling the table to sort by certain fields. When you execute the sort command on it via different fields, you are going to conflict w/ the original definition.

If this table will be sorted via different fields, I suggest you use a normal header table instead. However, a pre-defined sorted table will save you some time and CPU cycles.

Edit: To clarify - sorted tables will save you time and CPU cycles during read, but actually increase CPU usage during inserts (because it has to insert the data in a sorted manner)

Edited by: Kevin Lin on Jul 2, 2008 8:31 PM

Re: how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 18:29:42 GMT

Hello,

The table that you're using was defined like sorted table and it will be always sorted. You cannot sort it!

But if you want to sort it change its declaration to be a standard table.

Another option is to change the table keys. In this case you need to check if you'll get problems with UNIQUE keys.

Regards.

Re: how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 18:32:57 GMT

Actually IS_DLV_DELNOTE-it_gen is assighned to standard stucture which is sorted and I can change the sorted field.

Re: how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 19:18:52 GMT

Sorry I cant sort the table..

is there any alternative for sort statement..?

Re: how to sort a sorted internal table .

former_member1007904 — Wed, 02 Jul 2008 19:21:12 GMT

declare a standard temp internal table, move the data from ur sorted to standard and do the sort.

Re: how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 19:35:09 GMT

I have created the standard table

then moved the sorted table to standard internal table

then sorted the standard internal table.

then I want to move to sort table again..but I am unable to do it.

Re: how to sort a sorted internal table .

Former Member — Wed, 02 Jul 2008 20:26:32 GMT

You can't append data to sorted table. Use INSERT statement.