1.0 Overview




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.
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.

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










Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Excel file (Non-ERP and Drivers)
  • Others <specify the name of the source> 

2.0 Business Process



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:

  • P&L Structure;
  • BW Cost Tracking; and
  • Charging and invoicing of Centrally Provided Services.

The CBS project was launched with three main objectives:

  • Harmonize practices of Solvay and Rhodia legacies, with an extension to Cytec following its acquisition by Solvay in 2015;
  • Simplify and enhance visibility of global service charge for BU’s; and
  • Ensure compliance with accounting, legal and tax requirements

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:


Data input

  • Transaction data retrieved from BW (Actual Costs).
  • Driver amounts loaded directly in BW:
    • Standard Drivers;
    • Specific Drivers.
  • BW Version (Snapshot) before starting calculation in PaPM.
  • PaPM is based in PRS company code.

Actual Costs

  • The primary costs (including depreciation) as  recorded in ERP on cost centers dedicated to each function.
  • Amounts invoiced for services to third-parties are directly deducted in ERP from primary costs.
  • The primary costs related to Shareholder activity are deducted.
  • After application of the first allocation keys, some costs will remain within the same entity. An Overhead percentage is applied to Direct costs to cover that portion of the costs and the costs of services received.
  • Mark-up is added:
    • This is from a study of comparable independent service providers performed by EY.
  • Possibility to add manual corrections.

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:

  • Checks on a more regular basis, the users we 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.
  • A better Group-wide compliance with national & supranational regulations and lower tax audit risks by more consistently achieving arm’s length results for controlled transactions. 
  • Faster and more consistent data for tax audits. This faster and more consistent data can also be leveraged for tax & TP planning. In addition, the solution will free up time from the manual data processing tasks currently involved in preparing the Excel Segmented P&Ls, to be refocused on higher value analysis such as updating prices and other TP compliance tasks such as TP documentation, notifications and interco agreements.

This new solution was implemented in PAPM application. Main objectives with this integration in the PAPM application:

  • Add more transaction types in the transfer price table - aligning the table used for price setting with the transfer pricing classifications used in the Segmented P&Ls and TP Documentation.
  • Automate the calculation and allocation in PAPM, minimize manual workload, to migrate the Segmented P&L from Excel to PAPM.
  • Implement new Segmented P&L solution in PAPM for all Solvay Entities in WP1 and PF1.


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.

3.0 Application Feature Overview


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:

ReportsDefinitionPromptsBW Workbook QueryQuery 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 - PaPMThis 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 - SCOThis 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:

ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name















4.0 Functional Specification


4.1 General Data/Calculations 

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.


4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainFinance
Application
Provider









5.0 Non-functional Descriptions 


5.1 Usability

5.2 Regulatory Compliance

5.3 Security

5.4 Performance

5.5 Reliability

5.6 Scalability

5.7 Compatibility

5.8 Availability

5.9 Refresh of the Data