Process responsible for providing the slow movement, obsolete and blocked batches.
Around 200 worldwide users and running the reports ~400 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 |
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 |
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.
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.
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).
Calculation view based on the query bw_qry_cpimmm03*_0001, filtering the previous month and the situations where the batch expire date or manufacture date from batch is not initial. The data come back to BW by the datasource CV_MM_IM_ABMMIM05*_M1 (WBP_HANAIV).
BW query with filter to get only the stockt type 'C', 'D' or 'E', the 10 GBUs used by the SAC dashboard, material and plants not obsoletes and with the valuation class corresponding to relevant according to the business units.
The are two DTP when retrieving data to the provider ABMMIM06*, M-3 → M-1 and M-6 → M-4.
The provider concatenate the results respecting the sequence batches blocked, obsolete and slow moving, if the same batch is classified in more than one condition.
AMDP
Once the provider concatenates the results respecting the sequence batches blocked, obsolete and slow moving with the corresponding values converted into EUR and quantities in VKG, the objects are order with the differences about the in and out results, split into I (IN) when the values and quantities are assigned at the first time according to the key or they rose, we keep without flag when the values don't change among the months or the difference between IN and the results from the month before, beyond that we classify as O (outbound) when the results reduce or they are not available anymore with the corresponding key in the sequent month.
AMDP
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 on top of the ztest query Rhodia (ztest_cv_qry_cpmmim03r_0003) and Solvay (ztest_cv_qry_cpmmim03s_0002). They are ztest as an alternative to set the months to be loaded in the process, reinforcing that is important to have the last 24 months in SMOG.
Once a month.
| 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. |
| SAC_BW_QRY_CPMMIM02_0005 | MM-IM: Under Observation (SAC) | Query used in the SAC model to control anticipation cases mixed with SMOG. |
N/a
N/a
N/a
N/a