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.
The aim of this application is to give a P&L reporting adapted to Soda Ash GBU requirements.
It is based on the corporated P&L query and offered special axis and calculation for Soda Ash.
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
https://solvay-dwp.onbmc.com/dwp/app/#/itemprofile/622
In SAP system select the "WBP - BW Business Warehouse"
In WBP - BW Business Warehouse : Select the Business Role select the "PL - Profit and Loss"
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 14.12.2023 | Inês Vilares | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
The base is the same for the Profit and Loss application in the functional documentation. We can see in that documentation the logic for the P&L.
For this application this was built in 2018 and the need was to provide a dedicated report only for GBU SD .This report is a separate report from the P&L reports.
This new report:
- is based for main Part on P&L datas;
- will construct Soda Ash business axis that are not existing in ERp or in actual BI reports;
- SD BU;
- Origin.
- retreat some functional flow :
- redetermination of internal or external amounts
- reallocation of transport cost between SD BU for specific flow
- recalculate some lines of the P&L (internal sales and COGS ) for specifics flows
3.0 Application Feature Overview
For this scope we only have one query:
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| BW P&L by BU - Monthly Query (Soda Ash) (Core Query) | Mandatory:
Optional:
| N.A | BW_QRY_MVCOPA07_0001 |
4.0 Functional Specification
4.1 General Data/Calculations
The base is the same for the Profit and Loss application in the functional documentation. We can see in that documentation the logic for the P&L.
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Finance |
|---|---|
| Application | NA since it's only a query |
| Provider | MVCOPA07 |
5.0 Non-functional Descriptions
5.1 Usability
as per standard.
5.2 Regulatory Compliance
as per standard.
5.3 Security
as per standard.
5.4 Performance
as per standard.
5.5 Reliability
as per standard.
5.6 Scalability
as per standard.
5.7 Compatibility
as per standard.
5.8 Availability
as per standard.
5.9 Refresh of the Data
The load for this report it's for working days around 3 a.m.