topic Select-options not working in Application Development and Automation Discussions

Select-options not working

Former Member — Sat, 06 Jun 2009 06:03:12 GMT

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

Re: Select-options not working

Former Member — Sat, 06 Jun 2009 06:07:20 GMT

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

Re: Select-options not working

Former Member — Sat, 06 Jun 2009 07:26:15 GMT

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

Re: Select-options not working

kesavadas_thekkillath — Sat, 06 Jun 2009 07:32:07 GMT

pl paste ur code

Re: Select-options not working

former_member229729 — Sat, 06 Jun 2009 08:49:00 GMT

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

Re: Select-options not working

Former Member — Sat, 06 Jun 2009 09:17:04 GMT

Hi sai srinivas,

would you post your select statement.

Re: Select-options not working

Former Member — Sat, 06 Jun 2009 09:43:46 GMT

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