03-05-2007 2:06 AM
hi
can u send code for
getting multiple selections in select-options
Thanks in advance
venkat
03-05-2007 2:14 AM
Hi Venkat,
Your query is not clear..can u give more details about ur query?
Regards
Jaker.
03-05-2007 2:20 AM
If you are referring to select-options defined in a selection screen. This mulitple selections functionality is handled automatically for you. For example, say you have a select-option for date and you have to select records from your database based on that select-option, you would use the IN operator in your select statement.
select-options: s_datum for sy-datum.
select * into table itab from ztable
where datum in s_datum.
Regards,
Rich Heilman
03-05-2007 2:26 AM
hi venkat,
The select-options statement is used similarly to the parameters statement in that it creates a selection criteria for a database field. The main difference between the two is that the select-options statement creates two input fields containing both a FROM and a TO field, as opposed to just a single field input.
Syntax for select-options
The syntax for this statement is as follows:
select-options ex sele for table-field default 'VALUELOW' to 'VALUEHI'.
The select-options statement displays a line that usually has two fields for input data. This can be restricted to only one by using the no-intervals clause in the select-options syntax. For example, if your program does not require a TO field for entry in select-options statement line, but you still want to use the select-options statement, you would include this no-intervals clause. This clause, as well as the no-extension clause, will be further explored in the example at the end of this section. For now, however, we will turn to a discussion of the format of the select-options internal selection table.
This internal table is maintained with the following field format if the user clicks on the arrow to the right of the TO field of the select-options. Clicking on this arrow brings up a Multiple Selections input screen that fills the internal selection table. This table then holds the key attributes of the input data, including the SIGN, OPTION, LOW value, and HIGH value. These features of the select-options statement can have the following conditions:
SIGN-Can signify INCLUSIVE, which is the default, or EXCLUSIVE, which can be flagged in the Complex Selections window.
OPTION-Can hold values BT (between), CP (contains pattern), EQ (equal to), and GE (greater than or equal to).
LOW-Holds the value input in the FROM field.
HIGH-Holds the value input in the TO field.
regards,
keerthi
03-05-2007 3:09 AM
Venkatesh,
DATA : s_mara like mara occurs 0 with header line.
SELECT-OPTIONS: s_matnr FOR mara-matnr.
In selection statement.
select * from mara into i_mara
where matnr in s_matnr.
Here you can get all the values of mara which are enter in selection screen.
Pls. mark if useful
03-05-2007 3:12 AM
hi
good
go through this links which ll give you detail idea about the SELECT-OPTIONS
thanks
mrutyun^
03-05-2007 4:34 AM
Hi,
In SELECTION Screen, if u have used SELECT-OPTIONS, then u can use this multiple selection.
IF u press teh side arrow near the text box, u will be able to give multiple values in the rows.
Also u can give muliple ranges.
Where as in screen if u enter u can enter only in from and to, if u choose this arrow button then u can enter lots f ranges.
But in the select query IN operator will take care of all the values.
If u dont want taht multiple selections u can restrict the same in
SELECT-OPTIONS: s_matnr FOR mara-matnr NO-EXTENSIONS.
This will remove teh arrow from the selection screen.
Hope u r clear.
Reward if u find helpful.
03-05-2007 5:21 AM
HI......
select-options:
s_carrid for spfli-carrid.
then u need to append records to it to get multiple selections, as
s_carrid-low = 'AA'
s_carrid-high = 'DA'
s_carrid-option = 'EQ'
s_carrid-sign = 'I'
APPEND S_CARRID.
like this append as many as u need ,
then combination of all these will be taken into consideration while retrieving the data from DB