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.

Authorization objects

List of authorization objects mandatory for the application.

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

Calc. view for position of last month (CV_MM_IM_ABMMIM05*_M1)

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

MM-IM: SMOG Evolution (Only Sotck Type) (BW_QRY_CPIMMM01_0011)

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. 

Material Movement - SMOG (ABMMIM06*)

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

• Blocked - All batch with the stock type equal 'C', 'D' or 'E'
• Obsolete - If the last day of respective month of the load is greater than batch expiry date
• Slow moving - If the last day of respective month minus the batch manufacture date is bigger than 365 days
• Batch aging - According to the difference of days for the previous 2 classifications, it was created the aging 0 - 90 days, 90-120 days, 121 - 360 days, 361 - 720 days and greater than 720 days.

Material Movement - SMOG (ABMMIM06*) Recursive Load

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

• The rules to assign IN and OUT is done at this level in the end routine comparing values for the same key with the month treated in the load with the month before and after.

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

Loading frequency

     Once a month.

Reporting

Main queries

Main functionalities

N/a

Broadcast

N/a

Maintenance

N/a

Planned Evolution

N/a