Not loaded since 2019
Access Management
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 |
|---|---|---|
ZBI_RCS_CO_A24 | GBU Fixed Cost | Application role |
| ZR_RCS_CA_M53 | FC - GBU Fixed Cost | Role Menu |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
C_RESP_CC__CPFCTR1_2 CPFCTR1_2 | ZR_*_CA_P05 |
C_RESP_CC__C_RPLANT C_PLANT C_COSTCTR__C_RPLANT | ZR_*_CA_P02 |
C_RESP_CC__C_AUTHMA | ZR_*_CA_P00 |
| C_COMPCDE__C_COMPPRS | ZR_*_CA_P07 |
| Company (C_COMPCDE) | ZR_*_CA_P01 |
Dataflow overview
Dataflow :
Datasource on a flat file → DSO → Infocube
General presentation
Objective of the application
In Fixed costs analysis add budget information.
The objective is to upload budget from excel files.
History
Rtr team is the requester of this project (june 2018).
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
09/19/2023: Last load of DSO → 04/23/2019
A Datasource on a flat file.
Mockup of source file :
https://drive.google.com/file/d/1z8TM7hfFN-_XlFfBwDJuHVTAJmiHC8cYLYeRlSq7oEM/view
DSO DBBUDG01 :
Be careful : in the key, they are BFC Global Business Unit and BFC Group of activities : in the mockup, only one line with one GBU but more BFC Group of activities.
Transformation between datasource DTS_CO_BUDGET_FIXED_COSTS and DSO DBBUDG01 :
It's an expert routine : - read table company for fiscvarnt
- add one line in DSO for each activity group not initial (to put a budget to 0 add activity group with value 0)
Transformation between DSO DBBUDG01 and Infocube CUB_FB001 :
Only direct mapping except : 0CALMONTH (Time characteristic conversion)
0CALQUARTER (Time characteristic conversion)
C_INFOPRO (constant name of DSO : DBBUDG01)
Reporting
Queries End User Documentation
Dependencies with other applications
Data loadings
Info providers and objects loaded
The loading run the process chaîn PC_FIXED_COST_BUDGET. This process chain is a direct scheduling with event "PC_FIXED_COST_BUDGET".
Loading frequency
Loading on demand with transaction : ZBW_BUDGET_LOAD (program ZBW_LOAD_FLAT_FILE_BUDGET).
The user must create or modify a file data and chosse this file in the transaction.
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
Main queries
Query:
BW_QRY_MPR_FC003_0008 is modified : add Calculated and Restricted key-figures.
Main functionalities
Broadcast
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.>