topic Re: Select options in Application Development and Automation Discussions

Select options

Former Member — Tue, 22 May 2007 09:21:22 GMT

What are SIGN,OPTION,LOW,HIGH in select options?

What r they used for?

Re: Select options

Former Member — Tue, 22 May 2007 09:25:12 GMT

sign - Including / Excluding

option - BT, EQ, NE, etc.,

Low, High - both r used when u want to specify a range of values, only low is used if u want to specify a single value

select-options statement will create a table to store the input values.

ex: if the table is like below

SIGN OPTION LOW HIGH

1) IN EQ A --

2) IN BT D G

3) EX EQ F

Here the table is containing 3 records

first record specifies A is avaiable in the table

second record specifies D,E,F,G is avaiable in the table

third record specifies F should not be present

finally there are A, D, E, G

Hope this will solve ur problem..

Please Dont forget to reward all the useful replies

Sudheer

Re: Select options

Former Member — Tue, 22 May 2007 09:27:42 GMT

These are used to default the values in the select-option field.

Sig -- Include/Exclude

Option -- 'EQ', 'BT' {Equal,Between etc.}

Low -- Low value for the giving range

High -- High value for the giving range

Thanks

eswar

Re: Select options

Former Member — Tue, 22 May 2007 09:28:11 GMT

Hi,

Actually, select option is a set of values and not a single value as parameters. this set of value is defined with these options.

e.g.

select-options: s_matnr for mara-matnr.

here u can give one value for matnr or set of values or ranges. if u want exact idea enter values in selection options and in debug mode goto table and check contains of s_matnr u will get exact idea.

Jogdand M B

Re: Select options

Former Member — Tue, 22 May 2007 09:29:28 GMT

hi,

select-options contains internal table with the fileds low,high,sign,option

low and high are ranges.

i.e. if we give LIFNR range as 1 to 100.

low is 1 and high is 100.

sign means Either including or excluding i.e data including/excluding the range.

option is specifying "='.this is standard option.we can specify ne between etc.

Re: Select options

Former Member — Tue, 22 May 2007 09:36:54 GMT

Behavior of SELECT-OPTIONS

When the Select-Options statement is executed the system creates the internal table with the same variable name . This table is also called as selection table. The main purpose of selection table is to store selection criteria. The table has four standard fields, which are as follows:

• SIGN is a variable, which denotes the system whether the result should be included with those particular criteria. It can contain either I or E. I denotes Inclusion. The criteria are included.

E denotes Exclusion. The criteria are excluded from the result.

• LOW the data type of LOW is the same as the field type of the database table, for which you are using selection criteria. This acts as lower limit of the selection.

• HIGH the data type of HIGH is the same field type of the database table, for which you are using the selection criteria. This acts as higher limit. If you don’t enter HIGH value then the LOW value defines a single value selection.

• OPTION is two-character field, which contains operators like EQ, GT, LT, GE, and LE.

When the user enters both the values i.e., high and low then this field acts as BT (between). If you don’t enter high value then all other operators can be Applicable.

Re: Select options

Former Member — Mon, 04 Jun 2007 05:19:00 GMT

Hi krishna Latha,

SIGN option will be used for finding the values between low & high ,it has two values "I & "E" BY using "I" INCLUDE U can find out include value and by using "E" Eexclude u can find out exclude values between low & high.

LOW: BY specifyig low value u can find out single value vice-versa for high

OPTION: BY using option u can find out values

between low & high using option 'BT'

and another

Thanks & Regards,

jogu_vineh@yaoo.com

Re: Select options

Former Member — Mon, 04 Jun 2007 05:31:25 GMT

Hi in select-options you are declaring fields wright to initialize we have to assign some values to the field .

select-options matnr for mara-matnr .

matnr-sign = 'I'/'E'.

mantr-option = 'BT'/'NE'/''EQ'/'GT'....

matnr-low = '1'.

matnr-high= '1000'.