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

Details (All (filter))

Hi,

Is there a way to recognize when a user drilldown to Details (All (filter)).

I can't see any macro functions related to this. If I have to display a warning message in a macro (or some other way) when ever a user drills down using Details (All (filter)).

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 05, 2008 at 12:16 AM

    Using AGG_LEVEL() or DET_LEVEL()

    Here is a help text on DET_LEVEL. IN your case using characteristic in parameter is optional.

    Syntax

    DET_LEVEL('characteristic' [; EXCLUDE_IMP] [GRID=2] )

    Characteristic = Technical name of the characteristic that is to be analyzed

    EXCLUDE_IMP: If you set this optional indicator ('X'), implicitly strong characteristics are not taken into account in the analysis.

    GRID=2: If you set this optional parameter, the analysis is applied to the planning object of the second grid.

    Description

    The DET_LEVEL() function analyzes whether the planning object being currently processed is detailed or aggregated with regards to the characteristic characteristic. If detailed, the return value is ‘1’; if aggregated, the value is ‘0’.

    Examples

    Example 1:

    You have selected the products P1 and P2 (characteristic 9AMATNR). DET_LEVEL( '9AMATNR' ) will provide the return value '0' for this planning object because you are at aggregated level with regards to the characteristic 9AMATNR.

    Example 2:

    The products P1 and P2 are only in location L1 (characteristic 9ALOCNO) due to the characteristics combinations maintained (in DP) or location products (in SNP). You have selected the products P1 and P2 (characteristic 9AMATNR). DET_LEVEL( '9ALOCNO' ) will provide the return value '1' for this planning object because you are at detailed level with regards to the characteristic 9ALOCNO. The 9ALOCNO characteristic is implicitly strong in this case (namely location L1) due to the selection of products P1 and P2 and it is used in the analysis. DET_LEVEL( '9ALOCNO' ; 'X' ) will deliver the return value '0' for this planning object because implicitly strong characteristics are not used for the analysis. A drilldown to the characteristic ‘location’ would characterize it explicitly.

    Add a comment
    10|10000 characters needed characters exceeded

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

    i assume this is related to the question on details all (filter) total not matching the total displayed

    i am not sure if you can identify the difference between details all and details all (filter) with just a few char values chosed for drill down

    since you cant choose details all (filter) and choose just a few characterisitic values there i dont see the reason for a popup...

    anyhow , there are a couple of other options you can try

    what you can do is try to use SUM_CALC()

    SUM_CALC( key figure ) calculates the sum of all detail levels of the specified key figure.

    assuming this can sum only the

    if you can compare this against the total thats displayed you might be able to get

    also not sure if you can use DELTA_SUM() since its used in CBF usually....

    DELTA_SUM( key figure, drilldown level) runs the DELTA_SUM function for the specified key figure at the

    specified drilldown level. For more information, see SAP Note 610517. This macro function can only be used at detail level.

    610517 - Deliberately Inconsistent Disaggregation in CBF

    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.