The Profitability and Performance Management (PaPM) is a native SAP HANA solution that maintains and executes complex calculations, rules and simulations for automatizing and improving all manual calculations. Before the CBS model was done in excel and this application was built to improve efficiency, reduce cash leakage and reduce non-compliance risk to reconsider the services invoicing process. The data can be analyzed for real-time data insights, and the traceability of the data allows easy identification of outliers or potential errors in data. PaPM outputs are built as queries where the data is compiled and edited. The Segmented P&L solution was introduce after to improve the process which was very complex and in excel and in this way the users can more accurately and regularly proactively update unit prices to target arm’s length outcomes. This will reduce the value of year-end adjustments, reducing double taxation and customs overpayments. |
Describe the key User profiles that exist for the application. General role/Viewer role: Approver role: Ask what is the role Ludovic |
Target Users: Transfer Price team and Financial Reporting team. |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 02.11.2023 | Inês Vilares | Initial draft |
|
Introduction on how CBS Project started In the Solvay Group, certain functions are performed by central service providers (and not within BU’s) for the benefit of companies in the Solvay Group as it is more economical and efficient for these to be performed centrally by specialists than separately by each group entity. Examples include Human Resources, Payroll, Invoicing, Credit Control, SBS IS .., these services are provided by organizations known as “Function Service Providers” which collectively form part of “Corporate & Business Services” (CBS). Similar services were performed centrally in both Solvay and Rhodia before Solvay acquired Rhodia. Following the acquisition there has been in a continuing process of internal merger and restructuring. This created a need for a new harmonized system of cost recording, reporting and invoicing of centrally provided services; this was referred to as the “CBS Project” and consisted of three sub-projects:
The CBS project was launched with three main objectives:
For each objective, there were corresponding main guiding principles. The CBS model has been managed in Excel until 2019. As Solvay seeks to improve efficiency, reduce cash leakage and reduce non-compliance risk, in 2020 EY was engaged to automate the CBS model using SAP’s Profitability and Performance Management (PaPM) application, to reconsider the services invoicing process, with a priority given to transpose and automate the existing process supported by the PaPM application. PaPM maintains and executes complex calculations, rules and simulations automatizing and improving all manual calculations. The data can be analyzed for real-time data insights, and the traceability of the data allows easy identification of outliers or potential errors in data. PaPM outputs are built as queries where the data is compiled and edited. It calculates the amounts to be charged and invoiced by each service provider entity to each entity that obtains benefit from the services that it provides. CBS Calculation - Old Process:
CBS Calculation - New Process (PAPM):
This is the level view of the new process see below more detail about this process using the PAPM application:
Timings
|
Previously the process for the Segmented P&L in Solvay was done mostly manually in MS Excel on a quarterly or annual basis. This work was done with complex files managed in Excel which were very time consuming and to slow to delivery the Segmented P&Ls, which caused slow provision of data for audits, TP Documentation (compliance statutory requirements) and planning. The Group incurs costs related to year-end adjustments: double taxation (corporate income tax) and customs overpayments, by producing the new solution for the Segmented P&Ls this will improve:
This new solution was implemented in PAPM application. Main objectives with this integration in the PAPM application:
Framework
To see more information about the process and how to work with this please check see the link for the Segmented P&L in PAPM and to see more details for the blueprint solution please see in the link 11490 Segmented P&L in PaPM BBP_PaPM Solution. |
This application it's used on the user side in the SAP system using some transactions to perform the full process and get the final values into BW and in a final excel. So, in this way, the user can check the final data using also the workbooks directly in excel using AfO (Analysis for Office).
To see the information in AfO for the BW data please check below the following workbooks:
PAPM: CBS Invoicing:
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| CBS WORKBOOK V1 WBP - PAPM data | This workbook is not used anymore. It was the initial output from the PAPM application with the data stored in BW. We only have this workbook available because contains historical data and calculations necessary for the main workbook to be used "CBS WORKBOOK V2 WBP - PaPM". | CBS_WORKBOOK_V1_WBP_20200626 | ||
| CBS WORKBOOK V2 WBP - PaPM | This workbook contain all the final calculations performed by the PAPM application where the users can check the values for the service invoicing. | CBS_WORKBOOK_V1_WBP_20210419 | ||
| CBS WORKBOOK V3 - PaPM - SCO | This workbook is the same as "CBS WORKBOOK V2 WBP - PaPM" but it was created only for SCo (Po2 scope). | CBS_WORKBOOK_V1_WBP_SCO |
PAPM: Segmented P&L:
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.
Could be specific fields, closing activities, additional information to work and understand the reports.
| Domain | Finance |
|---|---|
| Application | |
| Provider |