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

Exclusion and Inclusion

Hi Gurus,

What is this Exclusion and Inclusion in Query and where do we do this and how does this impact the performance of the query

what is this exactly.

Thanks and regards

Harish

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 06:06 AM

    hi Harish,

    in terms of performance, exclusion will have negative impact,

    avoid whenever possible.

    check related docs for query performance in

    hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2007 at 05:58 AM

    Hi,

    from context menu of characteristic >restruct >select either fixed/Variables tab from pop-up-->select a fixed value/variable >move it to right side window > from context menu of moved object-->you can see exclude from selection,offset..etc

    by default,selected fixed value/variable is included in selection which means that output will be restriced to this value.

    if you choose 'exclude from selection',then this value will be excluded from outout.

    You can see 'exclude from selection' in selection screen of Query also.

    for more details:

    have a look at <b>'Excluding variable values'</b> section in

    http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a563fe09411d2acb90000e829fbfe/content.htm

    Excluding variable values

    You use this function to select the values that you do not need for your report.

    This function is only valid for single value variables and not for variable quantities.

    1. Select the desired value in the right Selection window.

    2. Choose Exclude from Selection from the context menu (secondary mouse click).

    If you want to include the value in the selection again, choose Include in Selection from the context menu (secondary mouse click).

    thanks

    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.