General presentation
Objective of the application
The objective is to have a new P&L dataflow, same as original (MVCOPA01 & queries BW_QRY_MVCOPA01_0004 + BW_QRY_MVCOPA01_0007) with four new fields:
- Sales Order
- Item Order
- Market Cluster
- Team Cluster.
We created a new hana data flow (calculation views and composite provider) to avoid to store the data.
We not added 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
In the file below you can find the providers used as sources in calculations view and origin of each fields:
Inputs parameters used in caluclations views:
- IP_CALMONTH_FROM
- Single entry
- Not Mandatory
- IP_CALMONTH_TO
- Single entry
- Not Mandatory
- IP_COMPCDE
- Multiple entries
- Not Mandatory
- IP_CALYEAR
- Single entry
- Not Mandatory
- IP_PLANT
- Multiple entries
- Not Mandatory
Composite provider:
CPCOPA03
CV_FMCO_COPA_PL_BFC_0001:
CV_FMCO_COPA_PL_NONERP_0001:
CV_FMCO_COPA_PL_SOLVAY_0001:
CV_FMCO_COPA_PL_RHODIA_0001:
Sales order and Item for solvay DSO.
The objective was to add sales order and item in P&L reporting, for that we had to modify three existing DSO:
DPCOPA23:
- Modification of semantic key "C_KEY02" to add sales order & sales order item in the concatenation (not possible to add new keys, so we used concatenate fields).
- Add Sales order and Item as data fields
DBCOPA34
- Modification of semantic key "C_KEY02" to add sales order & sales order item in the concatenation (not possible to add new keys, so we used concatenate fields).
- Add Sales order and Item as data fields
DBCOPA41
- Sales order and sales order item already present in DSO, just ,eed to adapt the expert routine in transformation TRSF: ODSO DBCOPA35 -> ODSO DBCOPA41 tp use them for the lookup with DBCOPA34.
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/