General presentation
Objective of the application
Actually it is not an application. They are three queries and they provide the following info
- BW COPA Netback query (Core Query) => Specific Netback figures used by controllers
- BW iCare query => Specific iCare figures used to feed Salesforce tool
- BW - BFC YTD Exchange rate monthly query (Core Query) => Specific Exchange rate figures used by controllers
Tool Leader + IT leader of the application: Reporting coordinator: Charlotte Rollier / Ludovic Depoix.
Usage information
- 27 users coming from COPA community => BW COPA Netback query (Core Query)
- 1 user coming from Salesforce community => BW iCare query
- All users coming from P&L community => BW - BFC YTD Exchange rate monthly query (Core Query)
Queries are in role menu: COPA - Netback, iCare, Exchange rate
History
These three queries have been create in WBP in the context of PQ1 Decommissioning project.
BW RTR - Exchange Rate Query (WBP)
No special info needs... it has been created under the DSO DAFICE01and it is fed daily, from the table TCURR of WBP.
Transformation DTS_TCURR WBP_400 -> ODSO DAFICE01 is used to load the exchanges rates and the second transformation ODSO DAFICE01 -> ODSO DAFICE01 to delete the exchange rates loaded before the current day.
Process chain: PC_FICE_00 - Daily - 1am.
It has been created under SpS project (P&L multiprovider => MVCOPA01)
In oreder to have more details of the multicube flow, rules and so on, please refer to the P&L documetation => Technical Documentation - RTR - Profit and Loss (P&L) + Integrated Margin (IM) (WBP)
Process chain where info provider CRCOPA22 is loaded: PC_COPA_PL_32 - Daily - 1:10 am.
It has been created under SpS project (P&L multiprovider => MVCOPA01)
In oreder to have more details of the multicube flow, rules and so on, please refer to the P&L documetation => Technical Documentation - RTR - Profit and Loss (P&L) + Integrated Margin (IM) (WBP)
iCare Query uses severals providers in MVCOPA01:
CICC & Adjustment companies - P&L - Data → CRCOPA08
IM - RCS - CDSA w/ Program → CRCOPA32
IM - Solvay PF1 - GM Data → CRCOPA23
IM - Solvay PF1 - GM Data - allocation of transport costs → CRCOPA26
IM - Solvay PF1 - GM Data Annulation → CRCOPA30
NON-ERP - Below Gross Margin (BFC) → CRCOPA07
NON-ERP - Data → CRCOPA09
PAX: Profitability Analysis: COPA - IECRA Determination WP1 → CRCOPA29
PQ1 P&L - GM Data → CRCOPA10
PQ1 P&L - PCA Data → CRCOPA11
Profit. Analysis: COPA - CDSA Program → CRCOPA31
Profitability Analysis: COPA - CDSA Determination → CRCOPA02
Profitability Analysis: COPA - IECRA Determination → CRCOPA01
Profitability Analysis: COPA - Solvay legacy → CRCOPA22
UPIS - Data → CRCOPA21