cancel
Showing results for 
Search instead for 
Did you mean: 

aggregation and dis aggregation types

Former Member
0 Kudos

can any one explain mee the aggregation and dis aggregation AND P E N L K AND S P A N I types.

create time series objects

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I suggest you to follow SCM220 - Demand Planning.

Check this out:

Calculation Type for a Key Figure

Specifies whether and how this key figure is aggregated and disaggregated. This setting is valid for all of the planning books in which the key figure is used. You choose from the following options:

S - Pro rata

Pro rata disaggregation works in two ways, depending on whether you are creating or changing the demand plan:

If you create data on an aggregate level, the data is distributed to the lowest level of detail in equal proportions.

If you change data on an aggregate level, the values at the detailed level change so that each one represents the same proportion of the aggregate values as before.

P - Based on another key figure

The data is distributed to the lowest level of detail in the same proportions as those that can be derived from the values of another key figure. For example, you can apply the proportional distribution of the key figure "Baseline/statistical forecast" to the key figure "Manual adjustment". Note, however, that if no values exist for the key figure "Baseline/statistical forecast", no disaggregation takes place.

If you enter 'P', you must also specify on this screen the key figure on which disaggregation is based. Do this in the field Disaggregation key figure.

If you wish the data to be distributed to the lowest level of detail in accordance with the constant proportional factors, select option 'P' and choose the key figure Proportional factor APODPDANT in the field Disaggregation key figure. You generate the constant proportional factors as part of the master data before you start to plan.

Note: This is only possible for time series key figures and key figures from an InfoCube. Both the key figure and the key figure upon which the disaggregation is based must be time series key figures or originate from the same InfoCube.

A - Average of key figures

The average of the key figure values on the next lower aggregation level is displayed at runtime. Use this option for key figures that represent percentages (for example, the percentage difference between this year's and last year's forecast) or sales prices (for example, sales price per unit). If you enter a value on a high level, the system disaggregates it by copying the value to the details on the lowest level.

D- Average at the lowest level of detail

In contrast to calculation type A, the system uses the values at the most detailed level, that is the level for which each characteristic has a single value assigned, to form the average. This can result in different numerical values in comparison to type A.. For more information, see the SAP Library documentation Aggregation and Disaggregation under Creation of the Demand Forecast.

N - No disaggregation

Disaggregation costs performance, so set this option for text rows, auxiliary rows, and other rows that do not need disaggregating.

I - Pro rata, except for the initial disaggregation, which is based on another key figure

If you create data on an aggregate level, the data is distributed to the lowest level of detail in the same proportions as those that can be derived from the values of another key figure. For example, you can apply the proportional distribution of the key figure "Baseline/statistical forecast" to the key figure "Manual adjustment". Note, however, that if no values exist for the key figure "Baseline/statistical forecast", no disaggregation takes place.

If you enter 'I', you must also specify on this screen the key figure on which disaggregation is based. Do this in the field "Disaggregation key figure".

If you change data on an aggregate level, the values at the detailed level change so that each one represents the same proportion of the aggregate values as before.

Type of Time-Based Disaggregation

Defines how planning data is disaggregated in time. The time buckets in which data is saved are given by the storage buckets profile. For example, if you select months and weeks in the storage buckets profile, data for June and July 2000 is saved in the following storage buckets:

- June 1-4 Thursday through Sunday 4 days

- June 5-11 Monday through Sunday 7 days

- June 12-18 Monday through Sunday 7 days

- June 19-25 Monday through Sunday 7 days

- June 26-30 Monday through Friday 5 days

- July 1-2 Saturday and Sunday 2 days

- July 3-9 Monday through Sunday 7 days

- July 10-16 Monday through Sunday 7 days

- July 17-23 Monday through Sunday 7 days

- July 24-30 Monday through Sunday 7 days

- July 31 Monday 1 day

P - Proportional distribution

Data is distributed in time so that each key figure value in the smallest storage bucket represents the same proportion of the value in the aggregate bucket as before.

If the key figure values prior to distribution were zero, and if a time stream ID forms part of the storage buckets profile definition, the system checks to see if time-based weighting factors exist for this time stream. If so, the data is distributed according to the time-based weighting factors of the time stream. If no factors exist, the data is distributed equally to each storage bucket.

E - Equal distribution

Data is distributed equally to each storage bucket.

This option is available only for key figures that were not defined as fixable in the Admin Workbench.

N - No disaggregation in time

The value in the planning bucket is copied to the storage buckets; for example, a planning value of $100 for the month of June is copied to each of the storage buckets June 1-2, June 5-9, June 12-16, June 19-23, June 26-30. If you display the planning value for June at run time, the system shows the average value of the storage buckets.

This option is available only for key figures that were not defined as fixable in the Admin Workbench.

K- Based on another key figure

This option is basically the same as calculation type P.

The data is distributed to the lowest level of detail in the same proportions as those that can be derived from the values of another key figure. For example, you can apply the proportional distribution of the key figure "Baseline/statistical forecast" to the key figure "Manual adjustment". Note, however, that if no values exist for the key figure "Baseline/statistical forecast", no disaggregation takes place.

If you enter 'K, you must also specify on this screen the key figure on which disaggregation is based. Do this in the adjacent field "Disaggregation key figure".

SAP recommends that if you use option 'K' for time-based aggregation, you also use calculation type 'P'

Note: This option is only available for time series key figures.

L- Read: Value from last period; Write: No allocation

This aggregation type is intended for time series SNP.

When you aggregate from shorter time buckets to larger, for instance weeks to months, the system take the value from the last period and copies it to the larger time bucket. In the reverse case, the value is written to all the smaller time buckets.

Answers (0)