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"
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 16.11.2023 | Inês Vilares | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
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:
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| Controlling - Sales PRice - Detail | Mandatory:
Optional:
| BW_WBK_COTP_0002 | BW_QRY_CPCOTP01_0004 | |
| Controlling - Sales Price - Synthesis | Mandatory:
Optional:
| BW_WBK_COTP_0001 | BW_QRY_CPCOTP01_0003 |
4.0 Functional Specification
4.1 General Data/Calculations
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Finance |
|---|---|
| Application | BW reports under TP - Transfer Price Historical Sales |
| Provider | CPCOTP01 |
This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.