topic Re: select options to internal table in Application Development and Automation Discussions

select options to internal table

Former Member — Thu, 16 Oct 2008 08:05:47 GMT

i have selected some values in the range say 100 to 200 using select options....is there any way to get these values in an internal table?

also does select option work with alpha numeric values

eg : if i want to select between a100 and b200?

Re: select options to internal table

Former Member — Thu, 16 Oct 2008 08:12:40 GMT

No,

only doing it yourself with your own logic.

so first example

100,101,102,103,104 etc.

next example

a200,a201....,a998,a999,b000,b001......b199,b200

or if you want only values who exist in the corresponding databasetable read that table with the select-optoins and put those values in an internal table.

<edit: and i'm only talking about the use of BT here, not even exclusive or inclusive etc. so you get the potential treath? >

Regards,

Guido

Edited by: G. Bouman on Oct 16, 2008 10:13 AM

Re: select options to internal table

former_member226519 — Thu, 16 Oct 2008 08:17:07 GMT

what values do you want in an ITAB?

select * ... into table itab

will select the values according to the select-options

and the select-option is an internal table with fields

SIGN, OPTION, LOW, HIGH

Re: select options to internal table

Former Member — Thu, 16 Oct 2008 08:17:32 GMT

Hi,

Use can use like this

loop at seltab.

seltab-sign = 'I'

seltab-option = 'BT'

seltab-low = 1

seltab-high = 5.

endloop.

Thanks and Regards

Guru

Re: select options to internal table

Former Member — Thu, 16 Oct 2008 08:22:14 GMT

Hello,

Select option is one type of internal table so if u want all the select-options to me moved to 2nd internal table create one structure for required fields.

First Loop the Select-option.

Move the value low and high to the internal table and append the internal table.

endloop.

Re: select options to internal table

Former Member — Thu, 16 Oct 2008 08:37:53 GMT

i mean to say if i have 100 to 200.. i need 101 102 103 etc..continuosly till 200

Re: select options to internal table

former_member195383 — Thu, 16 Oct 2008 08:41:11 GMT

Hi..

suppose so_optn is the select option u are using..

U want to transfer it to tb_optn

U can do the same in the below way.

LOOP AT so_optn.

wa_optn-optn = so_optn-low.

APPEND wa_optn-optn TO tb_optn.

CLEAR wa_optn.

ENDLOOP.

here wa_optn is a work area of the same type as that of tb_optn.

revert back if more explanation is needed..

Re: select options to internal table

matt — Thu, 16 Oct 2008 08:43:50 GMT


> i mean to say if i have 100 to 200.. i need 101 102 103 etc..continuosly till 200

Select-options are really only useful for selecting data that matches the select-options from some other dataset. They don "expand out" into a set of values.

If you are always specifying a range in the selection screen, use two parameters - p_low, p_high.

You then will need to build your itab entry by entry. So

l_count = p_low.
WHILE l_count LE p_high.
  INSERT l_count INTO t_itab.
  ADD 1 to l_count.
ENDWHILE.

For a100 to a200, you'd have to do some string slicing and concatenation to get the desired result.

Re: select options to internal table

Former Member — Thu, 16 Oct 2008 08:56:11 GMT

it is only possible with your own coding.

so user is filling select-options. when he is entering: A100 BT B200

do you want A100 to A999 and then B000 and so on or is it possible to have A999 and then AA00 and so on. the limitiation on the possiblities are your scope to program the list. But you have to program it with selfmade coding.

the next alphacharacter can be taken from a string filled with ABCDEFG.....YZ

the next numeric character can de calculated (add 1).

but when the user is filling the select-options he can also have more entries and also values who are not to be used, so you have to take that in account also.

so it is very tricky to do what you want. my advice is: DON'T TRY if the scope is to large.

Regards,

Guido