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

User exit for reducing Query lines!

Hello,

IS it possible to use a User Exit for queries to reduce my resultpackage before the lines arrive the reporting area?

For example:

I have a due date and in case of an entry of a field in the query result package the <exit> must read a reference from a info provider to decide if this line of this resultpackage can be load or not!

Query resultpackage

Contract :

a look up in, ODS for example, decision! delete line from package or not

and so on..

b Yes

v No

f

g

Short form:

Is it possible to manipulate the result package of a query in a user exit dynamically like described above??

AND how is it to implent?

Thank you for you answers!

By Rene

Edited by: NW-DEV on Oct 7, 2010 3:52 PM

Edited by: NW-DEV on Oct 7, 2010 3:55 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 07, 2010 at 03:17 PM

    Hi,

    Is it necessary that you do this on the fly (during query execution)?

    A simpler way to achieve this is by adding a column to your cubes ... say Flag . Update this flag, during transformations. This Flag field will indicate 'Marked for Deletion' and you can filter out records in the Query, by adding this Flag Field in Query Restrictions.

    If you want to achieve this during Query execution, you may need to use Virtual Characteristics(You can search for the code/implementation steps on SDN). Again Flag field will be the Virtual Characteristic and Query Filters will contain Flag value exclusions.

    Regards,

    Advait

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Advait Rao

      Hi,

      thank you, I think this could be the right direction.

      Please one further question.

      Is it possible to make a select entry in the first Slection screen of the query which can filter the "BAD" "GOOD" or "excelent" range?

      The question is, does the BAdi its work before the selection screen pops up or after inserting the filtercriteria.

      When the BADI is running before than it is perfect!

      By,

      best regards Rene

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.