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

Performance issue while coding

Hi Experts,

If we use ranges in a particular report, could u please explain in detail whether the performance decreases or increases?

Thanks & Regards,

Maha.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2008 at 01:11 PM

    Hi,

    If u user ranges instead of select options, performance wise it wonÂ’t show much difference.

    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.

    REWARD IF IT IS USEFUL.

    Thanks

    Siva kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2008 at 05:03 AM

    Hi,

    Ranges : we can use it when no need of selection-screen for to enter values for that field.

    So at initililization section of u r program u need to write the code for populating the values to ranges field.

    If u do like above time consumption is less(because saving of GUI time and user input time for that field). It is useful when one program execution depends on other program output values. And u need use SAP and ABAP memory for getting values.

    So Ranges mainly used for background jobs.

    And also if u written SQL statements (like select) in Function module then u can use only Ranges to pass values to import parameters of function module.

    More over ranges and select-options have same structure.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2008 at 01:43 PM

    Hi,

    Select-options lead to an internal table in the background having structure for eg.

    Sign = I/E

    Option = EQ/BT/ GT/LE ....

    Low = Low value which u feed in the first input box

    High = High value which u feed in the second input box

    The advantage u get is that u can have multiple option attached to select-options that u can have the data filled onto the screen , u can use multiple options attached to select-options such as NO Interval..and u can have multiple selection on the selection screen.

    While in Ranges u don't have liberty of all these things as u it is filled at runtime with the data from select query ..

    PS: Reward Points if helpfull.

    Regards

    Naveen Gupta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 05:13 AM

    Hi Mahalakshmi,

    Using ranges generally deteriote the performance as internally SAP Kernal expands IN statement in Where Clause in various conditions.

    Using FOR ALL ENTRIES is much preferrable.

    I said generally as performance will be good by using Ranges in case you have few big ranges. Example : Inclusive Between 100 to 10000... In such case using FOR ALL ENTRIES will take more time to execute.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 12:20 PM

    Hi,

    it increases. But based on select statement will differ performance .it will not take more time.

    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.