General presentation

Objective of the application

New inventory model responsible for providing data from both source system, PF1 and WP1, in a single model. It works at operational detailed level (material document) and also non cumulative evolution data (at batch level).

This model gives the stock according to the type of movement/processing like mentioned by SAP papers regarding the new inventory, coming from 2LIS_03_BX / 2LIS_03_BF, such as to perform the valuations and revaluations according to the changes in price definition in the material x plant x valuation type and reference dates from MBEW / MBEWH.

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

Functional and Technical rules on Workbench + Reporting

Material Movement (ABMMIM03*)

AMDP

• Controlling Area - If the controlling area is null, get the data from the corresponding attribute of "company code" (c_compcde);
• Sub-activity 2 - Get the data from the attribute of technical object "Material plant 3" (c_matpnt3);
• Sub-activity - Get the data from the attribute of technical object "Material plant 3" (c_matpnt3);
• GBU - Get the data from the attribute of "Sub-activity 2" (c_subact2);
• Country (GBU Zone) - Get the data from the attribute of "Customer ID" (c_custid);
• Material conversion - If the corresponding material and unit of measure is not convertible into 'KG' according to the DSO UOMCMAT2, the object is flagged.

ABAP ME: ZCL_IMMM_BUSN=>ME_ABIMMM03

• Valuation type - Treat invalid char;
• Customer / GBU Zone - Empty if the stocktype not is 'K', 'L', 'M', 'N' or 'O';
• Vendor - Empty if the stocktype not is 'Q', 'R' or 'S' or stock category is not 'K' or 'Q';
• Consignation quantity stock (issued) - Stock relevant = 1, transaction key = '100', '101', '104', '105', '106' or '110', application = 'MM', stock category = 'K' or stock category = '' and stock type contain 'LEK';
• Quantity stock (issued) - Stock relevant = 1, application = 'MM' and transaction key = '100', '101', '104', '105', '106' or '110';
• Consignation quantity stock (received) - Stock relevant = 1, transaction key = '000', '001', '004', '005', '006' or '010', application = 'MM', stock category = 'K' or stock category = '' and stock type contain 'LEK';
• Quantity stock (received) - Stock relevant = 1, application = 'MM' and transaction key = '000', '001', '004', '005', '006' or '010';

Price control (AAMMIM02*)

ABAP

• Valuation type - Treat invalid char;
• Calendar day - Convert the timestamp into date, if timestamp is null, concatenate the information from year, month and day 01. If the date keeps initial, the entire record is removed from flow;
• Price variation - If the total value is not initial (not valuated stock), check the price condition (S - Standard or V - Average) to assign the corresponding value.
• The record is only stored by the delta process if the date is bigger than the last one stored for the same key (material, plant and valuation type). This avoid the check done by the post process done in the propagation layer, when the process checks the variance of price between days.

Material movements - Price (APMMIM02*)

AMDP

• The main purpose of this process is to keep only the Plant, material and valuation type that suffer some change in the unit price between the date coming from load and the previous date available for the same key.
• The process is able to identify changes at price control, price per unit and/or amount.

Material stock non cumulative (ABMMIM02*)

Data loading

CPIMMM01 has 3 main datasource loading and all the process is available in the process chain PC_MMIM_00.

1. 2LIS_03_BF movement document. Load movement stock data coming from the classical DSOs Rhodia (ODS_IC01) and Solvay (DPMMIC03) 
2. DTS_MBEW_0001 - price definition according to the material, plant and valuation type
3. DTS_CO_PC_ACT_5_H - historical price according to the end of month position.
   
   

The INIT process is quite different because it should be performed as a sequential process, due to the balance process based on the pointer from datasource 2lis_03_bx

1. ODS_IC01 → ABIMMM03R / DPMMIC03 → ABIMMM03S - Load and activate. Preferably filtering in several full loads split by CALYEAR due to the amount of data during the activation.
2. Run IP for DTS_CO_PC_ACT_5_H, DTS_MBEW_001 and 2LIS_03_BF (requires setup table)
3. DTS_CO_PC_ACT_5_H → AAMMIM02R / AAMMIM02S - Load data
4. DTS_MBEW_001 →  AAMMIM02R / AAMMIM02S - Load data from delta (Avg. price), full last requisition (Std. Price) and activate data.
5. AAMMIM02R → APMMIM01R / AAMMIM02S → APMMIM01S - Load data and activate data.
6. ABIMMM03R → ABMMIM02R / ABMMIM02S → ABMMIM02S - Load and activate. Preferably filtering in several full loads split by CALYEAR due to the amount of data during the activation.
7. AAMMIM01R → ABMMIM01R / AAMMIM01S → ABMMIM01S - Load data, do not need to activate.
8. ABMMIM01R → ABMMIM02R / ABMMIM01S → ABMMIM02S - Load and activate.
9. APMMIM01R → ABMMIM02R / APMMIM01S → ABMMIM02S - Load and activate. Preferably filtering in several full loads split by CALMONTH due to the amount of data during the activation.
10. Run delta DTP from APMMIM01* and ABIMMM03* with the option for initialization.

Loading frequency

     The stock level (movements and revaluation) are available by update in the process chain PC_MMIM_00 and it is part of the flow follows the D4 frequently loaded data schedule. (it is under PC RCP_MMIC)

     There are 2 main process chains that load the stock cubes, which are

1. Normal time on PC RCP_MMIC - 03a IC Complete Transactional  (3 times / day)
2. Extra time on PC    FI_IC_DELTA_EXTR_HOURLY  - 03b IC Minimun Transactional (additional 3 time / day

Reporting

Main queries

Main functionalities

Main key figures

Broadcast

None

Maintenance

None

Planned Evolution

This multi-provider will be used for the next evolution to combine Rhodia legacy to combine in order to have both legacy in the same report and definition.