Select-option

[Former Member]

Hi,

I am having a requirement like this:

I have to poulate a ztable created by me with the values from the selection screen populated by the user.

I am having problem with the select-option values.

We can retrieve either low or high values.

What about between (BT) values.

Ex: s_pspid-low = FATFA4999

s_pspid-high = FATFB4232.How to get all the values from FATFA4999 to FATFB4232

into my required field of ztable.

Thanks.

[Former Member]

the select options field is used for retrieving data from some table Say ABAB.

Write a select query

select pspid from abab into table itab where abab-pspid in s_pspid

loop at itab.

ztable-pspid = itab-pspid.
insert ztable.
commit work.
endloop.

Reward points please

[Former Member]

Hi,

BT is for Between. So u can use option = 'BT' and give low and high values.

Regards,

JMB

[Former Member]

Hi, if u want initialize the values or for between values,

u can do like this..

s_pspid-sign = 'I'.

s_pspid-option = 'BT'.

s_pspid-low = 'value1'.

s_pspid-high = 'value2'.

APPEND s_pspid.

Edited by: venkat reddy on Jun 4, 2008 3:52 PM

[Former Member]

the select options field is used for retrieving data from some table Say ABAB.

Write a select query

select pspid from abab into table itab where abab-pspid in s_pspid

loop at itab.

ztable-pspid = itab-pspid.
insert ztable.
commit work.
endloop.

Reward points please

[Former Member]

hi soumya,

if the selection-options fields from some standard table ,

then write a select query and fetch the all values between or option u gave in select-option and then populate those into u'r ztable.

reward if helpful,

regards,

chandu.

[RaymondGiuseppi]

- If there is already a database table behind the select-options, select the data from this table.

- Else change your z-table to accept ranges

- Else forbid range and wildcard in the selection-screen. [with Function module SELECT_OPTIONS_RESTRICT|https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_forums&query=select_options_restrict&adv=false&sortby=cm_rnd_rankvalue]

Regards