Difference of "NO INTERVALS NO-EXTENSION" and "Parameter"

[Former Member]

Hi all,

Whats the difference between "NO INTERVALS

NO-EXTENSION" in select-option and simple Parameter

[andreas_mann3]

hi,

1) no-extension is like an interval - you can select only <b>1</b> interval

2) NO INTERVALS only hides the intervals/extension - but you can activate them - this is ot possible by 1

A.

Message was edited by: Andreas Mann

[Former Member]

Hello,

NO-EXTENSION

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

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.

If u have both No-extension and No-interval it will behave like simple parameters stmt.

If useful reward points.

Rgegards,

Vasanth

[former_member181962]

you cannot say

You can still add values for select-options in initialization,start-of-selection events.

s_matnr-high = '123'.

append s_matnr.

s_matnr-low = '1243'.

s_matnr-sign = 'I'.

s_matnr-option = 'EQ'.

append s_matnr.

Regards,

ravi

[srinivas_akiri]

Hi,

both are acts as same in program. where as for the select-option the value is stored in an internal table(selection table with low = value

sign = I

option = EQ

high = space. )

[Former Member]

Hi Anbarasann

... 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.

Parameter

Parameter can hold only one value.

Regards,

krishna

[Former Member]

Hi Anbarasan,

<b> NO INTERVALS</b>

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.

... <b>NO INTERVALS</b>

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.

<b>Defines Program Parameters</b>

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.

Regards,

Kiran B

[Former Member]

Hi

In No-Extension--The user can make an entry on one line.You can restrict the user to enter a single value for a select option and also 'greater than' less than or equal to' options can be used with the single value

No-Interval--In this ,select option is displayed without a 'TO' field.This is useful when u are not using a range

[former_member188685]

hi,

<b>NO INTERVALS</b> is used to remove the intervals option.

<b>NO-EXTENSION</b> is used remove the option like exculde,include, Between, etc..

Regards

Vijay

[Former Member]

hi,

<b>NO INTERVALS</b>

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

<b>NO-EXTENSION</b>

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.

[Former Member]

Thanks all,

I want to know if we use "NO-extension no intrval"

instead a simple Parameter, is there any advantage....or disadvantage...??

[former_member181962]

Hi Anbarasan,

In general Usage of select-options is a performance overhead. So better you go for parameter.

The reason is that internally the select statements using select-options will be converted into individual native sql statements.

Regards,

ravi

[Former Member]

hi ,

Relating it to performance use Parameter than select-option statement

[laxmanakumar_appana]

Hi,

Check the details :

... 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.

Notes

On the "Multiple Selection" screen, you can also enter ranges for selection options with "NO INTERVALS".

By combining this addition with "NO-EXTENSION", you can restrict the user to entry of a single value for the selection option, but with the possibility of also choosing single value options like 'Greater than' or 'Less than or equal'.

By using the addition " NO INTERVALS" with SELECTION-SCREEN BEGIN OF BLOCK, you can activate the simplified display for all selection options in a block.

Regards

Appana

[Former Member]

Hi Anbarasan,

To add to the above.

1)Select-options with "NO INTERVALS NO-EXTENSION" and PARAMETERS are displayed as the same on the selection screen then why they are used??

When you dint give any value in selection screen for PARAMETERS, none of the records will be fetched when it is used in the WHERE clause of a SELECT statement. But when no input is given in SELECT-OPTION and used in the WHERE clause of SELECT statement, all the records for the corresponding key will be fetched.

REPORT zztest_arun.
TABLES : mara.


DATA : it_mara_par TYPE STANDARD TABLE OF mara,
       it_mara_sel TYPE STANDARD TABLE OF mara,
       par_cnt TYPE i,
       sel_cnt TYPE i.

PARAMETERS     : p_matnr TYPE mara-matnr.

SELECT-OPTIONS : s_matnr FOR mara-matnr NO INTERVALS NO-EXTENSION.

*This option works same like PARAMETERS statement. The difference is that
*if no input value is passed in the selection screen no records are fetched
*for the PARAMETERS statement.... Whereas for SELECT-OPTIONS --- NO INTERVALS NO-EXTENSION.
*all the values will be fetched if no input is specified.


START-OF-SELECTION.

*I am limiting the values to be fetched to 200 else it will take a lot of time.
*
*Dont give any values in the selecton screen and execute the program.
*
*No record will be fetched for PARAMETERS option

  SELECT * FROM mara INTO TABLE it_mara_par UP TO 200 ROWS WHERE matnr EQ p_matnr.
  DESCRIBE TABLE it_mara_par LINES par_cnt.


*All records in the table will be fetched for SELECT-OPTIONS --- NO INTERVALS NO-EXTENSION option

  SELECT * FROM mara INTO TABLE it_mara_sel UP TO 200 ROWS WHERE matnr IN s_matnr.
  DESCRIBE TABLE it_mara_sel LINES sel_cnt.



  WRITE : / 'No of Records Fetched when no data passed to Selection Screen',
          / 'PARAMETERS     :' , par_cnt,
          / 'SELECT-OPTIONS :' , sel_cnt.

If SAP gave "NO INTERVALS NO-EXTENSION" option for SELECT_OPTIONS, to display same as PARAMETERS, no multiple selection etc.. It was for a reason.

Regards,

Arun Sambargi.

Message was edited by: Arun Sambargi