Track the level of stock and movement in quantity and values (grouped by family : sales, production, purchasing, …) at a daily or monthly level per material/plant .
There are 2 mains stocks area in Solvay Legacy, which are:
Around 80 worldwide users and running the reports around 80 times per month.
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 |
|---|---|
| Company Code | Company of the plant which holds the material |
Note: Data source ZZK_INV_MAT_VAL is created by nuno.godinho-ex@solvay.com
The stock level / stock movements part of the flow follows the D4 frequently loaded data schedule. (it is under PC RCP_MMIC)
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) | |
Key Figures Meaning of inventory movement MVMMIC01
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.