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).
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 |
|---|---|---|
| ZR_RCS_CA_M531 | Fixed costs budget management | To have the transaction to upload budgets |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Dataflow :
Datasource on a flat file → DSO → Infocube
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
A Datasource on a flat file.
Mockup of source file :
https://drive.google.com/file/d/17FQBOrU6IobBHEX7in5Emvg-WfGECvFBnBsMzzPW28k/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)
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 |