The scope COPA Netback, iCare, exchange rate queries they are not an application but they are queries based in SAP CO module and exchange rate information in SAP. They have been create in WBP in the context of PQ1 Decommissioning project.
For these queries the access is provided based on the BW menu and it's done via Service one.
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 14.08.2023 | Inês Vilares | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
In the context of our business operations, these 2 queries are based on the Profit and Loss scope, so to understand in more detail this part please check in the respective functional documentation.
Regarding the COPA Netback process, the purpose is to utilize the same framework as our Profit and Loss scope to generate reports on the GBU SodaAsh side. The primary objective here is to reallocate sales made by trading entities by Solvay, identifying Solvay customers, and ensuring the accuracy of customer information. The ultimate aim is to maintain the cleanest and most accurate data possible.
For this process, they make use of our COPA information, and on their side they use the Dataiku tool to manipulate this data, ultimately generating a file referred to as 'COPAG' containing the necessary information.
The file will offer a substantial amount of data that has been meticulously processed by Dataiku to ensure that they are working with the most precise and accurate data for their specific objectives. This approach was necessitated by the fact that our initial queries from the Profit and Loss side did not fully meet the requirement of providing the cleanest data pertaining to the costs associated with SodaAsh. Furthermore, it enables the analysis of a unique case in the United States concerning the payment of royalties to certain companies that own lands, where a percentage of the Netback is associated with trona mineral (comprising 65% SodaAsh and 35% bicarbonate).
For the iCare (to be checked)
The exchange rates concept
3.0 Application Feature Overview
For this scope we will describe the queries since we don't have workbooks.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| BW - BFC YTD Exchange Rate Monthly (Core Query) | The reports contains the information about exchange rate types and currency types for the calendar day range as per the selected criteria. | Mandatory fields:
Optional:
| NA | BW_QRY_DAFICE01_0002 |
| BW COPA Netback query (Core Query) | Ask Charlotte | Mandatory fields:
Optional:
| NA | BW_QRY_MVCOPA01_NETBACK_0001 |
| BW ICARE Query | Ask Charlotte | Mandatory fields:
Optional:
| NA | BW_QRY_MVCOPA01_0016 |
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
| Domain | Finance |
|---|---|
| Application | NA since it's only queries |
| Provider | MVCOPA01 and DAFICE01 (for exchange rate) |
BW - BFC YTD Exchange Rate Monthly (Core Query)
BW COPA Netback query (Core Query)
BW ICARE Query
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
Frequency, data, and time of the data refresh in the data product.