topic Re: Strange Problem in sorting an internal table in Application Development and Automation Discussions

Strange Problem in sorting an internal table

Former Member — Thu, 03 May 2012 16:14:28 GMT

Hi Experts,

I am really confused with how the below sorting is working:

Simple statement: SORT ITAB by LIFNR.

1st Scenario:

I have around 13-14 records in my internal table

1.Vendor 2000000029 Company Code 1176 EKORG 1176 Name1 Test

2.Vendor 2000000021 Company Code 1176 EKORG 1176 Name1 test2

3.Vendor 2000000029 Company Code 1176 EKORG 1176 Name1 BLANK

Now when i sort the above results i get the 3rd record at second place where name1 is blank i dnt know why this happened, i was expecting

2nd record then 1st then 3rd

Then i increased the range of my selection it worked , strange how sort mechanism is working?

Should i add more keys here i mean i wanted to know what is wrong here.

Former Member — Thu, 03 May 2012 16:22:29 GMT

If you want to maintain the original order where the sort field has the same value, you have to add the keyword STABLE to the SORT command.

Rob

Former Member — Thu, 03 May 2012 16:27:09 GMT

Ok i will try with stable and look into it.

One more question i have is in debugging i skipped the sort statement on internal table

and since i am displaying the data in ALV i am sorting my output using method Add_SOrt on lfinr.

When i skip the sort statement and let the method do it , its giving correct results.

So is the sort in Add_sort do the stable sorting and not the sort statement??

former_member1716 — Tue, 05 Jan 2016 17:11:41 GMT

Hi B M,

Your code must as given below,

SORT itab STABLE BY lifnr.

Hope this helps.

Regards,

Satish

Former Member — Tue, 05 Jan 2016 18:20:24 GMT

Please note the date of the OP.

Rob

Former Member — Tue, 05 Jan 2016 18:28:14 GMT

Ohh sorry..

Dint notice that