Issue

This design decision document addresses the need for Syensqo to have a comprehensive profitability analysis through multi-dimensional account-based Profit and Loss (P&L) reporting to:

• Support decision-making
• Ensure compliance
• Provide real-time insights into business performance.
• Utilize universal ledger as the data pool.

The current Profit & Loss (P&L) reporting system lacks uniformity due to different reporting characteristics in the two primary data entry systems, WP1 and PF1, as well as the old system architecture that relies on secondary data and aggregate tables. As a result, Syensqo depends on numerous satellite reporting systems and custom solutions to provide uniform, multi-dimensional profitability analysis. A decision is needed to choose between account-based margin analysis and costing-based profitability analysis to address these deficiencies. It is important to note that the purpose of this design decision document is not to determine the P&L structure or the dimensions/characteristics, as these will be addressed in the detailed design phase. This decision aims to fulfill the business need for detailed, uniform, real-time profitability insights that align with the trial balance and ensure accuracy.

Recommendation

Implement Margin Analysis utilizing Account-Based Profitability Analysis instead of Costing-Based Analysis.

• This approach will enhance integration with financial accounting by consuming data directly from the transactional table.
• Provide real-time data access, and leverage the capabilities of Universal Ledger. e.g Ledger approach capabilities like P&L by ledger and currency type. 
• Additionally, it will improve online analytical processes by reducing the need for satellite system reports and possibly systems. (e.g Finance - several dashboards, BW,BI, Qlicksense, Qlickview etc)

Background & Context

With evolving business complexities and the need for granular profitability insights, traditional reporting mechanisms fall short. Account based Margin Analysis offers a robust solution for detailed profitability analysis by integrating with the Universal ledger, thus eliminating reconciliation issues and enabling multidimensional reporting directly at the source. 

Technical Overview of the S4 Account-Based Margin Analysis

Margin Analysis leverages the Universal Journal (table ACDOCA) to integrate financial and managerial accounting data into a single source of truth. The Universal Journal consolidates data from various submodules such as General Ledger (FI-GL), Asset Accounting (FI-AA), Material Ledger, and Controlling (CO). This integration ensures that all financial transactions, including those relevant for profitability analysis, are stored in a single table (ACDOCA), the so-called Universal ledger which includes detailed line items for each transaction. In the Syensqo world this will means that it will be possible to have the P&L already prepared in the data entry system by activity and reconciled with the trial balance.  

Account-based CO-PA utilizes the same dimensions and characteristics available in the Universal ledger. These include company code, profit center, segment, cost center as well as and more crucially the sales flow related dimension, like customer, product, sales channels etc. To be decided.

As transactions occur, data is instantly updated in the Universal ledger, providing real-time insights without the need for batch processing or data reconciliation with the trial balance. The Universal Ledger supports detailed COGS splitting by G/L account, enabling precise allocation of costs to respective profitability segments.

Enhanced Reporting Capabilities:

• Multidimensional Reporting: Users can analyze profitability across multiple accounting, controlling and sales dimensions such as, Ledger, product, customer, region, business unit etc.
• SAP Fiori Applications: Account-based CO-PA leverages SAP Fiori applications that allow for real-time data slicing and dicing.
• Traditional SAP GUI Reports: For users familiar with the classic SAP interface, traditional reports are available that can utilize the same real-time data from the Universal Ledger.

Performance Optimization

Elimination of Redundancies, by maintaining a single source of truth, data redundancies are eliminated, significantly improving data accuracy and reporting speed. Moreover, custom fields can be added to the Universal Journal to capture additional profitability characteristics specific to Syensqo's business needs or units of measure.

Assumptions

• Syensqo will implement S/4
• The data volume will be substantial, necessitating efficient data processing capabilities
• Standard SAP Fiori apps, customer CDS views and standard SAP GUI transactions, like KE30 will be available for reporting.

Constraints

• There may be a need for customization to fully leverage all reporting capabilities. Like custom CDS views.

Impacts

New uniform dimensions/characteristics as well as new P&L structure will be defined during detailed design

Business Rules

• All profitability transactional data must be integrated into the Universal Ledger
• New dimensions/characteristics will be defined during detailed design to cover various dimensions such as product lines, geographies, and customer segments.

Options considered

Option A: Implement Account-based profitability analysis

Option B: Implement costing based profitability analysis

Evaluation

	Option A: Account based	Option B: Costing based	Option C	Option D
Integration	Seamless with Universal Ledger Con	Separate data persistence, requires reconciliation Pro	Pro Con	Pro Con
Reporting Capabilities	Supports multidimensional reporting Margin analysis is fully integrated with the Universal Journal and derives the appropriate characteristics on every journal posted to the Universal Ledger that can feed into SAP Analytics Cloud. Con	Con	Pro Pro	Con Con
Future compatibility	SAP encourages its customers to move to margin analysis, where all the innovation and investment are focused.	Con	Con	Pro
Performance

See also

Change log

Workflow history