The new wiki link for this data flow is here:
Technical Documentation - CAPEX Analysis report
Please update the new doc there and no longer here.
General presentation
Objective of the application
The objective of this application is to allow BFC Capex vs BW project reporting (PeC and Cash) data reconciliation: it mainly means providing a detailed view of all BFC CAPEX components (PeC/AuC, PeC/FXA, Fixed Asset Supplier, and Lease debt), to be available on a wide range of axes also shared with BW PeC and Cash solution.
The reporting coordinator is ROLLIER, Charlotte.
Usage information
History
This application was created in 2016 but it shares some cubes with the already existing Project costs application.
Roles & Access
Roles and access
| 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 : | Application Role:
|
Authorization objects
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Dataflow overview
https://drive.google.com/open?id=17Agt7EWrCz5E2wBQJQiCXo6M0UsLfkR7D7ifW8dLPlY
Reporting documentation drive folder:
https://drive.google.com/drive/folders/1TXMSO-6TxFDycku7yYAtyViD7TiwYIsL
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)
FI-AA for CAPEX /!\ Obsolete /!\
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).
RE-FX for CAPEX /!\ Obsolete /!\
Reporting
Queries End User Documentation
RtR presentation:
https://drive.google.com/open?id=1SlcN2rzrL3F5IdQFSl_KtKYLnM_yvEuUZ67eEH6HQ5c
Main queries
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.