topic diff. seletions-options and parameters in Application Development and Automation Discussions

diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 10:21:21 GMT

Hi,

Difference between select-options with no extension and parameters

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 10:23:55 GMT

NO INTERVALS

Effect

When you use the NO INTERVALS addition, the system creates a smaller subscreen that does not contain the HIGH fields of the selection criteria.

Note

If you want to display a selection screen on any other screen or as part of a tabstrip control on a selection screen, you must create it as a subscreen.

... NO-EXTENSION

Effect

The user can only make an entry on one line. Calling the additional "Multiple Selection" screen is not supported and no pushbutton for this appears on the selection screen.

... NO INTERVALS

Effect

The selection option is displayed on the selection screen without a 'to' field. The pushbutton for calling the "Multiple Selection" screen appears immediately after the 'from' field.

This addition thus allows you to generate a simplified display on the selection screen. This is particularly useful if you are not making any range selections for this selection option.

Defines Program Parameters

Objects that you define with this statement can have two functions:

In executable (type 1) programs:

You can run executable programs using the r SUBMIT statement. The PARAMETERS and SELECT-OPTIONS statements form their interface. This is usually the interface between the program and the user, that is, the parameters and select-options are filled out by the user on the selection screen (see also the NO-DISPLAY addition and the SUBMIT statement without the VIA SELECTION-SCREEN addition).

In any program (apart from a subroutine pool, that is, a program with type S):

Objects in a program, defined on a selection screen that is filled out by the user at runtime

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 10:27:36 GMT

hi Mukul,

if you declare Select-options with no extension that means you can not give multiple values for the specified field in selection screen but you can give range of values for it.

but in case of Parameter you can give only one value for the specified field in selection screen.

Reward points if useful

Chandra.

Re: diff. seletions-options and parameters

abdulazeez12 — Mon, 08 Oct 2007 10:27:55 GMT

SELECT OPTIONS with no-intervals and no-extension acts like PARAMETERS statement except that the select options has to be addresses like SO_NAME-LOW.

Re: diff. seletions-options and parameters

paruchuri_nagesh — Mon, 08 Oct 2007 10:33:23 GMT

difference between select-options with no-extension & parameter

when user doesnt give any input in select-options the where condition gets failed in select statement and it fetch all data from database

but in case of parameter whenver field value equal to space then only it fetches data otherwise it wont fetch data.

reward for useful points

regards

Nagesh.Paruchuri

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 10:36:00 GMT

Hi,

parameter p_mat.

select options s_mat for mara-matnr no interval no-extention

This will act as a parameter, u can give ony one value.

But s_mat is a range but

p_mat is a variable

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 10:39:18 GMT

To allow the user to process only the first row of the selection table on the selection screen, you use the following syntax:

SELECT-OPTIONS <seltab> FOR <f> ..... NO-EXTENSION .....

As a result, the pushbutton for multiple selections does not appear on the selection screen, and multiple selections are not available to the user.

DATA WA_SPFLI TYPE SPFLI.

SELECT-OPTIONS AIRLINE FOR WA_SPFLI-CARRID NO-EXTENSION.

The following standard selection screen appears:

You use the PARAMETERS statement to declare variables, similarly to the DATA statement Variables declared with the PARAMETERS statement are called parameters. For each parameter declared, an input field appears on the corresponding selection screen. On the left hand side of the input field, the name of the parameter is displayed as text. You can modify this text as selection text. Values entered into the input field by the user are assigned to the corresponding variable while the system processes the selection screen. The position of the statement in the declaration part of the program determines the selection screen to which the input field belongs.

The basic form of the PARAMETERS statement is as follows:

PARAMETERS [(<length>)] [TYPE <type>|LIKE <obj>] [DECIMALS <d>].

This statement creates parameter . Currently, parameter names are limited to eight digits. The additions <length>, TYPE|LIKE and DECIMALS are the same as for the DATA statement. Note that the data types valid for parameters include all elementary ABAP types except data type F. You cannot use data type F, references and aggregate types.

If the parameter refers to data types from the Dictionary, it adopts all attributes of the Dictionary field. Currently, parameters can only refer to fields of database tables, views and structures. In particular, the field help (F1) and the possible entries help (F4) defined for these fields in the Dictionary are available to the user. To check a user entry against a value list in the Dictionary, you must use the special addition VALUE CHECK.

Parameters are used for simple queries of single values. For example, you can use parameters to control the program flow. However, if you want to restrict database accesses or perform complex selections, you should use selection criteria.

REPORT DEMO.

PARAMETERS: WORD(10) TYPE C,

DATE TYPE D,

NUMBER TYPE P DECIMALS 2,

CONNECT TYPE SPFLI-CONNID.

In this example, four parameters are created for the standard selection screen: a character field, WORD, of length 10; a date field, DATE, of length 8; a packed number field, NUMBER, with two decimals; and a field, CONNECT, that refers to the SPFLI-CONNID type in the ABAP Dictionary. When the user starts the program, the input fields appear as follows on the standard selection screen:

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 10:54:10 GMT

Difference between Select-Options and Parameters

The main difference between select-options and parameters is that the select-option creates a selection table consisting of 4 fields.

Please go thru the following details to learn more bout it...

Description of the individual components:

SIGN

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)

OPTION

The data type of OPTION is C with length 2. OPTION contains the selection operator. The following operators are available:

– If HIGH 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.

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 .

Reward if usefull

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 11:07:31 GMT

Hi,

Restricting Entry to One Row

To allow the user to process only the first row of the selection table on the selection screen, you

use the following syntax:

SELECT-OPTIONS <seltab> FOR <f> ..... NO-EXTENSION .....

As a result, the pushbutton for multiple selections does not appear on the selection screen, and multiple selections are not available to the user.

Basic Form of Parameters

statement in the declaration part of the program determines the selection screen to which the input field belongs.

The basic form of the PARAMETERS statement is as follows:

PARAMETERS [(<length>)] [TYPE <type>|LIKE <obj>] [DECIMALS <d>].

This statement creates parameter . Currently, parameter names are limited to eight digits.

The additions <length>, TYPE|LIKE and DECIMALS are the same as for the DATA

statement. Note that the data types valid for parameters include all elementary ABAP types except data type F. You cannot use data type F, references and aggregate types.

Regards,

Bhaskar

Re: diff. seletions-options and parameters

Former Member — Mon, 08 Oct 2007 11:28:25 GMT

Hi Mukul,

Select options and parameters look alike if you declare select options as NO INTERVALS and NO-EXTENSION.

Even then you can store multiple number of entries under select options but it is not possible with the parameter.

For better understanding go through the below code.

data: v_num(3) type n.

select-options: s_num for v_num no intervals no-extension.

parameters p_num like v_num default 100.

s_num-sign = 'I'.

s_num-option = 'EQ'.

do 4 times.

s_num-low = sy-index.

append s_num.

enddo.

write:/ 'Values from Select options '.

loop at s_num.

write:/5 s_num-low.

endloop.

write:/ 'Value from parameter ', p_num.