The P&L (Profit and Loss) application it’s part of the Finance domain using data from SAP systems, non-ERP system and BFC (Business Financial Consolidation) information based on data from COPA (Controlling - Profitability Analysis) a component from SAP CO (Controlling) module. P&L application provides reports fully aligned with BFC structure (BFC Headings) down to REBIT/REBITDA able to analyze P&L starting from the BFC view (Company/Activity) and ability to drill down to Customer Material level. A profit and loss statement is a financial statement that summarizes the revenues, costs and expenses incurred during a specific period of time, usually a fiscal quarter or year. These records provide information about a company's ability – or lack thereof – to generate profit by increasing revenue, reducing costs, or both. |
For this Application the access is provided based on the BW menu "PL - Profit and Loss" and it's done via Service one. Fill the form In SAP system select the "WBP - BW Business Warehouse" In WBP - BW Business Warehouse : Select the Business Role select the "PL - Profit and Loss" |
Target Users: GBU controllers, Site controllers and Marketing and Sales. |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 24.07.2023 | Inês Vilares | Initial draft |
|
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:
|

In the process the data is in the SAP CO module where we have the different phases until the information has the struture aligned with BFC to become in the end the final data to be reported.
Cost objects controlling:
A cost object can be used to analyze target costs, actual costs, and variances in situations where costs are not collected at the level of orders or materials. For example:
Product Costing:
The flow of the product costing is composed of a series of standard transactions which are interconnected. This requires the processing in a certain sequence. The procedure starts in the cost center accounting referring to so-called production cost centers. Defined activity types are assigned to these cost centers. For the daily movements the activity prices are valuated at standard cost. In the closing of the product costing they will be revaluated at actual prices. The differences are credited on the production cost centers and debited on the production cost collectors, managed in the cost object hierarchy.
The procedure continues with the distribution of postings of actual costs on the cost object level to the assigned cost collectors.
All categories of variances between target costs and actual costs, like price and quantity variances in raw and packaging materials, same for consumed activities are calculated within the cost object hierarchy and posted on cost collectors. As the cost collectors are a certain kind of order, they must be settled at the end of the period.
Intermediate checks take place in order to look at the ‘zero’ balance of the cost accounting objects involved.
To see more detil information about the process please check in the wiki page for "Costing - Knowledge Base".
Profitability Analysis (CO-PA):
CO-PA provides P&L information by market segment or strategic business unit, such as enterprise, company code, plant, and other dimensions defined in the system. In the context of the PF1 and WP1 systems, CO-PA is used to produce the P&L statements and FC interfaces (costing based version).To ensure the correct mapping and alignment with FC requirements, a list of value fields is maintained in CO-PA. These value fields represent different components of costs and revenues, which are essential for generating accurate and detailed P&L statements and facilitating the interface with the FC system.
The data from the cost objects that have already been processed through product costing in SAP will provide the necessary information in CO-PA. This data will be aligned with the structure required by the BFC (Financial Consolidation) system to present financial reports.
By using the value field concept and custom tables ZWFAT110 for WP1 and ZZF_BFC_COPA_VF for PF1, the CO-PA data is mapped and transformed to match the structure and requirements of the BFC structure. This ensures that the financial reports generated by the BFC system will be accurate and reflecting the profitability analysis performed in CO-PA while taking into account the specific needs of financial consolidation and reporting.
In summary, the integration between CO-PA and the BFC system allows for a seamless flow of data, providing valuable insights into profitability and facilitating the preparation of comprehensive and accurate financial reports for the organization.
Reports:
PF1 and WP1: CO-PA P&L reports: KE30
WP1: CO-PA line items: KE24
PF1: CO-PA line items: KE23N
Below we have all the workbooks available:
| Reports | Definition | Prompts (some fields can be for multiple selections or a single value) | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| P&L Query | In a single report, the P&L of all legal entities of the GBU are displayed. The user can analyze the different KPI's (e.g. Net Sales, Contribution Margin, EBITDA, etc) and check the costs and sales for the company or companies depending on the selection of the user. It's possible to analyze the data for one month or more. | Mandatory fields:
Optional:
| BW_WBK_PL_0001 | BW_QRY_MVCOPA01_0001 |
| P&L Monthly Query | In a single report, the P&L of all legal entities of the GBU are displayed. The user can analyze the different KPI's (e.g. Net Sales, Contribution Margin, EBITDA, etc) and check the costs and sales for the company or companies depending on the selection of the user. In this report the user will see the data not for a specific month but for all months for the year selected in the prompts. Also the user can check the data by Quarter. If no currency is selected, no conversion is applied and data is extracted in local currency. For month 06/2018: Conversion will be the average exchange rate from 1 to 07 2018 – Average exchange rate from 1 to 6 2018); | Mandatory fields:
Optional:
| BW_WBK_PL_0002 | BW_QRY_MVCOPA01_0002 |
| P&L Monthly Query (Month Selected) | Same layout and fields as the "P&L Monthly Query" but the user only can select one month for the analysis. | Mandatory fields:
Optional:
| BW_WBK_PL_0009 | BW_QRY_MVCOPA01_0008 |
| P&L Reconciliation Query | P&L report presenting information about the costs and revenues, different KPI's for the comparison between the YTD Actual BW values and BFC Pack amounts. FC Pack column is for values when we use Conso = 0 and FC Conso will show values when we select Conso = 1. | Mandatory fields:
Optional:
| BW_WBK_PL_0003 | BW_QRY_MVCOPA01_0003 |
| P&L Query - Period Comparison | The report show the P&L information based in period 1 and period 2 to perform a comparison for actual data for the selected periods. The periods can be just one month or a range of months. | Mandatory fields:
Optional:
| BW_WBK_PL_0011 | BW_QRY_MVCOPA01_0006 |
| P&L Fixed Costs analysis | This represent only the measures related with fixed costs with the respective heading in BFC to see the values by default per GBU for one or more companies. | Mandatory fields:
Optional:
| BW_WBK_PL_0008 | BW_QRY_MVCOPA01_0001 |
P&L Integrated Margin - CM/GM Query by Sales Orders | This is related with P&L by Sales Order scope which will be approached in in Process Definition section. | Mandatory fields:
Optional:
| BW_WBK_PL_0020 | BW_QRY_CPCOPA03_0001 |
| P&L Integrated Margin - Monthly CM/GM Query by Sales Orders | This is related with P&L by Sales Order scope which will be approached in in Process Definition section. | Mandatory fields:
Optional:
| BW_WBK_PL_0021 | BW_QRY_CPCOPA03_0002 |
For these reports, it’s important to understand some general concepts which are transversal to all the reports which allows the users to work with the reports in the same way as the SAP system and BFC tool.
| Consolidation View | The query takes the integration rate of the company and the partner from the master data of company code.
The formula to retrieve the consolidated sales is in line with BFC: Consolidated Sales = Amount * Max [ 0, Integration Rate of CY (tingsoc) - Integration Rate of Partner (tingpart) ] Internal Sales = Amount * Min [ Integration Rate of CY (tingsoc), Integration Rate of Partner (tingpart) ] The integration rate of the partner is managed on the TRADING PARTNER. For specific cases some external customer must be considered as internal for certain company code (joint venture for example) . For cases the Partner integration rate is taken at the crossing Sold To/Company code. In this way, the user has 4 options:
|
|---|---|
| GBU Assignment | The concept for GBU doesn't exist in SAP but it’s a requirement to have in BW since in BFC we have this definition. This GBU assignment is different for WP1 and PF1 and it will be explain in detail in the Process Definition section. |
| Exchange Rate | P&L Exchange will be explain in detail in the Process Definition section. See below some links usefull for the exchange rates:
|
| PRS Concept | The PRS is one dedicated SAP environment (based on PF1) whose aim is to unify some structural information as Master Data information for customers, vendors, company codes, etc. For this, depending on each master data we are referring to, we have specific tables created to maintain the data and have the configuration from source systems to BFC definition and alignment. |
| Value Fields concept | CO-PA is an hypercube (like a pivot table in excel) where figures are posted to value fields. Value fields are mapped to BFC accounts in the interface tables. |
| Annual Closing | Each end of year, the main BW master data (about the structure) which are not time-dependent need to be frozen = no more loading from ECC or flat file on these main master data. To avoid the impact of the new evolution scheduled for next year on the yearly closing a freeze is applied to block the loading to allow the yearly closing period with the same scope done for the year and not with inputs for next year, for some master data, the loading are freeze in the middle of December until end of January. So when there is a new organization, historical data is restated in BW (not in SAP and BFC). |
| Domain | Finance |
|---|---|
| Application | BW reports under P&L folder |
| Provider | MVCOPA01 (main P&L data) and CPCOPA03 (P&L at sales orders) |
In here we will find the different parts of the process for P&L data into BW:
|
To see the data from the source systems see below how the information is organized in the BW perspective:

Additional notes: BFC Information cubes: We have some reports in P&L where we are comparing the BW values and BFC information. 1) P&L from CICC (data from BFC for PI1 scope is uploaded in P&L side) IM Scope cubes: This will be explained in more detail in the report "P&L Integrated Costs". NON-ERP cubes: Information related with non SAP system (for example GBR scope). Old PF1 data cubes: This was used in the past, but it's not used anymore. We only have this for historical data. CO object cubes: These cubes give us the logic to determine the IECRA and CDSA information to perform some assignments (for example GBU, Group of Activities, among others). 2) We don't use anymore. 3) This cube contains the data for the Unrealized Profit in Inventories (UPIS). This is relevant for the IM scope and for the moment no one is updating this file. |
See below the logic for WP1 and PF1:
An IECRA is the combination of:
IECRA are grouped into CDPRF (=Profit center carat) - A CDPRF corresponds to the "Activity 1" in BFC
CDPRF are grouped into ENTRP (enterprise codes) - The ENTRP corresponds to the "Group of Activities" in BFC
ENTRP are then grouped into ZSECT - The ZSECT code corresponds to the GBU in BFC
You can display the structure with WP1 - Report ZWFAR571 - Reporting structure axes

Determination of the IECRA in COPA (KE30 - Profitability report)
Depending on information available in the posting, the determination of the IECRA differs:
The IECRA is determined with the combination of:
Example: The division of the material code 110778 Geropon is TN (MM03 - Display the Division) In the sales order to the customer 2025815 CATALITE CO., LTD, the distribution channel is 10 Emulsion/Polymers (VA03 - WP1 : Check the Sales organization) The combination TN x 10 is assigned to the IECRA01126 (WP1 - Report ZWFAR571 - Reporting structure axes) |

There is a unique link Profit Center-IECRA
Usually the last 4 digit of the profit center is equal to the last 4 digits of the corresponding IECRA.
Example: The profit center 8026-M0449 is assigned to a material code 110778 in the plant 8026 (view "Costing 1" in MM03) The profit center 8026-M0449 is linked to the IECRA00449 (WP1 - ZWFAI052 - Display profit centers). All variances related to the material code 110779 in the plant 8026 are assigned to the IECRA00449 in COPA. |

Costs posted in a cost center are assigned to the P&L through an assessment cycle that is maintained in KEU3 - Dislay actual assessment to CO-PA.
Example: The cost center 8026-7000 is assessed to the IECRA00449 in the Assessment cycle 8026PA (ZWFAR600 - Cycle master data extraction) |

In PF1, the determination of the business structure is done in the P&L (KE30 - Profitability report) using the profit center of the COPA posting.
The following rule is applicable when the codification of the profit center starts with a D or a F. When the code of the profit center starts with another letter (ex: S, E or C), it can not be allocated to a business. |

When the code of the profit center starts with D or F, the system looks at the Profit center name in english.
It can be displayed with KE53 - Display Profit Center
Example: The name of the profit center F47ABBXXE1 is 747 ABB 0227E |
The system takes the position 2 & 3 of the Profit center name. It corresponds to the reporting division.
Example: The reporting division of the profit center F47ABBXXE1 is 47 |

In some cases, the "reporting division" is replaced by the "converted division". It is done using the exception table ZZR_REPO_DIV_EXC that is maintained at company code level.
Example: In the company code 0125, the reporting division 47 is replaced by the converted division 59 In other companies, the reporting division remains 47 |

The activity 1 is determined with the table ZZF_BFC_DIV_COVV using the original or converted reporting division.
Example: The division 47 corresponds to the BFC Activity 1 = 47 |

The group of activities is determined with the table ZZR_REPO_DIV using the original or converted reporting division.
Example: The division 47 corresponds to the BFC Group of activities = SDERI |

The GBU is determined using the group of activities with the table ZZR_REPO_SBU
Example: The group of activities SDERI belongs to the GBU SD Soda Ash & Derivatives. |

Identify the business to which the amounts are allocated in the Solvay partner company in cross-company flows. See below the different logic for WP1 and PF1.
In WP1, a partner activity 1 / group of activities / GBU is done when the movement type in COPA (KE30 - Profitability report) is equal to:
If there is no movement type, no partner activity 1 is determined.
Depending on the movement type, the program will look at different tables until it find the right correspondance as detailed below.
If there is a missing entry in a table, contact SBS support.

The partner activity 1 is the same as the activity 1
In case there is no activity 1, the partner activity 1 = ZZ01 |

1. Table ZWFAT176
BW starts by looking at the table ZWFAT176 - FC – company code/IECRA/company/Ship-to (mvt 10)
If it finds the combination Company Code x IECRA x Trading partner x Ship-To Party then the partner activity = GBU = 00
Ex: the combination 3865 x IECRA01169 x 4274 x 85392 = BFC Partner Activity CH + 00 = CH00


2. Table ZWFAT118
If no combination can be found in the table ZWFAT176 then the system looks at the table ZWFAT118 FC – company code/enterprise/company/PRCOM (mvt 10)
If it finds the combination Company Code x Enterprise x Trading partner x Commercial product then the partner activity = GBU = 00

3. Table ZWFAT119
If no combination can be found in the table ZWFAT118 then the system looks at the table ZWFAT119 FC – company code/enterprise/company (mvt 10)
If it finds the combination Company Code x Enterprise x Trading partner then the partner activity = GBU = 00
Ex: the combination 3865 x ENTRP00046 x 4274 = BFC Partner Activity CH + 00 = CH00


4. Table ZWFAT113
If no combination can be found in the table ZWFAT119 then the system looks at the table ZWFAT113 FC - ENTERPRISES
If it finds the combination Company Code x Enterprise then the partner activity = GBU = 00
If no combination can be found in the table ZWFAT113, then the partner activity 1 = ZZ10 |

The partner activity 1 = MZ00
1. Table ZWFAT116
BW starts by looking at the table ZWFAT116 - MAGNITUDE - company code/partner IECRA/comp/PRCOM (mvt 15)
If it finds the combination Company Code x IECRA x Trading partner x Commercial product then the partner activity = MGN Market

2. Table ZWFAT117
If no combination can be found in the table ZWFAT116 then the system looks at the table ZWFAT117 FC - company code/partner IECRA/company (mvt 15)
If it finds the combination Company Code x IECRA x Trading partner then the partner activity = FC Market

3. Table ZWFAT113
If no combination can be found in the table ZWFAT117 then the system looks at the table ZWFAT113 FC - ENTERPRISES
If it finds the combination Company Code x Enterprise then the partner activity = FC Market
If no combination can be found in the table ZWFAT113, then the partner activity 1 = ZZ15 |




Procedure to upload manually data from systems not interfaced with WBP.
On the business side they need to fill 3 dedicated templates to upload the data into WBP:
For customers master data: NON ERP - Model Customers master data
For material master data: NON ERP - Model Materials master data
For P&L data: NON ERP - Model structure of the P&L
For this, they need to also have in consideration the following information:
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:
|
When everything is ready the users can go to WBP systema and use upload the file in the transaction ZPL_FILE. Once it is done a message is displayed to inform that the file was sent to BW and will be available in the reporting at the next data loading.
Data loading time: 12am / 1pm / 6pm (french time)
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:
|
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
|
2 materials are sold in USD with the following contribution margin in local currency in Q1 2019:
| Material | Description | 01.2019 | 02.2019 | 03.2019 |
|---|---|---|---|---|
| 11365 | OT MET.DRUM 225L | $ 26 560,00 | $ 13 280,00 | $ 13 280,00 |
| 11366 | DISTIL. BULK. | $ 557 522,40 | $ 387 991,60 | $ 390 042,00 |
The rate C by month is:
| Month | 01.2019 | 02.2019 | 03.2019 |
|---|---|---|---|
| Rate 1 EUR = x USD | 1,141686 | 1,138501 | 1,135740 |
In February, the contribution margin (=CTN) of the material 11365 OT MET.DRUM 225L is
= (CTN 01.2019 + CTN 02.2019) x Rate C 02.2019 - CTN 01.2019 x Rate C 01.2019
= ($ 26 560,00 + $ 13 280,00) x 1,138501 - $ 26 560,00 x 1,141686 = 11 729,54 EUR
BW is doing the calculation item by item.
In February the CTN of material code 11366 DISTIL. BULK. = ($ 557 522,40 + $ 387 991,60) x 1,138501 - $ 557 522,40 x 1,141686 = 342 157,77 EUR
| Material | Description | 01.2019 | 02.2019 | 03.2019 |
|---|---|---|---|---|
| 11365 | OT MET.DRUM 225L | 23 263,83 EUR | 11 729,54 EUR | 11 777,90 EUR |
| 11366 | DISTIL. BULK. | 488 332,35 EUR | 342 157,77 EUR | 345 444,82 EUR |
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.
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:
|
This part was included in P&L scope to have in the report with four new fields:
This is available in the Workbooks for P&L Integrated Margin - CM/GM Query by Sales Orders and P&L Integrated Margin - Monthly CM/GM Query by Sales Orders since in here we have the information for the P&L structure not only the regular P&L headings but also considering the integrated margin process which is explained in the Functional Documentation - Profit and Loss Integrated Costs.
In this scope we will approach:
Characteristics created in the frame of PF1 Service Invoicing solution
The following characteristics were added in the P&L BW for entities in PF1:
|

Usage of PF1 Service Invoicing solution characteristics
BFC Headings
The determination of the BFC heading depends on the COPA value field and the Activity OECD using the mapping table below:
In BW you can see:
Should I add this list for the characteristics?
Closing Time:

Outside of Closing: the reload of data is 1x/ day during in the night.