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
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.
- 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
PC_MMIM_20 - MM: IM - M - SMOG Solvay
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
PC_MMIM_14 - MM: IM - ADH - SMOG Solvay
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