topic Re: Order mismatch in selected data using Select query in Application Development and Automation Discussions

Order mismatch in selected data using Select query

Phalani2 — Wed, 25 Nov 2009 05:41:25 GMT

Hello Experts,

We are upgrading from 4.6C to ECC6. I came across a select query on a custom table, which gives different order of data from 4.6C to ECC6. Data (no. of records) is same in both the servers but order is different. Table doesn't have indexes in either 4.6C or ECC6. What would be the cause for order change?

Further, in 4,6C, ECC6 and data bases order of the data is totally different. Select query have some conditions in where clause with select options, but in both the cases (4.6C and ECC6) I am not passing any data from the selection screen so am getting entire data from the data base.

Thanks in advance

Phalani

Re: Order mismatch in selected data using Select query

Former Member — Wed, 25 Nov 2009 05:47:32 GMT

As per my understanding , the order of records that you get , need not necessary be same each time you fetch from table and that's why we sort as per our requirement.

So, there is no issue , if number of records are same.

Re: Order mismatch in selected data using Select query

former_member194669 — Wed, 25 Nov 2009 05:49:13 GMT

My guess will be please combare all the field domain in 4.6c and ECC for that custom table, may be any domain got changed ?

a®

Re: Order mismatch in selected data using Select query

Phalani2 — Wed, 25 Nov 2009 06:01:25 GMT

Thanks for the response Harsha,

you are right, as long as the data is same there is no change in the result, but I wanted to know the exact reason for the order mismatch. There is are no key words I used to sort the content. Any other clue?

Thanks

Phalani

Re: Order mismatch in selected data using Select query

Phalani2 — Wed, 25 Nov 2009 07:06:59 GMT

Thanks for your response a®s

I compared all the field domains and even program where I have select query written in 4.6c and ECC and found no difference.

Any another clue.

Thanks

Phalani

Re: Order mismatch in selected data using Select query

Phalani2 — Fri, 18 Dec 2009 15:26:11 GMT

From the SAP service market place I found that

1. Unless we use SORT or ORDER BY clause the order of the data is not in our control.

2. In 4.6C, two same select queries never give the result in the same order, if the primary key contains character fields.

Thanks for your help.

Phalani

Re: Order mismatch in selected data using Select query

Former Member — Wed, 12 Mar 2014 12:41:10 GMT

hello PLaz,

could you please share that link you found in sap service market place. because i am facing the same issue during our upgrade.

Thanks,

Munvar Basha.