General presentation

Objective of the application

Process responsible for providing the slow movement, obsolete and blocked batches.

Usage information

Around 200 worldwide users and running the reports ~400 times per month.

Roles & 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_M03	IM Stocks	Menu role

Authorization objects

List of authorization objects mandatory for the application.

Authorization object	Explanation
C_COMPCDE__C_AUTHMA	Company authorization scope
C_PLANT__C_AUTHMA	Plant authorization scope
CPFCTR1_2	Business unit

Dataflow presentation

Overview

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_16-35-15.png

All aDSO above the acquisition layer (basically a provider with the same fileds from datasource) uses an infosource in the link to become easier the implementation of different type of code: AMDP (recommend for look up at db level) and ABAP (better in treatments at row level).

The process uses as source queries on top of the inventory composite providers CPIMMM01, CPMMIM03R and CPMMIM03S.

Functional and Technical rules on Workbench + Reporting

**MM-IM: SMOG (HANA Ext. View) (BW_QRY_CPIMMM03*_0001**)

BW query with filter to get only the 10 GBUs used in the SAC dashboard, material and plants not obsoletes and with the valuation class corresponding to relevant according to the business units.

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-3-57.png

0CALYEAR was defined with only 2 years per time in a fix value because query as external view doesn't allow HANA or ABAP variables.
The provider CPMMIM03R provides two queries because of the volume of data processed by the total stock in Rhodia model; BW_QRY_CPIMMM03R_0002 (only CS) and BW_QRY_CPIMMM03R_0001 (other GBUs).

Data loading

Monthly process chain loaded at the day 05 for getting the data from previous month.

PC_MMIM_19 - MM: IM - M - SMOG Rhodia

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-14-36.png

PC_MMIM_20 - MM: IM - M - SMOG Solvay

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-15-22.png

The INIT process has a specific view from "month - 6" to "month - 1" and it has a corresponding view and datasource to each month.

It is processed by the objects below:

PC_MMIM_13 - MM: IM - ADH - SMOG Rhodia

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-23-10.png

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-23-31.png

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-23-54.png

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-24-30.png

PC_MMIM_14 - MM: IM - ADH - SMOG Solvay

TECHNO - BI TEAM > BW OTC - SMOG > image2020-9-11_17-25-33.png

Loading frequency

Once a month.

Reporting

Main queries

Technical Query Name	Query Name	Detail
BW_QRY_CPMMIM02_0001	MM-IM: SMOG (Core)	Master query with all the main objects available in the composite
SAC_BW_QRY_CPMMIM02_0003	MM-IM: SMOG Detailed (SAC)	Query used in the SAC model to detailed information from SMOG
SAC_BW_QRY_CPMMIM02_0004	MM-IM: SMOG x Stock (SAC)	Query used in the SAC model to compare information from stock and SMOG aggregated at plant level.

Main functionalities

N/a

Broadcast

N/a

Maintenance

N/a

Planned Evolution

N/a