topic Re: sort in Application Development and Automation Discussions

sort

Former Member — Thu, 16 Aug 2007 09:20:03 GMT

hi ,

is there a way to unsort the sorted internal table,

Thanks

Re: sort

Former Member — Thu, 16 Aug 2007 09:23:24 GMT

ofcourse there is Keyword SORT

SORT Itab by fieldname.

Regards,

Reema.

Re: sort

Former Member — Thu, 16 Aug 2007 09:24:45 GMT

first identify u'r criteria for unsort, then apply SORT statement with that criteria.

cheers

S@meer

Re: sort

gopi_narendra — Thu, 16 Aug 2007 09:25:03 GMT

Simple just take out the SORT statement from your program is a logical answer. right??

Regards

Gopi

Re: sort

Former Member — Thu, 16 Aug 2007 09:25:47 GMT

hi,

make the copy of original internal table and then sort the copied one and use. in this manner u will be able to access both sorted and unsorted internal table.

reward points.

regards

Abhilasha

Re: sort

Former Member — Thu, 16 Aug 2007 09:26:04 GMT

hI Anu

suppose if u r internal table is sorted on first field , if u want to it as a unsorted then the internal table on another field......

is this is ur req?

reward points to all helpful answers

kiran.M

Re: sort

Former Member — Thu, 16 Aug 2007 09:26:39 GMT

Why would you want to do that?.. why cant you just not sort it..?

explain the scenario..

Aparna

Re: sort

Former Member — Thu, 16 Aug 2007 09:27:53 GMT

Hi,

There is no specific keyword for unsort. Only thing you can do is sort with a field different from the field which you dont need to be sorted.

For ex if you have fields X and Y and you have already sorted with X, then try sorting with Y if you dont want the field X to be sorted.

This will change the order of the sort.

But as such you cant get back unsorted data.

Regards,

Yogesh

Re: sort

Former Member — Thu, 16 Aug 2007 09:31:24 GMT

I am reading a file from application server into an internal table and sorting the internal table to calculate the opening balances and closing balances and paassing the file to standard SAP program.

The requirement here is to maintain the file as it is from the application server.

but for calculating using AT NEW account i need to sort it.

Thanks,

Aruna.

Re: sort

Former Member — Thu, 16 Aug 2007 09:34:39 GMT

make a copy of the table before sorting..

then loop throught the sorted table after calculating the balances and modify the unsorted table wherever necessary..!!

Regadrs,

Aparna

Re: sort

Former Member — Thu, 16 Aug 2007 09:37:04 GMT

Hi ,

one option is , create one index field in that internal table and put a counter on it , after doing all ur calculations based that counter sort out ur final internal table.

data: n type sy-index.

n = 0.

loop at itab1.

move-corresponding itab to itab1.

itab-count = n.

n = n + 1.

endloop.

do something.

and sort based on that count.

Regards

Peram