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"):
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:
Technical Documentation - RTR - FI Working Capital for Solvay Group (WBP)
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:
Technical Documentation - RTR - FI Working Capital for Solvay Group (WBP)
BFC documentation
This flow contains BFC data used for the calculation of the CAPEX BFC key figures
It is part of Working Capital documentation:
Technical Documentation - RTR - FI Working Capital for Solvay Group (WBP)
Cash Out documentation (PeC & Cash):
This flow contains FI data used for the calculation of the CAPEX Project key figures
Technical Documentation - Project Cost
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).
Reporting
Queries End User Documentation
RtR presentation:
https://drive.google.com/open?id=1SlcN2rzrL3F5IdQFSl_KtKYLnM_yvEuUZ67eEH6HQ5c
CKF and RKF explanations:
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.
Dependencies with other applications
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 |
|---|---|---|---|---|
Data Quality Control
Data come from SAP system. To compare data between BW and sources systems, check propagation layers.
Operational Documentation
Procedures
<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>
Scheduling
<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>
Monitoring
<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>
Error Handling
<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>
Known Bugs
<List the existing bugs, its criticity, workarounds and resolution plan.>