Skip to Content
author's profile photo Former Member
Former Member

Ranges in Selection Screens

Hi

Can any body give the info regarding ranges in selection screens instead of selection-options.

I want to use multiple selections

Thanks & Regrads

venkat

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 03, 2007 at 01:57 PM

    Hi Ranges,

    Ranges is like a select options .This is used to use internally in the program and used in select .

    for

    ranges : r_vbeln for vbak-vbeln .

    structure of r_vbeln would be having four columns

    Option

    sign

    low

    High

    Please reward if useful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 03, 2007 at 02:01 PM

    Declares a RANGES table.

    Syntax

    RANGES <rangetab> FOR <f>.

    Declares a RANGES table for the field <f>. A RANGES table has the same data type as a selection table, but is not linked to input fields on a selection screen.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 03, 2007 at 03:49 PM

    Hi,

    Declaration:

    RANGES <rangetab> FOR <f>.

    1.Ranges are just SELCT-OPTIONS, which are used internally for the program logic.

    2.Ranges don't appear on the selection screen as like selct-options.

    3.Ranges create internal tables of the same type as selection tables.

    DATA: BEGIN OF <rangetab> OCCURS 0,

    SIGN(1),

    OPTION(2) -


    BT/EQ/LE/GT--like on

    LOW LIKE <f>, -


    Lower value

    HIGH LIKE <f>, ---Higher/upper value

    END OF <rangetab>.

    4. if value is compared against ranges then 'IN' should be used.

    5. RANGES tables:

    are not passed like selection criteria to logical databases

    cannot be used with the shortened form of selection tables in logical expressions

    cannot be used like selection criteria in GET events

    Br,

    Laxmi.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 03, 2007 at 04:14 PM

    Hi,

    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.

    Regards,

    Sruthi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.