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


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.


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.