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
The background for these 2 queries is the same business process that we have for the Profit and Loss scope. This can be check in the respective functional documentation.
For the COPA Netback the business process is that they are using our base for the Profit and Loss scope to have on GBU SodaAsh side some reports were the purpose is to re alocate entities by solvay to identify the solvay customer and to provide customer with correct margin and have accurate customer info. aim was to have Cleanest data. They use our COPA information and on their side they use the Dataiku tool to work this information and create a file with the necessary data (called COPAG).
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.