Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Select-options not working

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

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

Former Member
0 Kudos

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
Active Contributor
0 Kudos

pl paste ur code

former_member229729
Active Participant
0 Kudos

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
0 Kudos

Hi sai srinivas,

would you post your select statement.

Former Member
0 Kudos

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