General Selection Screen

[Former Member]

what is the difference between the following two

selection screen options

select-options:sid FOR Zxxx-ID NO-EXTENSION NO INTERVALS.

parameters : sid like zxxx-id.

Apart from that is there any difference that has to be taken care in this program

[Former Member]

Check below link...

[Former Member]

with the first statement ,

if u doesnt give any input value for the select-option , it will fetch all the values when used in select query

but with the second statement , if the parameter value is empty it will not fetch any record when used in select statement

[Former Member]

Hi Ramudu,

If you declare a Variable as a Parameter You should take care of validations

Ex: Like in where condition MATNR = P_MATNR.

Suppose if you are not given any value in the selction screen

This selection screen will not work ( i.e you won't get any material's)

If it is select Option

If you are not given any value in the selection screen, It will give you all the materials .

Thanks

Sekhar.

[Clemenss]

Hi,

select-options:sid FOR Zxxx-ID NO-EXTENSION NO INTERVALS

defines field SID aa selection range table as if defined by ABAP statement

DATA: SID type range of Zxxx-ID with header line .

NO-EXTENSION NO INTERVALS restricts the screen I/O to one field. In this field you can use wildcards defining patterns or use double-click to set compare operator >,<,<=,>=,....

The only allowed comparison operator for database retrieval or field compare is IN. The input field defined is for field SID-LOW of ABAP range SID.

parameters : sid like zxxx-id.

defines a simple input field.

All operators =,>,<,<=,>= and pattern operators CP, CA, NA but not range operator IN are allowed for database retrieval or field compare.

Note: Although the screen looks identical, the definition and use is very different.

Regards,

Clemens

[Former Member]

Hi,

First statment and second looks to be same but works differently .

First statment will return all records from the table when queried if no value is given.

Second will return only value with SPACE which is checked against .

First statement will need "IN" option in query .

Second cannot use "IN" option.

For First statement Table type should be declared if refered to ..

Second statement tbale type declaration is not needed ..

Hope this is clear.

Regards

R. Ramvelu