Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

General Selection Screen

Former Member
0 Kudos
126

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
78

Check below link...

5 REPLIES 5

Former Member
0 Kudos
79

Check below link...

Former Member
0 Kudos
78

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
0 Kudos
78

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
Active Contributor
0 Kudos
78

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
0 Kudos
78

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