Top-Down Distribution of Actual Data 

Use

In Profitability Analysis, sales revenues, sales deductions, and costs of goods manufactured are generally stored at the customer/product level. However, many business transactions - such as freight invoices, insurance expenses, or advertising - cannot easily be assigned to such a detailed level in CO-PA. Consequently, these need to be posted at a summarized level, such as the division, sales organization, or company code level.

Top-down distribution of actual data is a periodic function that lets you distribute this aggregated data to more detailed levels in CO-PA on the basis of reference information (such as the data from the previous year).

Freight invoices that for organizational reasons can only be posted by division can be distributed to sales organizations based on the anticipated freight costs. This function is only available with costing-based Profitability Analysis.

 

Features

The data is distributed according to existing "reference data". You can use either planning or actual data as a reference. You can also distribute period by period, or aggregate the period values to smooth out variances.

The system distributes the data by value field or according to how the values in the selected value field are distributed.

When top-down distribution is executed, values that are not assigned at the higher level (#) are distributed. Characteristic derivation occurs but only for those characteristics that were used in summarization (in other words, those values for which the summarized field in the processing instructions screen was selected).

You can perform distribution in any of the following ways:

Using top-down distribution of actual data can lead to quite large data volumes, since the data is distributed to a large number of profitability segments.

Assessment can be used to obtain a complete view while eliminating data volume at the same time:
For example, if you assess from n cost centers to m profitability segments in each case, you create n*m data records. As an alternative, you can first assess from n cost centers to one (or only a few) profitability segment(s), and then distribute this data to m segments. If the distribution factors for each cost center are the same, this technique only leads to 2+m records.

Activities

You execute the top-down distribution of actual data by choosing Actual postings ® Period-end closing ® Periodic adjustments ® Top-down distribution from the application menu.

Entries for the actual data

1. The posting periods or -- if you are using the alternative period type -- the weeks that you want to distribute

2. The record type of the data you want to distribute

Entries for the reference data

1. Enter the periods from which the reference data should be selected.

2. Specify whether you want to reference actual data or planning data. If you reference planning data, enter the plan version from which the data should be selected.

3. Enter the record type of the data you want to reference.

4. Select the Aggregate periods field if you want to add together the period values of the reference data rather than distributing them directly. This gives you the same value in each period for each segment, to smooth out incidental differences which occurred from period to period (see also Example: Period Aggregation).

 

If you select this indicator, your reference period can be as large as you want. Only if you distribute by period do the planning period and reference period have to be the same length.

Entries for the reference base

1. Select the Single value field if you want to distribute all the value fields in proportion to the values contain in one value field. You can use any value field or key figure (formula defined using value fields). The key figures you can use here need to be defined in Customizing.

2. If you have selected the Single value field, enter the value field that you want to use as the distribution factor.

3. Select the By value fields field if you want to use each single value field as the basis for how that value field is distributed. This means that the value field Revenue would serve as the basis for how the revenues are distributed. Quantity discount would form the basis for how quantity discounts are distributed, and so on.

Entries under Extras

1. Select the Test run field if you want to distribute your planning data without making any changes to the database.

2. Select the Background processing field if you are distributing for a large number of segments. The system will execute the function in the background so that your system is not loaded down unnecessarily.

Selection Criteria pushbutton

Here you can restrict the amount of profitability segments that you want to delete. You can enter one or more single values or an interval for each characteristic. All the values of that characteristic are distributed if you enter an asterisk (*).

Processing Instructions pushbutton

Here you can specify how each characteristic should be processed in top-down distribution:

· Distribution level: this is the level to which the data is distributed.

· Retain: the characteristic values remain the same.

· Summarize: the data for all values of the characteristic is summarized.

 

For those characteristics that are neither distributed nor distributed to, you should leave the default values for the following:

· The selection criteria *

· The processing instructions (generally the option Summarize, for some characteristics such as controlling area the option Copy/Transfer).

See also Example: Selection Criteria and Processing Instructions.

Value fields pushbutton

Here you specify the value fields of the operating concern that you want to distribute.