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

Filter and FreeCharecteristics

Hi,

what are filters and Free charecteristics in query designer?

when do we use them.

what are its purposes?

can we use both chars and keyfigs in both the filters nad free chars?

Thnaks,

Naresh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2009 at 03:56 PM

    Hi.

    Free chars in query designer are all characteristics that you dont use directly in lines of query.

    You can restrict values of free chars after query execution.

    Filters created in IP (integrated planning) and used in query for planning (input ready query).

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2009 at 05:56 PM

    Hello Naresh,

    1) If you have some characters which the users doesn't wants to see when the query is executed but there should be a provision to bring these characters in the query display, then you put those characters as free characteristics.

    2) If you have to restrict particular characters with specific values and if you dont need them in the query display then you put them in filter pane and restrict them.

    As far as I know u cant use key figures in filters and free characteristics.

    Regards,

    T-Bird.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      As mentioned above:

      Filter restricts the data that gets displayed in the report. You can filter the query base don characteristics and using manual input variables , authorization variables, Customer Exit variables, Replacement path variables ans SAP Exit variables.

      Filters removes the unnecessary data from getting displayed.

      Free characteristics are those characteristics which are not directly displayed at the start of the query output. The user drags & drops in the output according to his needs. These are characteristics only which help further analysis of data.

      Regards,

      Sachin Shetty

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2009 at 02:48 PM

    Filters : Values which the query data should be restricted. You can use characteristic with any set of values and key figures only with one value in the filter tab.

    Free Characteristic: Objects which you don;t want the query to intially display but at the same time if the user wants he can do a detail analysis on all the objetcs which are in the free characterisitc tab.

    Rgds

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2009 at 05:47 AM

    Hi All,

    Thanks 4r ur Replies.

    i) Please tell me ,can we use keyfigures in filters and free charecterists.if ,yes Also tell me can we use both calculated and restricted keyfigures in filters and how many are allowed to use ?

    ii) What is the difference between Filter and conditions? and in which case we use each of them?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2009 at 11:00 AM

    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.