| # 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: Demand Forecast Extra Demand Allowed Demand ERP 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): Demand Forecast Extra Demand Production Plan Purchase Plan After ERP 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 Automatic Update of Demand Forecast field in the Items - Planning (cprpd1100m000) session has one of the following values: (Dis)aggregate Always Update 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: Demand forecast Extra demand Allowed demand 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:
Plan period | 1 | 2 | 3
Retailer channel | 5000 | 7100 | 5000
Mail-order channel | 200 | 300 | 250
Other | 1000 | 900 | 900
Total | 6200 | 8300 | 6150
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:
Plan period | 1 | 2 | 3
Demand forecast | 6200 | 8300 | 6150
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:
From | To | Percentage | Update Mode
Demand Forecast | Demand Forecast | 100 | Overwirte
Extra Demand | Demand Forecast | 100 | Add-To
Related topics Channels in Enterprise Planning Aggregation of channels Scenario The scenario for which ERP 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. Related topics Scenarios in Enterprise Planning Planner Specify the first of a range of planners that ERP LN must use as a criterion to select plan items for aggregation. Planner Specify the last of a range of planners that ERP LN must use as a criterion to select plan items for aggregation. Period Select the first of a range of plan periods for which ERP 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 ERP 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 ERP LN must aggregate the demand data to the corresponding item master plans. Channel Specify the last of a range of sales channels for which ERP 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 ERP 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 ERP LN must aggregate the channel data to their corresponding item master plan. Demand Forecast If this check box is selected, ERP 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 ERP 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. Target Fields 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 If you enter 110, and the update mode is Overwrite, 110% of the aggregated source fields is stored in the target field. If you enter 20, and the update mode is Add To, 20% of the source field is added to the target field. If you enter 0, and the update mode is Overwrite, the target field is set to zero. 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: Demand forecast Extra demand Allowed demand 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, ERP 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 ERP 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. Target Fields 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 If you enter 110, and the update mode is Overwrite, 110% of the aggregated source fields is stored in the target field. If you enter 20, and the update mode is Add To, 20% of the source field is added to the target field. If you enter 0, and the update mode is Overwrite, the target field is set to zero. 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: Demand forecast Extra demand Allowed demand 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, ERP 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 ERP 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. Target Fields 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 If you enter 110, and the update mode is Overwrite, 110% of the aggregated source fields is stored in the target field. If you enter 20, and the update mode is Add To, 20% of the source field is added to the target field. If you enter 0, and the update mode is Overwrite, the target field is set to zero. 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: Demand forecast Extra demand Allowed demand 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. |