topic Re: Regarding Ranges in Application Development and Automation Discussions

Regarding Ranges

Former Member — Tue, 22 Dec 2009 07:22:11 GMT

Hi all,

INITIALIZATION.

S_KSTAR-SIGN = 'I'.

S_KSTAR-OPTION = 'BT'.

S_KSTAR-LOW = '600000'.

S_KSTAR-HIGH = '699999'.

APPEND S_KSTAR.

S_KSTAR-SIGN = 'I'.

S_KSTAR-OPTION = 'BT'.

S_KSTAR-LOW = '400000'.

S_KSTAR-HIGH = '499999'.

APPEND S_KSTAR.

Through initialization i have appended two ranges for select option but when i am retrieving data from select statement it's taking only one range which is in header line. Please help me how to retrive data between two data ranges.

Thanks & Regards,

Nagalakshmi.

Re: Regarding Ranges

Former Member — Tue, 22 Dec 2009 07:25:13 GMT

Hi,

Did you use 'IN' in your select query?

Re: Regarding Ranges

Former Member — Tue, 22 Dec 2009 07:28:12 GMT

have you used IN or equal to in where clause ?

if You had used equal to then you data will be fetched based on header if it is not cleared else no data will come.

then try using IN instead of equal to.

Re: Regarding Ranges

Former Member — Tue, 22 Dec 2009 07:28:30 GMT

s , also not working

Re: Regarding Ranges

Former Member — Tue, 22 Dec 2009 07:34:52 GMT

Make a seperate range table for the two condition and try.

It should work when you use two diff range tables.

Also, check the avaliability of data between these two ranges.

Edited by: Harsh Bhalla on Dec 22, 2009 1:14 PM

Re: Regarding Ranges

MarcinPciak — Tue, 22 Dec 2009 07:50:58 GMT

You have to adress table's body not header line


"correct one
select ....
  where ... IN S_KSTAR[].

"wrong one
select ...
   where ... IN S_KSTAR.

This should help

Regards

Marcin

Re: Regarding Ranges

matt — Tue, 22 Dec 2009 09:03:58 GMT

If it is defined as a select option, the [] is not required.

This works:

TABLES t100.

DATA: t_100  TYPE STANDARD TABLE OF t100,
      wa_100 TYPE t100.

SELECT-OPTIONS: s_msg FOR t100-msgnr.

INITIALIZATION.

  s_msg-option = 'BT'.
  s_msg-sign = 'I'.
  s_msg-low = '020'.
  s_msg-high = '030'.
  APPEND s_msg.

  s_msg-low = '120'.
  s_msg-high = '130'.
  APPEND s_msg.

START-OF-SELECTION.

  SELECT * FROM t100 INTO TABLE t_100 WHERE sprsl EQ 'EN'
                                        AND arbgb EQ '00'
                                        AND msgnr IN s_msg.

END-OF-SELECTION.

  LOOP AT t_100 INTO wa_100.
    WRITE: / wa_100-msgnr.
  ENDLOOP.

So the question is: how have you defined s_kstar, what is your select statement? If s_kstar is defined as a select-option, or via the RANGES statement, then it DOES NOT use the header in the selection.

Re: Regarding Ranges

former_member778253 — Tue, 22 Dec 2009 09:09:14 GMT

just, check the select options declaration which should be as follows:

s_kstar for <tablename>-<fieldname>

hope this works.

Re: Regarding Ranges

Former Member — Tue, 19 Apr 2011 09:57:27 GMT

helpful