1.0 Overview


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. 

Target Users: 

BW COPA Netback query (Core Query) => SodaAsh GBU Controllers.
BW iCare query => Specialty Polimerys for Interface Sales Forces.
BW - BFC YTD Exchange rate monthly query (Core Query) => Controllers.

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

14.08.2023

Inês Vilares

Initial draft










Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • BFC flat files
  • Others <specify the name of the source> 

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.


ReportsDefinitionPromptsBW Workbook QueryQuery 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:

  • Calendar day;

Optional:

  • Exchange Rate Type;
  • From Currency;
  • To Currency.
NABW_QRY_DAFICE01_0002
BW COPA Netback query (Core Query)Ask Charlotte

Mandatory fields:

  • Period/Fiscal Year.

Optional:

  • PRS Company Code;
  • BFC GBU;
  • Division;
  • Customer; duplicate
  • Customer;
  • Sales Employee;
  • Ship to party;
  • Product Hierarchy;
  • Material;
  • Plant;
  • Batch Origin;
  • Auth. Scope on Company Code.
NABW_QRY_MVCOPA01_NETBACK_0001
BW ICARE QueryAsk Charlotte

Mandatory fields:

  • Conso. View;
  • Calendar year/month;
  • Exchange Rate type (Default value "C").

Optional:

  • Auth. Scope on Company Code;
  • BFC GBU;
  • BFC Group of Activities;
  • PRS Comp. Mgt zone;
  • PRS Company Code;
  • Company Code;
  • Target Currency.
NABW_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 

DomainFinance
ApplicationNA since it's only queries
ProviderMVCOPA01 and DAFICE01 (for exchange rate)

In this section we will approach each query:

  • BW - BFC YTD Exchange Rate Monthly (Core Query)
  • BW COPA Netback query (Core Query)
  • BW ICARE Query

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.