topic Re: select options in Application Development and Automation Discussions

select options

Former Member — Fri, 18 May 2007 10:53:51 GMT

In select options why are u using no-display and no-interval? when can u use it?

Re: select options

Former Member — Fri, 18 May 2007 10:57:17 GMT

hi,

when u want to hide particular field in selection-screen u can give

s_matnr mara-matnr no-display.

no-interval :without giving values if u want to execute..wecan use no-interval.

Reward with points if helpful.

Re: select options

Former Member — Fri, 18 May 2007 10:57:30 GMT

Hi,

if u use no-display u can see that sel-option in selection screen.

if u use no-interval menas u can enter only single range in selection screen(u won't find arrow mark at last which we used to see normally)

rgds,

bharat.

Re: select options

former_member196299 — Fri, 18 May 2007 10:58:52 GMT

hi ,

here is the information ;;

NO-DISPLAY :

If you specify this addition, no screen elements are created on the selection screen for the selection criterion. In an executable program, a selection criterion of this type is used exclusively as part of the interface defined by the selection screen. It can be supplied with a value by the calling program when it is called with SUBMIT.

If the addition NO-DISPLAY is specified, the low and high columns in the selection table can have any flat data types. These selection tables can only be supplied with data with a WITH addition to the SUBMIT statement.

Note

The length of the values transferred to columns low and high in the selection table, for which there is no input field, is not restricted to 45 characters, as is the case for selection criteria with input fields.

NO-INTERVAL:

If you specify this addition, the second input screen is not created on the selection screen.

Note

The user can only specify a single comparison in the first line in the selection table on the selection screen. The dialog box for multiple selections still allows interval selections.

Example

Declaration of a selection criterion for which a single comparison is possible on the selection screen, but multiple selection isnot possible.

DATA spfli_wa TYPE spfli.

SELECT-OPTIONS s_carrid FOR spfli_wa-carrid NO-EXTENSION

NO INTERVALS.

Hope this makes you understand :

Reward points if helpful !

Regards,

Ranjita

Re: select options

Former Member — Fri, 18 May 2007 13:12:28 GMT

no interval option is nothing but

parmeter with multiple values

with parameter we can give only one value

but with no interval extension of Select-options we can give multiple values for that particular field

100

250

350

like that

Re: select options

Former Member — Fri, 18 May 2007 13:21:03 GMT

suppose you have a parameter p_matnr.

now see the following query:

select * from mara where matnr = p_matnr.

these query will not select any rows if p_matnr is empty.

now u have a requirement that if p_matnr is empty then

the select query should select aa rows. in the case u defite

a select option s_matnr with no-display and no-extension. it will

just look like a parameter in the screen.

select * from mara where matnr in s_matnr.

now, the above query will select all the rows from mara when

s_matnr is empty.