Select-options not working

[Former Member]

Hi,

I am making a select query from a custom table. In the selection screen I have a field as select option.

If I give the range on the select option ( Like from 1 to 10), my select query is picking all the records irrespective of the range given in the select options..

Did anybody faced this issue?? please suggest me the solution.

Regards,

Sai Srinivas

[Former Member]

Could u plz write down your query...??

[Former Member]

Could u plz write down your query...??

[Former Member]

Hi,

in the select query write...

select <fields> from table into table <itab>
    where <field> in <select option>.

or get the select option-low and select option-high values and mention that in the Where condition.

hope u got the idea!!

best of luck!!

thanks

Ravi

[kesavadas_thekkillath]

pl paste ur code

[former_member229729]

Hi,

Below is a Sample coding:

Tables: VBAK,
            VBAP.

Data: int_vbak type vbak occurs 0 with header line.

Select-options: s_vbeln for vbak-vbeln.

Select * INTO int_VBAK from VBAK where
              VBELN in s_vbeln.
         APPEND int_VBAK.
         CLEAR int_VBAK.
ENDSELECT.

Loop at s_vbeln.
      WRITE: /   'SIGN:',   s_vbeln-sign,
                      'OPTION:', s_vbeln-option,
                      'LOW:',    s_vbeln-low,
                      'HIGH:',   s_vbeln-high.
Endloop.

loop at int_vbak.
   Write:/ int_vbak-vbeln, int_vbak-AUART.
endloop.

Hope above would be in line with your requirement.

Rgds.,

Ramani N

[Former Member]

Hi sai srinivas,

would you post your select statement.

[Former Member]

Just use "IN" operator instead of "EQ" or "=".