The P&L information is generate by the SAP CO module. It is a module in the SAP ERP (Enterprise Resource Planning) system that focuses on financial controlling and management accounting functions within an organization. SAP CO is designed to provide tools and capabilities to effectively manage and control costs, perform internal and external accounting, and support decision-making processes related to financial aspects of the business. SAP CO is tightly integrated with other SAP modules, such as SAP FI (Financial Accounting) and SAP MM (Materials Management), providing a cohesive and comprehensive solution for managing financial data, controlling costs, and supporting financial decision-making throughout the organization.

The P&L business process, is initiated  with the financial data stored and managed in the SAP CO module. However, the data in the SAP CO module might not be organized in a way that aligns directly with the requirements of the official report tool. In Solvay the official report tool is BFC which is designed to consolidate financial data from various sources, including SAP systems like SAP CO, and transform it into a compliant format for generating official reports required by the company.

The process involves extracting financial data from the SAP systems through an interface, which translates the data into the format compatible with the BFC tool. Once the data is in the proper format, it can be imported into the BFC tool, which then performs the consolidation and generates the official reports according to the company's specific guidelines. This integration between SAP CO and the BFC tool ensures that the financial data is accurately consolidated and reported in a standardized manner, meeting regulatory and internal reporting standards. It also streamlines the reporting process and improves data accuracy by centralizing financial information from various SAP systems into a single platform for financial consolidation and reporting.

Also, Solvay uses the SAP BW (Business Warehouse) tool to enhance and extract reports with data coming from the transactional systems (mainly WP1 & PF1) that enable the compay to have the adjustments/enhacement for some fields/calculations to allow the users to realize their analysis on a more efficient way and to perform checkings/controls on the P&L data in alignment with BFC struture. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources.

SAP BW levereged the P&L in the following ways:

• P&L report aligned with BFC structure (BFC Headings) down to REBIT / REBITDA;(Non core Group activites_ CM)
• Data available at BFC View (Company / Activity) and ability to drill down to Customer / Material level;
• Unique P&L for all entities using Solvay Core Systems (PF1+WP1);
• Dynamic restatement of periods based on automatic rules;
• Consolidation figures as in BFC, allowing P&L at GBU level aligned with group definitions;
• Currency conversion as in BFC;
• CICC data taken directly from BFC;
• Interface to upload data from other ERP than WP1/PF1;
• Elimination Profit in Inventory (R15430) available in the reporting;
• Query for monthly data and YTD data follow up;
• Reconciliation query BFC vs BW for P&L;

In here we will find the different parts of the process for P&L data into BW:

• SAP BW High Level View
• P&L - Characteristics
• GBU Assignment
  • WP1 Logic
  • PF1 Logic
• Partner Activity
  • Determination of the partner activity in WP1
  • Determination of the partner activity in PF1
• Non-ERP data in P&L
• Exchange Rates for P&L
• P&L at Sales Order
• Characteristics to determine the country/zone
• Characteristics to determine the production plant
• Service Invoicing solution in PF1

You can find below the list of all characteristics and some measures available in P&L queries,

Type in your keywords in the field "Text search"

The field "Object Bi4" gives the main correspondance with the object available in Bi4 PPE

<!-- Place this tag where you want the Awesome Table Widget to render -->
<div data-type="AwesomeTableView" data-viewID="-Ly-6Y1GLSqgWhIuA5es"></div>

<!-- Place this within the <head> tag or just before the end of your <body> tag. -->
<script src="https://awesome-table.com/AwesomeTableInclude.js"></script>

Currency:

The data currency comes from the PRS company code of the file. The currency of the sales ind document currency is the only one that can be managed in the excel flat file.

Amounts are integer keyfigure:

All amounts must be integer. No decimal (loading will be rejected).

Summation and overwriting:

All amounts with the same key will be:

• added if they are in the same file
• overwritten if they are in a different file

In order to avoid data overwriting, master data Customer & Material and transactional data must be attached to a system source starting with NERP* (for example NERP001 or NERPCYT).

So the business will need to create a new NERP source system and add 2 entries one for GM and one for ZBW_PL_PC:

For ZBW_PL_PC stream if they have this active (Y) option mean Profit center is mandatory and using c_glbfilt parameter (steam = "FULLFF", rule = "NERP"), they control the list of source systems for which a full flat file is required:

Several conversion methods can be used in BW. The aim of this page is to explain the main methods used in BW:

• CAR3 - Monthly Rate
• C - Year-to-date Monthly Average Rate 
• BFC Methodology

The rate CAR3 can be found in the GAR library. It is available in the sheet "Taux - Rates (Monthly)". It corresponds to average rate of the month.

Year-to-date Monthly Average Rate comes from BFC. It is the sum of monthly rates divided by the number of months from the beginning of the year.

The Rate C can be found in the GAR library. It corresponds to the rate "MOYEN / AVERAGE" in the sheet "Taux - Rates"

The aim is to use the same methodology as the one used in BFC

• It is used in queries/workbooks with "monthly" in their descriptions

The exchange rate used for the conversion of the material code 11365 is $ 13 280,00 / 11 729,54 EUR = 1,13218. It is different from the one used for the material 11366 = $ 387 991,60 / 342 157,77 EUR = 1,13395

1- Difference between Rate C & Rate CAR3:

See the following example. 

• In January the rate CAR3 is equal to 1,21, in February it is equal to 1,24 and in March it is equal to 1,20. 
• In January the rate C is equal to the rate CAR3 but in February it is the sum of the CAR3 of January and February divided by 2 months. In March it is the sum of the rate CAR3 of January, February, March divided by 3 months. 

2- We need to use a specific workbook when we want to work with the BFC methodology because when using a monthly query, BW recalculates all the items of the query with the BFC calculation methodology. It does not apply a single exchange rate but it is a complex calculation that can not be done in a standard query. 

3- The recommendation for which rate we should use is:

• If you want to have the same result as BFC, you must use a query with "monthly" in its description. However the response time can be deteriorated as BW calculates the conversion rate for all items. 
• By default the rate C is used in the applications FC - Create a fixed costs report & P&L Reporting (WBP). Month by month it can not be aligned with BFC but it is when you look at the full year. The response time is better than monthly queries. 
• You must use the rate CAR3 if you want to have the same result as CRM Analytics Dashboard. 

There are different characteristics used to determine the country or zone:

• Company code Country [C_COMPCDE__0COUNTRY]
• Geography / Zone [C_COMPCDE__C_ZONE] or BFC Gestion Area [C_COMPCDE__C_MNGAREA]

In some cases the characteristics are not consistent. For instance a company in Mexico can be in North America or Latin America depending on the characteristic used:

The aim of this page is to explain where does each characteristic comes from

There 4 characteristics in the application P&L that can be used to determine the production plant

• Batch Origin_P
• Origin Plant
• Production plant in material_W
• Industrial Origin

"Batch Origin_P" comes from the field "IndustOrigin" in the COPA posting. It works only in PF1.

"Origin Plant" comes from the field "Origin Plant" in the COPA posting. It works in PF1 & WP1.

"Production plant in material_W" is a determination of the origin plant made by BW using special procurement codes. It works only with WP1

"Industrial Origin" comes from the profit center of the material code in PF1

In this scope we will approach:

• Characteristics created in the frame of PF1 Service Invoicing solution
• Usage of PF1 Service Invoicing solution characteristics
  • BFC heading determination
  • WBS elements
  • Billing type