Why have to top down distribution in sap năm 2024

- [Narrator] In this lecture, we'll be covering top-down distribution. Top down distribution is used for the disaggregation of planning data. You might already be familiar with the distribution function in BIC, but top down distribution in BRIP is used in complex and high volume scenarios that cannot be made by the BIC function. There are two functions available. One is the distribution with reference and the other is distribution by key. In the planning scenario we're going to cover in this lecture, we're going to plan volumes by material group and fiscal year, and then distribute those volumes based on reference data to material and period. Let's look at what this top-down distribution is supposed to do. In my workbook I've added two queries. The detailed query, as well as an aggregated planning query, both offer quantities. The detailed query is by material, by material group, as well as by period. My…

Download courses and learn on the go

Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

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 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 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 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 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 5:Creation of new cycle with allocation type Top Down Distribution

Figure 6:Top Down Distribution Cycle - Header Details

Figure 7:Top Down Distribution Cycle - Segment Sender Details

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

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 10: Fiori App - Display Line items Margin Analysis - Before Allocation

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

Allocation Result:

Figure 12: Allocation Result in Network Graph

Figure 13: Allocation Result - Journal Entries

Reporting after Allocation:

App Name: Display Line Items – Margin Analysis

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

App Name: Market Segments - Actuals

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.

What is top

Top-down distribution is a functionality within Margin Analysis, in which revenue or costs can be distributed from an aggregated level to a more granular level, to enable a more detailed profitability analysis.

What is the top

The top-down approach focuses on the overall process. It starts with defining the overall business requirements that give the framework of the business process model. After that the model that describes how a requirement is fulfilled is split to separate business processes.

What is a top

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.

What is top

Top-down distribution differs from allocations because it does not change the amount on the sending object, it only distributes it to a more granular level (compared to allocations, where the sender is typically reduced with a certain amount). Top-down distribution is redesigned in the universal allocation framework.