Concept of Aggregates in APO

[Former Member]

Hi Everybody,

Can any one tell me -

What are Aggregates in the context of APO? What are their uses?

Thanks & Regards,

Ujwal Arora

[Former Member]

An APO aggregate contains a subset of the characteristics in the master planning object structure.

The creation and use of aggregates is optional. The data is always saved on the lowest level of detail. If aggregates exist, the system saves the planning data on the defined aggregate levels as well as on the lowest level of detail. The data is saved twice, but consistently; that is, the sum of the details equals the aggregate value.

The aggregates in APO are not the same as those in the Business Information Warehouse (BW), but they have the same purpose: to speed up data access and therefore increase performance. SAP recommends that you use aggregates in Demand Planning and Supply Network Planning

For example you are having Product Group -- P

Having Product as P1, P2, P3

Your forecast data for month 092008 for product P1 is 200

P2 300

P3 500

Then forecast data for product group P is for month 092008 is 1000

Aggregation is the summation at group level

[Former Member]

Hi

As Prabhu says these are the consolidated values of the lower level detail for the defined key figures, as standard there are quite a few aggregates for an SNP planning area:

9AAC (9AACTNAME)

9AACPR (9AACTNAME, 9APPMNAME)

9ALA (9ATRNAME)

9ALO (9ALOCNO)

9ALORE (9ALOCNO, 9ARNAME)

9AMA (9AMATNR)

9AMALA (9AMATNR, 9ATRNAME)

9AMALARE (9AMATNR, 9ARNAME, 9ATRNAME)

9AMALO (9ALOCNO, 9AMATNR)

9AMALORE (9ALOCNO, 9AMATNR, 9ARNAME)

9AMAPR (9AMATNR, 9APPMNAME)

9AMARE (9AMATNR, 9ARNAME)

9APR (9APPMNAME)

9ARE (9ARNAME)

9AREPR (9APPMNAME, 9ARNAME)

In transaction /sapapo/msdp_admin if you look at the detail of the planning area you will see on the tab "Key Figure Assignment" the aggregates associated with that planning area and the key figures assigned to the aggregate.

Regards

Ian

[Private_Member_738444]

Hi Ian,

In MSDP_ADMIN in our project I could see the following Aggregates :

When I see the next tab Key Figure Assignment, I could see many SNP KeyFigures assigned to these standard Aggregates.

My querry is why is the same KeyFigure assigned to multiple Aggregates?

ex :

1) The KeyFigure '0STOCK_QTY' - 'Inventory Quantity' has been assigned under 9ALA, 9ALORE, 9AMALA, 9AMALARIE, 9AMALO, 9AMAPR, 9ARE but it's not assigned to 9ASNPSTD! Why?

On what basis are these KeyFigure assigned to these Aggregates?

Thanks

Kumar

[Former Member]

Hi,

Normally the data's were stored at lower level (detail) ,so aggregates are nothing but storing the data at aggregate level to improve the performance of planning.

The data is always at location product level if its SNP the otherhand the data is always stored at CVC level if its DP.

Regards,

Prabhu