topic Re: About select options. in Application Development and Automation Discussions

About select options.

Former Member — Fri, 08 Jul 2011 18:33:07 GMT

Hi there;

Is there any chance to sort an internal table (it_result) comparing an internal range table (s_ktorr) ?

Example :

Select-Options on screen

s_ktorr =

DESK9A56KS

DESK9AU634

DESK9A53JD

DESK9A7878

Then when I select those tkorr from e071 table, the final result is :

SELECT trkorr obj_name object

FROM e071

INTO CORRESPONDING FIELDS OF TABLE it_result

WHERE trkorr IN s_ktorr.

it_result =

DESK9A7878 OBJ1

DESK9A7878 OBJ2

DESK9A56KS OBJ1

DESK9A56KS OBJ2

DESK9A56KS OBJ3

DESK9A53JD OBJ1

DESK9AU634 OBJ1

DESK9AU634 OBJ2

As you can see the final result is out of order comparing the s_ktorr order on the screen..

My question is.. Is there any syntax or some SORT method to do not lose the original sort?

Thanks in advance.

Re: About select options.

Sandra_Rossi — Fri, 08 Jul 2011 19:05:50 GMT

Hi,

SQL do not sort data, except if you use ORDER BY. But it is not advised with a SAP system (because of its scalable architecture, i.e. to do load balancing on several application servers), prefer to use SORT statement after the SELECT.

Sandra

Re: About select options.

Former Member — Fri, 08 Jul 2011 19:07:48 GMT

No, but it the arrangement of data must match the original input list, one could loop at the input ranges table, then loop at the result looking for those values and increment a counter defined in the results table, then resort by that counter no.

for example something like this (not very efficient, to be sure):

data: lv_counter(4) type n value 1.

loop at ranges table.

loop at result table where <fieldname> = ranges-low.

result-counter = lv_counter.

lv_counter = lv_counter + 1.

endloop.

sort result table by counter.

But, I don't understand why this would be important....a simple sort statement, as Sandra noted, would be desirable.

Re: About select options.

Former Member — Fri, 08 Jul 2011 20:09:42 GMT

A mugs game

What if you have ranges or patterns or exclusions?

Rob

Re: About select options.

Clemenss — Fri, 08 Jul 2011 21:51:13 GMT

Ups! What is such thing as an (exclude) pattern?

Regards,

Clemens

Re: About select options.

SuhaSaha — Fri, 08 Jul 2011 21:55:55 GMT


Ups! What is such thing as an (exclude) pattern?

If the HIGH column is initial then exclude pattern is the 'NP' OPTION