1.0 Overview




The application provides for a given month, the average sale prices observed during the X previous months.

Data is both:

  • Available in reporting through AFO workbook
  • Monthly extracted into 2 flat files likely to be loaded into WP1 and PF1.

The aim of the application is to calculate and provide to transfer pricing team the monthly average sale price by BFC Company Code, Material, Revenue Type.

For this Application the access is provided based on the BW menu "TP - Transfer Price Historical Sales" and it's done via Service one.

Fill the form
https://solvay-dwp.onbmc.com/dwp/app/#/itemprofile/622 

In SAP system select the "WBP - BW Business Warehouse" 

In WBP - BW Business Warehouse : Select the Business Role select the "TP - Transfer Price Historical Sales"

Target Users:

Transfer Price team.

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

16.11.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
  • Others <specify the name of the source> 

2.0 Business Process


History

This project was developed in September 2019 by Ludovic Depoix with BW technical support of Cyril Bianco.

A new OFFSET parameters has been added to the data flow in June 2022 by Ludovic Depoix with BW technical support of Charles Benier.


3.0 Application Feature Overview


For this application find below all the workbooks available:

ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name
Controlling - Sales PRice - Detail

Mandatory:

  • Current Calmonth Pre-filled;

Optional:

  • Number of Month OFFSET;
  • Material;
  • BFC Company.
BW_WBK_COTP_0002BW_QRY_CPCOTP01_0004
Controlling - Sales Price - Synthesis

Mandatory:

  • Current Calmonth Pre-filled;

Optional:

  • Number of Month OFFSET;
  • Material;
  • BFC Company.
BW_WBK_COTP_0001BW_QRY_CPCOTP01_0003

4.0 Functional Specification


4.1 General Data/Calculations 



4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainFinance
ApplicationBW reports under TP - Transfer Price Historical Sales
ProviderCPCOTP01


This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.





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