Universal Allocations – Top Down Distribution

This blog post explains Top-Down distribution in Margin analysis. Top-down distribution is a periodic function helps to distribute aggregated data to more granular level based on reference information such as revenue, customer group etc.

In margin analysis, KPI’s such as Revenue, Direct costs are generally captured at more granular level – Customer and Product level. However, business transactions such as advertisement costs are captured at higher level customer group and later distributed to more granular level with the help of Top-down distribution.

The original cost postings captured at higher level should have profitability segment such as customer group which is used to link sender data to corresponding reference data. In case the original postings do not have profitability segment (only at cost center), then need to perform overhead allocation (COPA assessment) to distribute the cost from cost center to profitability dimension at higher level such as customer group level. Refer my blog post on Universal Allocation – COPA Assessment for details. The second step is to perform top-down distribution to distribute at more granular level based on reference dimension such as customer group.

Figure%201%3AScenario%20taken%20for%20illustrating%20Top-Down%20distribution%20in%20Margin%20analysis

Figure 1:Scenario taken for illustrating Top-Down distribution in Margin analysis

Defining Top-Down Distribution Templates:

The templates control how each characteristic is used and processed in top-down distribution. They determine which margin analysis fields are shown on the different tabs of the allocation segment definition. They also influence the processing logic during top-down distribution.

Figure%202%3ADefine%20Template%20for%20Top-Down%20Distribution

Figure 2:Define Template for Top-Down Distribution

New template can be created by providing template name, description and allocation context is defaulted to ‘Margin Analysis’. Tolerance maintenance is optional.

Figure%203%3AMaintaining%20Processing%20Instructions

Figure 3:Maintaining Processing Instructions

Processing instructions maintenance is the key step in defining top-down template. By default, few characteristics are defaulted such as company code, profit center which cannot be deleted. We can also add or remove characteristics from the available directory as below:

Figure%204%3AAvailable%20Characteristics%20for%20processing%20instructions

Figure 4:Available Characteristics for processing instructions

There are four categories:

  • Distributed Value

This field is only used for reference data selection. In the distribution result, the value of this field is filled from the corresponding reference data.

  • Summarized Value

After sender data and reference data are selected, the value in this field is cleaned up. So, the corresponding sender data and reference data will be summarized. In the distribution result, the value of this field will be empty. However, for fields where derivation logic is predefined by SAP, the value will be filled through derivation.

  • Retained and Relevant to Reference

During distribution, this field is used to link sender data to corresponding reference data. In the distribution result, the value of this field is retained as it is in sender.

  • Retained but Irrelevant to Reference

During distribution, this field is not used to link sender data to the corresponding reference data. After distribution, the value in this field is retained in the distribution result as it is in the sender.

If you do not want characteristics which are set as “Retained and Relevant to Reference” or “Retained but Irrelevant to Reference” or ‘Summarized’ to be shown on the UI as selection criteria, you can mark the flag ‘Hidden on UI’. In this case, the fields will not be shown in the segment. However, the controls of the characteristics will remain.

Also, additional amount and quantity fields can be used for key figure reference.

Creation of Top-Down Distribution Cycle:

App Name: Manage Allocations

Key Features:

  • Use the Cost Centers, Profit Centers, and Margin Analysis allocation contexts for allocation cycles
  • Use the Distribution, Overhead Allocation/Intercompany Allocation, and Top-Down Distribution, allocation types for allocation cycles
  • Edit, create, copy, or delete allocation cycles/Segments
  • Conduct checks of allocation cycles and allocation segments
  • Navigate directly to the Run Allocations app to initiate the allocation run for one or more allocation cycles or view the details of completed allocation runs
  • Upload allocation cycle and segment definitions using a preformatted .xlsx file template.

Figure%205%3ACreation%20of%20new%20cycle%20with%20allocation%20type%20Top%20Down%20Distribution

Figure 5:Creation of new cycle with allocation type Top Down Distribution

Figure%206%3ATop%20Down%20Distribution%20Cycle%20-%20Header%20Details

Figure 6:Top Down Distribution Cycle – Header Details

Figure%207%3ATop%20Down%20Distribution%20Cycle%20-%20Segment%20Sender%20Details

Figure 7:Top Down Distribution Cycle – Segment Sender Details

Figure%208%3ATop%20Down%20Distribution%20Cycle%20-%20Segment%20Receiver%20basis%20Details

Figure 8:Top Down Distribution Cycle – Segment Receiver basis Details

Figure%209%3ATop%20Down%20Distribution%20Cycle%20-%20Reference%20Base%20Mapping

Figure 9:Top Down Distribution Cycle – Reference Base Mapping

Run Allocation:

App Name: Manage Allocations

Allocation cycle can be executed from the app Manage allocation or from the app Run allocations.

Line-item display report for original cost postings with profitability segment characteristics (Customer Group) at aggregate level:

Figure%2010%3A%20Fiori%20App%20-%20Display%20Line%20items%20Margin%20Analysis%20-%20Before%20Allocation

Figure 10: Fiori App – Display Line items Margin Analysis – Before Allocation

Figure%2011%3A%20Fiori%20App%20-%20Run%20Allocation%20for%20executing%20Top%20Down%20Distribution%20cycle

Figure 11: Fiori App – Run Allocation for executing Top Down Distribution cycle

Allocation Result:

Figure%2012%3A%20Allocation%20Result%20in%20Network%20Graph

Figure 12: Allocation Result in Network Graph

Figure%2013%3A%20Allocation%20Result%20-%20Journal%20Entries

Figure 13: Allocation Result – Journal Entries

Reporting after Allocation:

App Name: Display Line Items – Margin Analysis

Figure%2014%3A%20Fiori%20App%20-%20Display%20Line%20items%20Margin%20Analysis%20-%20After%20Allocation

Figure 14: Fiori App – Display Line items Margin Analysis – After Allocation

App Name: Market Segments – Actuals

Figure%2015%3A%20Fiori%20App%20-%20Market%20Segments%20Actuals%20-%20Validating%20results

Figure 15: Fiori App – Market Segments Actuals – Validating results

Conclusion

This blog post provides insights on Top Down Distribution in Margin analysis for distributing aggregated data to more granular level based on reference information. Share your feedback in the comment section.

Please follow my Vijay Arumugam for future posts.