Exception Aggregation on BW/4 HANA

[sachinjakkaria]

Hi,

We need to calculate Stock in Transit Value. at material group level.

For which I need to calculate price at plant material level and multiple with Stock in Transit Quantity at Plant Material Level.

To achieve same, we are using exception aggregation (Plant Material ) on

formula ( Stock Val/ Stock Quantity *

Stock in Transits Quantity ) it works fine for 2-3 plant.

But when I execute at company level getting internal table memory error. It is not possible to increase memory at server level.

We have only 8 Material Group at which report to be displayed. Number of Material is 2 lacs and 300 Plant.

Any suggestion to achieve the desire report. We are trying to develop report on BW/4 Hana.

Regards,

S

[shraddha_mundwadkar]

what is the granularity of the report is it material group or plant & material & company code in drill down ?

[sachinjakkaria]

Hi Shraddha, out of report is required at Material Group. No need of drilling down at material or plant level.

Regards,

[shraddha_mundwadkar]

Hi Sachin,

Are you able to display data at CP level for same granularity for a company code?

Thanks,

Shraddha