Access Management
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_M50 | CX - CAPEX Analysis | Role menu for all CAPEX queries |
| ZBI_RCS_CX_A01 | Application CAPEX analysis - End user role : |
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| C_COMPCDE C_COMPPRS | Company, role: ZR_*_CA_P01 |
CPFCTR1_2 | GBU, role: ZR_*_CA_P05 |
| C_MNGAREA | PRS area: ZR_*_CA_P08 |
| C_COMPCDE__C_AUTHMA | Authorization scope role: ZR_*_CA_P00 |
See also file maintained by Authorization team : BW Catalog of Roles / link:
DataFlow
Overview
Detailed data flow (August 2023):
Technical Rules on Workbench
FI-GL for CAPEX documentation
These flows contain all the FI-GL data used for the calculation of the CAPEX FI key figures (Key figures "FI Detailed posting" and "FI CX accounts"):
https://wiki.solvay.com/x/KqixAQ
FI-AP documentation
These flows contain all the FI-AP data used for the calculation of the CAPEX FI key figures (Key figures "FI Detailed posting" and "FI CX accounts"):
It is part of Working Capital documentation:
https://wiki.solvay.com/x/ZqA_AQ
Fixed Asset Supplier (FAS) and Lease Interface
This requirement concerns CAPEX data but at detailled level so it was based on the existing Working Capital multiprovider on DSO (MVFIWC03).
More information about this solution, refer to the Working Capital documentation:
https://wiki.solvay.com/x/ZqA_AQ
BFC documentation
This flow contains BFC data used for the calculation of the CAPEX BFC key figures
It is part of Working Capital documentation:
https://wiki.solvay.com/x/ZqA_AQ
Cash Out documentation (PeC & Cash):
This flow contains FI data used for the calculation of the CAPEX Project key figures
https://wiki.solvay.com/x/1Lo_AQ
Asset Accounting (BW RTR FI-AA)
The Asset Accounting (FI-AA) component is used for managing and supervising fixed assets with the SAP System. FI-AA was developed exclusively to meet IFRS16 requirements, however, it is being or will be used across Solvay for other requirements. Cubes related to AA have been develped and added to existing CAPEX Multiprovider (MVFICX01)
Flexible Real Estate Management (BW RTR RE-FX)
This requirement mainly related to IFRS16 (IFRS 16 is effective for annual reporting periods beginning on or after 1st January 2019) data where Solvay is now in position to extract RE-FX data as part of CAPEX reporting and hence RE-FX reporting cubes have been added to existing CAPEX Multiprovider (MVFICX01).
Dependencies with other applications
We should have the information where the application is sending or receiving information (e.g. APD open hub)
Reporting
Queries End User Documentation
RtR presentation:
https://drive.google.com/open?id=1SlcN2rzrL3F5IdQFSl_KtKYLnM_yvEuUZ67eEH6HQ5c
Main queries
| Query | Name |
|---|---|
| BW_QRY_MVFICX01_0009 | CAPEX L40800 Legal FA adjust. balances (Core Query) |
| BW_QRY_MVFICX01_0011 | CAPEX BFC Invest. data (Core Query) |
| BW_QRY_MVFICX01_0014 | CAPEX Invest. Project vs FI det. analysis (Core Query) |
| BW_QRY_MVFICX01_0015 | Capex Lease interface to BFC (Core Query) |
| BW_QRY_MVFICX01_0016 | CAPEX Lease B/S by Flows - Debt (Core Query) |
| BW_QRY_MVFICX01_0017 | CAPEX Lease B/S by Flows - REFX RoU (Core Query) |
| BW_QRY_MVFICX01_0018 | CAPEX Invest. Project to BFC synthesis (Core Query) |
| BW_QRY_MVFICX01_0019 | CAPEX Debt/RoU based on RE Act./Plan. Cash flow (Core Query) |
| BW_QRY_MVFICX01_0020 | CAPEX Future Cash flow for Budgeting (Core Query) |
| BW_QRY_MVFICX01_0021 | CAPEX Lease B/S by Flows - AA RoU (Core Query) |
| BW_QRY_MVFICX01_0022 | CAPEX Rolling Future Cash flow for L6605 (Core Query) |
| BW_QRY_MVFICX01_0023 | CAPEX Lease Colmar check (Core Query) |
| BW_QRY_MVFICX01_0024 | CAPEX Lease B/S by Flows - SAP vs BFC Debt (Core Query) |
| BW_QRY_MVFICX01_0025 | CAPEX Lease B/S by Flows - SAP vs BFC RoU (Core Query) |
| BW_QRY_MVFICX01_007 | CAPEX Colmar interface - Lease data (Core Query) |
| QV_BW_QRY_MVFICX01_0001 | CAPEX BFC FA+RoU for QS (Core Query) |
| QV_BW_QRY_MVFICX01_0002 | CAPEX SAP RoU for QS (Core Query) |
| BW_QRY_CPFICX02_0001 | CAPEX Lease GL extract for KPI automation (Core Query) |
Reports are available via workbooks published in the Roles menu.
Role menu "CX - CAPEX Analysis" (ZR_RCS_CA_M50)
Main functionalities
Complex formulas: most of the key figures definitions contains formula variables in order to calculate the "conso" view and use the "enlarge to PM" option.
Currency conversion: key figures are available in local currency but can be converted according to a target currency entered in a query prompt.
Data Loading
Info Providers and objects loaded
The lists of process chain are in subsections FI-GL for CAPEX, FI-AP, FI-AA...).
Main Process Chain | Final Provider Loading | Frequency | Time start | Duration |
|---|---|---|---|---|