topic Re: selection order in SELECT in Application Development and Automation Discussions

selection order in SELECT

Former Member — Thu, 20 Nov 2008 08:34:15 GMT

Hello ppl,

I have a select-option field on my selection screen.

I am selecting data from a database table based on the entries from this select-option.

The problem is that in the select-option, the user can enter the data in any order.

For eg.

9000 to 9500,

8452,

8245,

8375, etc.

The SELECT statement selects entries in the internal table in ascending order ALWAYS.

eg.

8254,

8375,

8452,

9000

9500, etc.

Please help me find a solution to sort this internal table according to the order of entries on the selection screen.

Thanks.

Re: selection order in SELECT

SuhaSaha — Thu, 20 Nov 2008 08:38:14 GMT

Hello David,

Can i ask u sth. WHY DO U NEED TO DO THIS ?????

BR,

Suhas

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 08:42:33 GMT

Hello Suhas,

Sorry, I can't disclose the actual requirement.

But, I hope you have understood the requirement.

Please let me know if you have any solution to achieve this.

Thanks.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 08:54:25 GMT

have an internal table with two fields.

one for the entries in select option and the next field for storing the order.

value order

8024 1

450 2

500 3

once the select query fills the internal table , refer the previous internal table for order .

copy the order field to ur new internal table for respective values

sort the table based on the newly added field.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 08:57:27 GMT

i have a BIG doubt???

Do u have more than one SELECT-OPTION for an SINGLE FIELD?

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 08:58:30 GMT

Hi.. You cannot do this within the select statement itself. But you can try this.


select field1 field2....
from database_table
into internal_table_1
where field = select-option.

loop at select-option.

read table internal_Table_1 into work_area with key field = select-option-low.
if sy-subrc = 0.
append work_area to internal_Table_2.
endif.
endloop.

The internal_Table_2 should be of same structure as of internal_Table_1.

The contents of internal_table_2 will have the entries as you asked.....

Regards.

Re: selection order in SELECT

SuhaSaha — Thu, 20 Nov 2008 09:09:16 GMT

Hello ZeroABAPer,

Tell me how will you handle the case for the SELECT-OPTION having LOW & HIGH values using yor bit of code?

BR,

Suhas

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:18:10 GMT

Hello ZeroAbaper,

This code can't handle situations where both LOW and HIGH values are entered.

Thanks.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:22:54 GMT

David,

You do not require any code at all, incase, if both HIGH and LOW values are entered. Your selection will automatically fetch the necessary values.

You can modify the code, which i have given by introducing an IF condition.


if Select-option-high is initial.
...code here.
endif.
"Proceed from here as per your requirement.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:24:50 GMT

Suppose you are having SY-TABIX as select-option.

You enter the values as 15 to 50.

You need not modify anything in this case.

If you enter single entries like 15,20,25 and 50.

In this case, execute the code which i gave.

I hope.. it helps...

Regards...

Re: selection order in SELECT

SuhaSaha — Thu, 20 Nov 2008 09:31:14 GMT

Hello Zeroabaper,

Lemme point out sth.

S_SCR-LOW = 15, S_SCR-HIGH = 20.

After SELECT stmt IT1 contents --> 15, 16, 17, 18, 19, 20.

If we use ur code IT2 will have only 15 & not all the entries in IT1. Correct me if i am wrong.

BR,

Suhas

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:35:18 GMT

Suhas,

You are right .. ... but as per my previous post, you dont have to use the code for internal table 2, if SELECT-OPTION-HIGH is having any value....

Introduce the IF condition and proceed....

what do you say..??

Re: selection order in SELECT

SuhaSaha — Thu, 20 Nov 2008 09:42:04 GMT

Hello,

With David not disclosing his queer requirement & we have no option bt to work on this )

Frankly i was thinking the only way to do so will be the way u ve mentioned. But then dropped the idea bcoz of the probs as mentioned by me above.

BR,

Suhas

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:42:44 GMT

Hello,

The select-option internal table looks like this:

SIGN OPTION LOW HIGH

I EQ 8446

I BT 9260 9275

I EQ 9224

I EQ 8275

I need the entries in exactly the same order.

eg.

8446

9261

9265

9224

8275

Thanks.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:50:53 GMT

Well..

You can try this...


loop at s_option
if s_option = 'EQ'.
  wa_itab-entry = s_option-low.
  append wa_itab to t_itab.
  continue.
endif.
if s_option = 'BT'.
  do.
  w_count = s_option-low.
  wa_itab-entry = w_count.
  w_count = w_count + 1.
  append w_count to t_itab.
  while w_count > s_option-high.
endloop.
endloop.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:51:26 GMT

Dear David,

just try this.

ranges:

lr_fkart for vbrk-fkart,

lr_fkart-sign = 'I'.

lr_fkart-option = 'EQ'.

lr_fkart-low = 'SO_low'.

lr_fkart-high = 'SO_high'.

append lr_fkart.

now use this lr_fkart in where condition.(OR)

once fetching data into an internal table .just compare this with the order range table (lr_fkart) and append it to some another table. hope this may help you.

UR's

GSANA

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 09:53:24 GMT

As per the above code, you will have the entries of the select options, as you wish.

You can then loop into this table...read the table in which you have the data.. and append that data which you get into a third internal table.

That internal table will have the values as you wish..

Re: selection order in SELECT

SuhaSaha — Thu, 20 Nov 2008 10:07:58 GMT

Hello,

Came up with a novel soln. But will work only for numeric values )



REPORT  ZTEST01335.

TABLES: T001.

TYPES:
  BEGIN OF TY_T001,
    BUKRS TYPE BUKRS,
  END   OF TY_T001.

DATA:
  IT1   TYPE STANDARD TABLE OF TY_T001,
  IT2   TYPE STANDARD TABLE OF TY_T001,
  WA    TYPE TY_T001,
  V_CNT TYPE I VALUE 1.

SELECT-OPTIONS: S_OPT FOR T001-BUKRS.

SELECT BUKRS
INTO TABLE IT1
FROM T001
WHERE BUKRS IN S_OPT.

IF SY-SUBRC = 0.
  SORT IT1 BY BUKRS.
  LOOP AT S_OPT.
    IF S_OPT-OPTION = 'EQ'.

      READ TABLE IT1 INTO WA
      WITH KEY BUKRS = S_OPT-LOW BINARY SEARCH.
      IF SY-SUBRC = 0.
        APPEND WA TO IT2.
        CLEAR WA.
      ENDIF.

    ELSEIF S_OPT-OPTION = 'BT'.

      V_CNT = S_OPT-LOW.

      DO.
        READ TABLE IT1 INTO WA
        WITH KEY BUKRS = V_CNT BINARY SEARCH.
        IF SY-SUBRC = 0.
          APPEND WA TO IT2.
          CLEAR WA.
        ENDIF.

        V_CNT = V_CNT + 1.

        IF V_CNT > S_OPT-HIGH.
          EXIT.
        ENDIF.
      ENDDO.

    ENDIF.
  ENDLOOP.

ENDIF.

Re: selection order in SELECT

Former Member — Thu, 20 Nov 2008 10:21:52 GMT

User input is stored in an internal table such as S_USER_INPUT

Entries from select query are stored in internal table S_INT_TAB

Now For S_USER_INPUT-OPTION EQ 'BT' then fill internal table S_USER_INPUT2 with all enties between, similary for 'EQ' fill enties in S_USE_INPUT2.

Then LOOP AT S_USER_INPUT2 INTO WA.

READ TABLE S_INT_TAB FROM WA

IF SUCCESSFUL READ THEN MOVE WA to INT_TAB2

ELSE

CONTINUE.

ENDLOOP.

Re: selection order in SELECT

ThomasZloch — Thu, 20 Nov 2008 10:24:57 GMT

How about this approach:

You loop at each row of the selection-option, inside the loop you move that row to another range, do the select using that range, appending to your internal result table.

Thomas