How to give single multiple values

[Former Member]

Hi,

I am having one scenario like ,in one report if i had given multiple single values in select option parameter but it is taken only first value please can you suggest on this issue.

Thanks,

Harinath

[Former Member]

Hi,

I am having one scenario like ,in one report if i had given multiple single values in select option parameter but it is taken only first value please can you suggest on this issue.

Thanks,

Harinath

[Former Member]

hi

Double click on select option in the selection screen .in the extended options select '='

regards

ravish

<b>plz dont forget to reward points if helpful</b>

Message was edited by:

ravish goyal

[Former Member]

Hi Peeleti ,

If you are using select options then it must take all the values , could you please paste your code here so that we can be able to analyse better.

Regards

Arun

[Former Member]

Hi,

Use IN in Select Statement.

i.e SELECT * FROM MARA where MATNR IN S_MATNR.

Regards,

Himanshu

[Former Member]

Hi

Dont use '=' in ur select statement. Instead of that try to use IN in where condtion.

Regards

Ravi

[Former Member]

Hi,

First declare the variable as select-options.once you done with that you have side arrow parallel to the field in the selection.Press theat and enter multiple single values.

once you check for condition insied the program in select statrement use as

select * from mara into table itab where matnr in s_matnr.

rewar dpoints if it is helpful.

Regards,

Sangeetha.a

[Former Member]

Hi,

If we use the SELECT-OPTIONS field then it will take all single values, look at the Table for SELECT-OPTION in the Debugging mode, you will find all the values in the table,

While writing the select statment, use IN in the where condition

Regards

Sudheer

[Former Member]

just click on the arrow (extension) button if you can see multiple value then it is taking correctly. other wise let us know how are you assigning the multiple single value?

s_op-low = '1000'.

s_op-sign = 'I'.

s_op-option = 'EQ'.

append s_op.

s_op-low = '2000'.

s_op-sign = 'I'.

s_op-option = 'EQ'.

append s_op.

s_op-low = '3000'.

s_op-sign = 'I'.

s_op-option = 'EQ'.

append s_op.

like that or from selection screen?

regards

shiba dutta

[Former Member]

hi harinath,

SELECT-OPTIONS - if u are using IN in select query that is suffecient it will pick it.nothing required different for multiple single value,

i think there is no data for that input.

ex. select * from DBtable into ITftable where DBtable-fieldname in so_fieldname.

regards

Prabhu

reward if it is helpful