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 - 120 days, 121 - 360 days, 361 - 720 days and greater than 720 days.

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

Main functionalities

N/a

Broadcast

N/a

Maintenance

N/a

Planned Evolution

N/a