General presentation
Objective of the application
The objective is to have a new P&L dataflow, same as original one (MVCOPA01 & queries BW_QRY_MVCOPA01_0004 + BW_QRY_MVCOPA01_0007) with four new fields:
- Sales Order
- Item Order
- Market Cluster
- Team Cluster.
We create a new hana data flow (calculation views and composite provider) to avoid to store the data.
We not add the new fields in MVCOPA01 flow, because the volume would have been too large.
Project: 11281 - ICM Per Sales Order (P&L)
Usage information
History
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M12 | PL - P&L Reporting | Role menu |
Authorization objects
List of autorisation objects mandatory for the application.
BW Catalog of Roles:
https://docs.google.com/spreadsheets/d/10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I/edit?usp=sharing
Dataflow overview
The dataflow is composed by 4 calculation views and one composite provider.
Calculation view:
CV_FMCO_COPA_PL_SOLVAY_0001
CV_FMCO_COPA_PL_RHODIA_0001
CV_FMCO_COPA_PL_NONERP_0001
CV_FMCO_COPA_PL_BFC_0001
Composite provider:
CPCOPA03
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
CV_FMCO_COPA_PL_BFC_0001:
CV_FMCO_COPA_PL_NONERP_0001:
CV_FMCO_COPA_PL_SOLVAY_0001:
CV_FMCO_COPA_PL_RHODIA_0001:
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
To open calculations view Rhodia and Solvay, it's necessary to use WEBIDE, it's not possible to open them with hana studio due to a lack of memory.
https://wbdhana.eua.solvay.com:4300/sap/hana/ide/editor/