topic Re: Regarding problem on Sorting in Application Development and Automation Discussions

Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 10:58:28 GMT

Hello Experts,

Please clarify this problem

i have create a internal table as below

BEGIN OF i_oia05 OCCURS 0,

vbeln LIKE oia05-vbeln,

schddt LIKE oia05-schddt,

intqty LIKE oia05-intqty,

END OF i_oia05,

i got the entries in the internal table as below,

vbeln schddt intqty

----

0040230354 20080101 515463.864

0040230354 20080101 0.170

0040230354 20080201 0.159

0040230354 20080301 0.170

0040230354 20080401 0.165

0040230354 20080501 0.170

0040230354 20080601 0.166

I have done like this sorting

sort i_oia05 by VBELN.

after the sorting i m getting internal table as below

vbeln schddt intqty

----

0040230354 20080601 0.166

0040230354 20080501 0.170

0040230354 20080401 0.165

0040230354 20080301 0.170

0040230354 20080101 515463.864

0040230354 20080101 0.170

0040230354 20080201 0.159

Can i know the reason y it sort like this, it should have been nor mal asending only know..

Please advise me on this..

thanks,

Suresh

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:04:44 GMT

Hi suresh,

This is kiran.G.A. U better to sort on vbeln and schddt fields.Then ur problem is resolved ok..

Reward points if helpful..

Kiran Kumar.G.A

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:06:13 GMT

Hi kiran,

thanks for the reply, but i wanted to know y it is hapening like that and reason for that..

Thanks suresh

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:06:55 GMT

well you told him to sort by vbeln and so he did.

the VBELN are ascending sorted, you just cant see it since you have just one vbeln.

better implement a second sort criteria. like schddt.

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:08:56 GMT

Hi Florian Kemmer ,

I have few VBELN's , but for example i have given only one.

Re: Regarding problem on Sorting

stephan_herrmann2 — Fri, 04 Apr 2008 11:16:46 GMT

Hi,

I think the question is: why have the rows in the table changed although the table was already sorted by vbeln?

I found nothing special in the help except the addition STABLE in the SORT statement, although I don't understand exact the meaning of it....

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:26:42 GMT

hmmm if you want it in a certain sort order, then you need to sort it that way by using the desired sort criteria.

its the same Problem when you use a select single statement whichs where conditions match more than one record.

you will not be able to forecast which record will be drawn.

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:38:04 GMT

hi,

sort ur table like this.

sort i_oia05 by VBELN schddt intqty.

why it is coming like this means, in ur internal tabel the data is sorted based on vbeln. so there is only one vbeln, then it will sort only vbeln.

Do this and reward points if helpful.

regards,

ravi shankar reddy

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 11:46:56 GMT

hi ravi,

I have few VBELN documents , but for example i have given one

Re: Regarding problem on Sorting

peter_ruiz2 — Fri, 04 Apr 2008 12:25:52 GMT

hi suresh,

this is taken from the ABAP Keyword Documentation explaining about the keyword sort.

The sort process is only stable if you use the STABLE addition. Otherwise, a predefined sequence of fields used to sort a list is not usually retained.

regards,

peter

Re: Regarding problem on Sorting

Former Member — Fri, 04 Apr 2008 12:32:24 GMT

BTW who cares?

this doesnt touch anything and you as well know how to do it correct.

Not every question needs an answer.