General presentation
Not loaded since 2019
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).
Roles & Access
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
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 :
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)
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
Reporting
Queries End User Documentation
Main queries
Query:
BW_QRY_MPR_FC003_0008 is modified : add Calculated and Restricted key-figures.
