The scenario for which LN must aggregate channel
data to the corresponding item master plans.
If the scenario's plan status is Closed, you can no longer modify this scenario.
Aggregate Channel to Item Master Plan (cpdsp5210m000)Use this session to aggregate information from channel master plans to their corresponding item master plans without using the aggregation relationships that you defined in the Aggregation Relationships (cprpd3110m000) session. You can aggregate the following fields from the channel master plan (the source fields) to the item master plan:
LN calculates the total value of the source fields that you select over all channels of the specified plan items. Then, this total value is copied to one of the following fields in the item master plan (the target fields):
After LN aggregates the channel data to the item master plan, it automatically updates the data. How to use this session Define the relationship between items and channels in the Plan Item - Channels (cpdsp5100m000) session. Aggregation of data to the Demand Forecast field in the item master plan is only possible if the Demand Forecast field in the Items - Planning (cprpd1100m000) session has one of the following values:
Similar restrictions apply to the aggregation of production plan and purchase plan. Percentages You can modify the aggregated values by a certain percentage. For example, you can reduce the value by 50%, or raise it by 20%. Overwrite or add Usually, the aggregated value of the source field overwrites the value of the target field. Instead of overwriting, you can also add the quantity of the source field to the target field. Use the Update Mode field to do so. Important The session processes the source fields in the following order:
If you aggregate multiple source fields to a single target field, you must set the Update Mode field of the first source field to Overwrite and the update mode of the other source fields to Add To. Basic example The following table shows an item's demand forecast for three channels:
You can aggregate the demand forecast fields of the channel master plans to the demand forecast fields of the item master plans. The result is shown in the following table:
Note You can also copy the demand forecast fields of the channel master plans to the extra demand fields of the item master plans. Example of aggregating multiple source
fields Use the following field values to copy the demand forecast and the extra demand of the channel master plans to the demand forecast of the item master plan:
Scenario The scenario for which LN must aggregate channel
data to the corresponding item master plans. If the scenario's plan status is Closed, you can no longer modify this scenario. Planner Specify the first of a range of planners that LN must use as a
criterion to select plan items for aggregation. Planner Specify the last of a range of planners that LN must use as a
criterion to select plan items for aggregation. Period Select the first of a range of plan periods for which LN must aggregate the
channel data of the specified plan items to the corresponding item master
plans. Period The start date of the plan period that you
specified in the Period field. Period Select the last of a range of plan periods for which LN must aggregate the
channel data of the specified plan items to the corresponding item master
plans. Period The end date of the plan period that you
specified in the Period field. Channel Specify the first of a range of sales channels for which LN must aggregate the
demand data to the corresponding item master plans. Channel Specify the last of a range of sales channels for which LN must aggregate the
demand data to the corresponding item master plans. From Plan Item Specify the first of a range of plan items for which LN must aggregate the
channel data to their corresponding item master plan. To Plan Item Specify the last of a range of plan items for which LN must aggregate the
channel data to their corresponding item master plan. Demand Forecast If this check box is selected, LN aggregates the demand forecast from the
channel master plans to the demand forecast or the extra demand in the item
master plan of the corresponding plan item. Demand Forecast The target field in the item master plan to which LN copies the channel
master plan's demand forecast. Only the values Demand Forecast and Extra Demand are available for aggregation of the demand forecast to the item master plan. Demand Forecast The percentage of the aggregated demand forecast that is stored
in the target field or added to the target field (depending on the update
mode). Example
Note A value of 100% is appropriate in most cases. Demand Forecast If the update mode is Overwrite, the values of
the target fields are overwritten by the source values. If the update mode is Add To, the source values are added to the values present in the target values. Note The session processes the source fields in the following order:
If you aggregate multiple source fields to a single target field, you must set the update mode of the first source field to Overwrite and the update mode of the other source fields to Add To. Extra Demand If this check box is selected, LN aggregates the extra demand from the
channel master plans to the extra demand or the demand forecast in the
master plan of the corresponding item. Extra Demand The target field in the item master plan to which LN copies the channel
master plan's extra demand. Only the values Demand Forecast and Extra Demand are available for aggregation of the extra demand to the item master plan. Extra Demand The percentage of the aggregated extra demand that is stored in
the target field or added to the target field (depending on the update mode). Example
Note A value of 100% is appropriate in most cases. Extra Demand If the update mode is Overwrite, the values of
the target fields are overwritten by the source values. If the update mode is Add To, the source values are added to the values present in the target values. Note The session processes the source fields in the following order:
If you aggregate multiple source fields to a single target field, you must set the update mode of the first source field to Overwrite and the update mode of the other source fields to Add To. Allowed Demand If this check box is selected, LN aggregates the allowed demand from the
channel master plans to the production plan or the purchase plan in the master
plan of the corresponding item. Allowed Demand The target field in the item master plan to which LN copies the channel
master plans' allowed demand. Only the values Production Plan and Purchase Plan are available for aggregation of the allowed demand to the item master plan. Allowed Demand The percentage of the aggregated allowed demand that is stored
in the target field or added to the target field (depending on the update
mode). Example
Note A value of 100% is appropriate in most cases. Allowed Demand If the update mode is Overwrite, the values of
the target fields are overwritten by the source values. If the update mode is Add To, the source values are added to the values present in the target values. Note The session processes the source fields in the following order:
If you aggregate multiple source fields to a single target field, you must set the update mode of the first source field to Overwrite and the update mode of the other source fields to Add To.
Aggregate Starts the aggregation process.
| |||||||||||||||||||||||||||||||||||||||||||