display of aggregated data in a planning book

[Former Member]

Hello,

I am trying to display aggregated data for a characteristic value in the planning book even when i am on a detailed level.

Example :

I have 3 products belonging to 1 material group.

I have 2 customers.

For customer A, i want to see the quantity of all detailed products.

For customer B, I want to see the quantity of the materialgroup (on aggregate level) even if I only select 1 product.

Help is more than welcome

Frederik

Edited by: Frederik Verhaeghe on Dec 26, 2007 4:12 PM

[srinivas_krishnamoorthy]

If this is DP, you should be able to use the Header functionality on the Data View to view details. I am assuming that the customer and material groups are characterisitcs/Nav attributes in your DP design.

If this is SNP, I am afraid there is no straightforward way. I am guessing that you may have defined heirarchy using /sapapo/relhshow transaction. Another possible way in SNP would be to use the extra attributes to link a location product to a customer or a material group. This way these attributes can show up in selection ID as a criterion. You may then use drill-down functionality to navigate across these levels.

[Former Member]

Hello Srinivas,

Here a more detailed explanation of what I want to achieve with the macro builder.

Three materials are beloging to the Material group 001 in this example. (FV_2 and FV_3)

My intention is to display the quantity of all the material group for the value POOL, and not only the qty for FV_1. Even when I only diplay FV_1, I want to see the total POOL qty for FV1, FV_2 and FV_3.

Best regards,

Frederik

Edited by: Frederik Verhaeghe on Dec 26, 2007 5:43 PM