topic Re: ranges in Application Development and Automation Discussions

ranges

Former Member — Tue, 17 Apr 2007 03:43:45 GMT

what is the difference between select-options and ranges?

Re: ranges

satykumar — Tue, 17 Apr 2007 03:45:36 GMT

Hi,

Check this link

http://www.sap-img.com/abap/difference-between-select-options-ranges.htm

Cheers

Satyendra.

Re: ranges

shishupalreddy — Tue, 17 Apr 2007 03:45:47 GMT

Hi,

Select-options is a componenet of selection screen where user can provide the required input .

ranges is also similar to selct-options but not a selection screen component.

we can use ranges in the program but we need to populate the ranges table in the program and then we can use the same for extracting the data .

regards

Re: ranges

Former Member — Tue, 17 Apr 2007 03:48:40 GMT

Hi Balu,

Go through this info.

What are the difference between SELECT-OPTIONS & RANGES?

Here both SELECT-OPTIONS & RANGES works for the same purpose. They both are used for the range selection from selection screen. The main diff. between them is, while we use SELECT-OPTIONS system implicitly creates the select options internal table which contains the fields of SIGN,OPTION,LOW & HIGH. But in case of RANGES, this internal table should be defined explicitly.

Eg. to SELECT-OPTIONS :

REPORT YARSELECT.

TABLES YTXLFA1.

SELECT-OPTIONS : VENDOR FOR YTXLFA1-LIFNR.

INITIALIZATION.

VENDOR-LOW = 1000. " It specifies the range starting value.

VENDOR-HIGH = 2000. " It specifies the range ending value.

VENDOR-OPTION = 'BT'. " specifies ranges value is in between.

VENDOR-SIGN = 'I'. "specifies both inclussive.

APPEND VENDOR.

- - - -

SELECT LIFNR LAND1 NAME1 FROM LFA1 INTO TABLE ITAB

WHERE LIFNR IN VENDOR.

Eg. to RANGES:

REPORT YARRANGE.

TABLES YTXLFA1.

RANGES: VENDOR FOR YTXFLA1-LIFNR.

- - - -

- - - --

- - - -

SELECT LIFNR LAND1 NAME1 FROM LFA1 INTO TABLE ITAB

WHERE LIFNR IN VENDOR.

Here with RANGES user has to design an internal table with fields -

SIGN,OPTION,LOW and HIGH EXPLICITLY.

Example:

select-options: bukrs for zstock-bukrs.

Should the user fill in 'ABFI' in BUKRS on the selection screen, BUKRS will look like this:

IEQABFI

This is because BUKRS is set as a table as follows:

begin of bukrs occurs 0,

SIGN(1) type c,

OPTION(2) type c,

LOW like bukrs,

HIGH like bukrs,

end of bukrs.

Now, when you create the following range, it will have the exact same fields set inside its table:

Ranges: bukrs for zstock-bukrs.

The difference is, because ranges doesn't show on the selection screen, you will have to fill it yourself, meaning you will have to fill bukrs-sign, bukrs-option, bukrs-low & bukrs-high all manually.

Some tips:

Sign is always I (for Include) or E (for Exclude)

Option can be a whole range, which includes:

EQ (Equal)

BT (Between))

CP (Contain Pattern)

So let's say you want to have the range check for all company codes not starting with AB, you will set your code as follow:

ranges: bukrs for zstock-bukrs.

bukrs-sign = 'E'. "Exclude

bukrs-option = 'CP'. "Pattern

bukrs-low = 'AB*'. "Low Value

bukrs-high = ''. "High Value

append bukrs.

Always remember to APPEND your range when you fill it, as the WHERE clause checks against the lines of the range table, not against the header line.

Hope this explains it well enough.

What does SIGN "I" & "E" mean?

The "I" stands for Include, and the "E" for Exclude.

The easiest way to learn how the range selections work is, create the following dummy program:

report dummy.

tables: mara.

select-options: matnr for mara-matnr.

start-of-selection.

loop at matnr.

write: / matnr-sign,

matnr-option,

matnr-low,

matnr-high.

endloop.

Run this program, and fill in a lot of junk into MATNR. Fill in some includes, some excludes, some ranges, etc., and you will soon realise how the system builds ranges (select-options). Once you know that, you can fill your own ranges quickly and efficiently.

Rewards points.

Rgds,

P.Nag

Re: ranges

Former Member — Tue, 17 Apr 2007 03:56:46 GMT

SELECT-OPTUIN IS USED FOR A RANGE OF VALUES.. AND PARAMETERS IS USED FOR A SINGLE VALUE.. THIS IS THE BASIC N FORMOST DIFFERENCE...

Re: ranges

Former Member — Tue, 17 Apr 2007 04:19:26 GMT

hi Balu,

Select-options and ranges represent the same technology..meaning their internal

representations are the are the same. They are used to store a range of values.

But select-options is used as a selection screen component while

ranges are used to create internal tables of type select-options, to store a range

in order to use in select queries...(mainly, for using the IN option in the where clause

of a select query, for a variable for which a select-option does not exist)

hope this helps,

Sajan Joseph.

Re: ranges

Former Member — Tue, 17 Apr 2007 04:22:40 GMT

Hi Balu ,

Both of them serve the same purpose , the only major diffrence being that select options gives a graphical interfce which is created automatically which ranges does not provide.

One more small diffrence is select options always have a header line associaated with it , but it is not always the case with ranges.

Regards

Arun