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_M03 | IM Stocks | Menu role |
ZR_RCS_IM_A01 | Stock Analysis - Super User Role | Should no longer be given - Gives user access to query creation on area AREA_MD, AREA_MMIC |
| ZR_RCS_IM_A02 | Stock Analysis - End User Role | Gives user access to queries on area AREA_MD, AREA_MMIC |
| ZR_RCS_IM_A03 | Stock Analysis - Key User Role | Gives user access to queries on area AREA_MD, AREA_MMIC + Access to add/remove items from menu ZR_RCS_CA_M03 |
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| 0COMP_CODE;C_COMPCDE;C_PMORDER__0COMP_CODE | Company, role: ZR_*_CA_P01 |
| 0PROFIT_CTR__CPFCTR1_2; 0PROFIT_CTR__C_PFCTR1;CPFCTR1_2;C_AGRITM__CPFCTR1_2; C_ASSET2__C_PFCTR1;C_ASSET__C_PFCTR1;C_MATPLNT__CPFCTR1_2; C_MATPLNT__C_PFCTR1;C_MATPNT2__CPFCTR1_2;C_PFCTR1; C_PMORDER__C_PFCTR1;C_PMORDR__C_PFCTR1;C_PRDEQUI__CPFCTR1_2; C_RECONTR__CPFCTR1_2;C_RESP_CC__CPFCTR1_2;C_SUBACT2__CPFCTR1_2 C_TECMAT__CPFCTR1_2;C_WBS_EL2__CPFCTR1_2;C_WBS_EL2__C_ZSECT;C_WBS_ELE__CPFCTR1_2; C_WBS_ELE__C_ZSECT;C_ZSECT | GBU, role: ZR_*_CA_P05 |
DataFlow
Overview
Technical Rules on Workbench
- Material stocks/movements (valuated): CRMMIC01
- Material Valuation - Period Ending Inventory: CRMMIC02
Reporting
Main queries
All queries are migrated from PQ1 queries by following mapping
| PQ1 Query | WBQ Query | |||
| Technical Query Name | Query Name | Technical Query Name | Query Name | Filter |
| ZZMIC_C01_CORE_ALL_001 | Material Valuation - Period Ending Inventory (KG) | BW_QRY_MVMMIC02_0001 | Material Valuation - Period Ending Inventory (Core Query) | |
| ZZMIC_C01_CORE_ALL_002 | Material Valuation - Period Ending Inventory Reporting Unit | BW_QRY_MVMMIC02_0002 | Material Valuation - Period Ending Inventory in RU (Core Query) | |
| BW_QRY_ZZMIC_C01_0001 | BW - Query for stock control (MB5L) - C01 | BW_QRY_MVMMIC01_0003 | BW - Inventory Management - Stock Movement (Core Query) | |
| ZZMIC_NEW_ALL_001 | DO_NOT_USE_THIS_QUERY_0 | |||
| REP_20140924100332 | Material stocks/movements (valuated) | |||
| ZZVES54_CORE_001 | CORE_ALL_STOCK (MONTHLY) | |||
| ZZZVES54_FLUORES_FR_001 | FLUORES FR ALL Stock Management (monthly) | |||
| ZZVES55_CORE_ALL_001 | CORE_ALL - Stock per plant/division/material | |||
| ZZVES55_SODA_FM_001 | SODA_FM_Stock all plants | |||
| ZZVES55_SVIN_FM_BW050 | SVIN_FM_BW050_Production Daily/Plant/material | |||
| ZZVES55_SVIN_FM_BW060 | SVIN_FM_BW060_Production Daily/Plant/material - All keyfigure | |||
| ZZVES55_H2O2_FM_001 | H2O2_FM_Stock all plants | |||
| ZZVES55_CORE_ALL_001 | CORE_ALL - Stock per plant/division/material | |||
| ZZMIC_NEW_SNAPSHOT | Stock movement snap shot | |||
| ZZVES55_TECH_ALL_001 | TECH - Stock per plant/division/material | |||
| ZZMIC_NEW_TECH1 | TECH - value and qty for K stock - do not use | |||
| ZZVES56_ALL_002 | STOCKS ALL NEW P3M | Mat type = Z700,Z701,Z707 | ||
| ZZVES56_ALL_003 | STOCKS transaction ALL | |||
| ZZVES56_ALL_PLANT | STOCKS PLANT | |||
| ZZVES56_ALL_005 | STOCKS ALL MONTHLY EVOLUTION | |||
| ZZVES55_SIRIUS_001 | SIRIUS_Production Follow_up | BW_QRY_MVMMIC01_0004 | BW - Inventory Management - SIRIUS Production Follow up(Core | |
| ZZVES55_SIRIUS_001_GRP | SIRIUS_Production Follow_up (by Group) | BW_QRY_MVMMIC01_0004 | BW - Inventory Management - SIRIUS Production Follow up(Core | |
| ZZVES55_SIRIUS_SODA_FM_001 | SIRIUS_SODA_Sales&Stock | BW_QRY_MVMMIC01_0005 | BW - Inventory Management - SIRIUS Soda Sales&Stock (Core Query) | |
| BW_QRY_MVMMIC01_0001 | BW - Physical inventory coverage - Solvay | New for Solvay legacy | ||
Main functionnalities
Key Figures Meaning of inventory movement MVMMIC01
Dependencies with other applications
We should have the information where the application is sending or receiving information (e.g. APD open hub)
Data Loading
Info Providers and objects loaded
CRMMIC01 has 3 standard datasource loading
- 2LIS_03_BX initial opening stock level. Run only 1 time on 15 Oct 2017 (05:44 AM CET)
- 2LIS_03_BF movement document. Load movement stock data
- 2LIS_03_UM revaluation to adjust amount of the stock.
CRMMIC02 has 1 customized datasource
- Data source ZZK_INV_MAT_VAL is created by nuno.godinho-ex@solvay.com
Loading frequency
The stock level / stock movements part of the flow follows the D4 frequently loaded data schedule. (it is under PC RCP_MMIC)
There are 2 main process chains that load the stock cubes, which are
CRMMIC01
- Normal time on PC RCP_MMIC - 03a IC Complete Transactional (3 times / day)
- Extra time on PC FI_IC_DELTA_EXTR_HOURLY - 03b IC Minimun Transactional (additional 3 time / day
CRMMIC02
- PC_IM_04 is trigger by RSP_DAILY and this PC will be executed only on the 3th working day to 7th working day (by method WORKINGDAY_MONTH with factory calendar ID = 50). It would take 7 hours for loading
Data Quality Control
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 criticality, workarounds and resolution plan.>
Roadmap
This multi-provider will be used for the next evolution to combine Rhodia legacy to combine in order to have both legacy in the same report and definition.