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



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.