Distribution by Key 

Use

You use the Distribution by Key function type to generate the characteristic combinations to which data is distributed in accordance with the master data and characteristic relationships. The key figure values are distributed according to the expressly specified distribution keys. These are distribution functions that determine the weighting of the distribution.

For an introduction to how a planning function of type Distribution by Key works, see Process Flow of Planning Function: Distribution by Key.

You use the table for key figure selection to select the key figures that you want to distribute.

You can control the distribution process in different ways:

●     Distribution with a top-down variant

○     Distribute All: The entire block is totaled.

○     Only Distribute Not Assigned: Values are only distributed if they have the characteristic value Not Assigned [#]  in the current block for all of the characteristics to be changed.

●     Distribution using manually created entries in the From and To Values for Distribution table.

You can create one or more distribute operations by manually entering the characteristic restrictions for the characteristics that are to be changed.

The system continually totals the values of the key figures on the From side over all the records in the block that correspond to the characteristic restriction, and distributes this total to the To values.

With the From and To Values for Distribution table you can either enter a specific value in the Factor column or select a formula variable from the input help for the To values. The system displays them in the Factor Variable Text column.

If the characteristic restriction of a To value is not a single value, this key is valid for every characteristic combination that corresponds to the characteristic restriction.

The keys are normalized during processing; they are converted into percentages. The system first totals the distribution factors that are assigned to the individual characteristic values and then distributes the values relatively. This results in percentages that always add up to 100 %.

The same key applies to all the key figures to be distributed for each planning function. 

Combinations are generated on the To side for the specified characteristic restrictions. This is consistent with the master data and the characteristic relationships defined for the InfoProviders. If the system cannot find a target for a block and a subprocess, the system terminates the function and produces an error message.

The system performs the following steps to execute a planning function of type Distribution.

...

                                                  i.       The total amount to be distributed is determined.

                                                ii.       For the data records that are affected by the From values, the key figure values are deleted.

                                               iii.       In accordance with the distribution keys, the totals are added together with the key figure values of the data records selected by the To values.

The following rules apply:

●     Both the From and To values are changed and have to be included in the filter that is transferred to the planning function.

If the From value is created so that it can select data records that are not in the filter, the system does not produce an error message. The data records are not part of the distribution.

If the To value is created so that it can select data records that are not in the filter, the system terminates the entire planning function and produces an error message.

If a target has been specified in one or more subprocesses, the function is executed and as a result, the target contains the appropriate totals.

●     Rounding differences are distributed evenly to those target data records that are not equal to zero.