Access Management 


List of application role + menu role  and explanation if we have several applications role with specials rules.

Role CodeRole DescriptionExplanation
ZR_RCS_CA_M03IM StocksMenu role

ZR_RCS_IM_A01

Stock Analysis - Super User RoleShould no longer be given - Gives user access to query creation on area AREA_MD, AREA_MMIC
ZR_RCS_IM_A02Stock Analysis - End User RoleGives user access to queries on area AREA_MD, AREA_MMIC
ZR_RCS_IM_A03Stock Analysis - Key User RoleGives 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 objectExplanation
0COMP_CODE;C_COMPCDE;C_PMORDER__0COMP_CODECompany, 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 QueryWBQ Query 
Technical Query NameQuery NameTechnical Query NameQuery NameFilter
ZZMIC_C01_CORE_ALL_001Material Valuation - Period Ending Inventory (KG)BW_QRY_MVMMIC02_0001Material Valuation - Period Ending Inventory (Core Query)
ZZMIC_C01_CORE_ALL_002Material Valuation - Period Ending Inventory Reporting UnitBW_QRY_MVMMIC02_0002Material Valuation - Period Ending Inventory in RU (Core Query)
BW_QRY_ZZMIC_C01_0001BW - Query for stock control (MB5L) - C01

BW_QRY_MVMMIC01_0003

BW - Inventory Management - Stock Movement (Core Query)


ZZMIC_NEW_ALL_001DO_NOT_USE_THIS_QUERY_0
REP_20140924100332Material stocks/movements (valuated)
ZZVES54_CORE_001CORE_ALL_STOCK (MONTHLY)
ZZZVES54_FLUORES_FR_001FLUORES FR ALL Stock Management (monthly)
ZZVES55_CORE_ALL_001CORE_ALL - Stock per plant/division/material
ZZVES55_SODA_FM_001SODA_FM_Stock all plants
ZZVES55_SVIN_FM_BW050SVIN_FM_BW050_Production Daily/Plant/material
ZZVES55_SVIN_FM_BW060SVIN_FM_BW060_Production Daily/Plant/material - All keyfigure
ZZVES55_H2O2_FM_001H2O2_FM_Stock all plants
ZZVES55_CORE_ALL_001CORE_ALL - Stock per plant/division/material
ZZMIC_NEW_SNAPSHOTStock movement snap shot
ZZVES55_TECH_ALL_001TECH - Stock per plant/division/material
ZZMIC_NEW_TECH1TECH - value and qty for K stock - do not use
ZZVES56_ALL_002STOCKS ALL NEW P3M

Mat type = Z700,Z701,Z707

ZZVES56_ALL_003STOCKS transaction ALL
ZZVES56_ALL_PLANTSTOCKS PLANT
ZZVES56_ALL_005STOCKS ALL MONTHLY EVOLUTION
ZZVES55_SIRIUS_001SIRIUS_Production Follow_upBW_QRY_MVMMIC01_0004BW - Inventory Management - SIRIUS Production Follow up(Core
ZZVES55_SIRIUS_001_GRPSIRIUS_Production Follow_up (by Group)BW_QRY_MVMMIC01_0004BW - Inventory Management - SIRIUS Production Follow up(Core
ZZVES55_SIRIUS_SODA_FM_001SIRIUS_SODA_Sales&StockBW_QRY_MVMMIC01_0005

BW - Inventory Management - SIRIUS Soda Sales&Stock (Core Query)




BW_QRY_MVMMIC01_0001BW - 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

  1. 2LIS_03_BX initial opening stock level.  Run only 1 time on 15 Oct 2017 (05:44 AM CET)
  2. 2LIS_03_BF movement document. Load movement stock data 
  3. 2LIS_03_UM revaluation to adjust amount of the stock. 

CRMMIC02 has 1 customized datasource

  1. 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

  1. Normal time on PC RCP_MMIC - 03a IC Complete Transactional  (3 times / day)
  2. Extra time on PC    FI_IC_DELTA_EXTR_HOURLY  - 03b IC Minimun Transactional (additional 3 time / day

     CRMMIC02

  1. 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.