Details (All (filter))

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks Harish and Srinivas. But these options are not working for me. I feel the requirement itself is crazy.

Thanks anyway for all the help.

[srinivas_krishnamoorthy]

I think it is a good idea to go through threads

Maybe since the individuals who posed the Q got around the problem, you can ask them how it got resolved finally.

[srinivas_krishnamoorthy]

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.