hi
<b>Difference between Select-Options and Parameters</b>
<b>The main difference between select-options and parameters is that the select-option creates a selection table consisting of 4 fields.</b>
Please go thru the following details to learn more bout it...
Description of the individual components:
<b>
SIGN</b>
The data type of SIGN is C with length 1. The contents of SIGN determine for each row whether the result of the row condition is to be included in or excluded from the resulting set of all rows.
Possible values are I and E.
– I stands for "inclusive" (inclusion criterion - operators are not inverted)
– E stands for "exclusive" (exclusion criterion - operators are inverted)
<b>
OPTION</b>
The data type of OPTION is C with length 2. OPTION contains the selection operator. The following operators are available:
– If <b>HIGH </b>is empty, you can use EQ, NE, GT, LE, LT,CP, and NP. These operators are the same as those that are used for logical expressions. Yet operators CP and NP do not have the full functional scope they have in normal logical expressions. They are only allowed if wildcards ( '*' or '+' ) are used in the input fields.
If wildcards are entered on the selection screen, the system automatically uses the operator CP. The escape character is defined as #.
– If HIGH is filled, you can use BT (BeTween) and NB (Not Between). These operators correspond to BETWEEN
and NOT BETWEEN that you use when you check if a field belongs to a range. You cannot use wildcard characters.
- LOW
The data type of LOW is the same as the column type of the database table, to which the selection criterion is linked.
– If HIGH is empty, the contents of LOW define a single field comparison. In combination with the operator in OPTION, it specifies a condition for the database selection.
– If HIGH is filled, the contents of LOW and HIGH specify the upper and lower limits for a range. In combination with the operator in OPTION, the range specifies a condition for the database selection.
- HIGH
The data type of HIGH is the same as the column type of the database table, to which the selection criterion is linked. The contents of HIGH specify the upper limit for a range selection.
<b>The parameter statement does not create a selection table .
The second thing is select-option gives us a range for selection, whereas parameter doesn't .
Using the parameter you can define radio buttons and checkboxes where as select-options can't .</b>
1. As you have mentioned, many values/ranges can be given in the SELECT-OPTIONS. However, the parameter can hold only one value.
2. In the run time, we see the data w.r.t a select option as an Internal table and Parameter may be accessed as a global variable.
3. Consider following statements:
a. select-options: s_matnr for mara-matnr no-extension no intervals.
b. parameters: P_MATNR like mara-matnr.
Both the statements look same on the selection screen.
consider the SQLs:
<b>select * into corresponding fields of table g_t_mara
from mara
where
matnr in s_matnr.</b>
and
<b>select * into corresponding fields of table g_t_mara
from mara
where
matnr eq p_matnr.</b>
both the SQLs give the same output if the user gives a material number on Selection screen.
If the user does NOT give any input in selection screen, the first SQL will fetch all data from DB, whereas the SQL with the PARAMETER will fail.
So I think we should keep in mind the requirement and code accordingly.
I hope this helps you.
regards
ravish
<b>plz dont forget to reward points if useful</b>
Bluesky
