General presentation

Objective of the application

Tool Leader + IT leader of the application: 

Usage information

History

Initial project:11249: SpP IND QM - Quality Dashboard

First moved to Production on 24.06.2021

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Role CodeRole DescriptionExplanation
ZR_RCS_CA_M03IM StocksMenu role






Authorization objects

List of autorisation objects mandatory for the application.

Authorization objectExplanation
C_COMPCDE__C_AUTHMACompany authorization scope
C_PLANT__C_AUTHMAPlant authorization scope
CPFCTR1_2Business unit

Dataflow overview

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Temporary link (Part 1 only)

Exemple of dataflow overview :

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Data loadings

Info providers and objects loaded


Technical nameDescriptionLoading frequencyExplanations
PC_MMIM_42MM: IM - T - Filters for Scrapping & ReworkingTrigger, ~Monthly

Load Flat File data imported through Program ZBW_COPQ_FILE to APMMIM05.

Triggered by event PC_MMIM_42.

PC_MMIM_43MM: IM - D - Scrapping and ReworkingDaily at 09:00Clear ABMMIM04, then load Current and Previous Month into ABMMIM04 from CPIMMM01, applying relevant filters from APMMIM05. 
PC_MMIM_44MM: IM - M - Scrapping and Reworking M-2Monthly, 1st at 09:00Load Month M-2 into ABMMIM04B from CPIMMM01, applying relevant filters from APMMIM05. Contains all historical data.

Average performance

To be completed once WBP is available again.


Key FigureEstimation
~ Average Process Chain Runtime A few minutes
~ Average nb of rows loaded per load Less than a thousand per load
~ Total nb of rows loaded (if full) N/A
~ Average Runtime for 10k lines N/A

Record Keeping

ABMMIM04 only contains M & M-1 Data.

ABMMIM04B contains all older data. As it is an Inventory ADSO, it cannot be partially cleared by an automated job. Currently contains data from 01.2021 onwards. We do not expect to need data more than 12 months old, to be cleared manually (selective deletion) if needed.

Reporting

Main queries


Technical Query NameQuery NameDetail
BW_QRY_CPMMIM07_0001MM: IM - Scrapping & Reworking filters (Control Query)Control query, displays values in APMMIM05
QV_BW_QRY_CPMMIM07_0001MM: IM - COPQ Scrapping costs (QV Query)Calculates Scrapping Cost for Qlik application
QV_BW_QRY_CPMMIM07_0002MM: IM - COPQ Reworking costs (QV Query)Calculates Reworking Cost for Qlik application

Main functionalities


Main key figures

Calculated Key FigureDescriptionFormulaAggregationConversion
BW_CKF_CPMMIM07_0001Total Stock Qty (VKG)'0QUANT_B'N/AQCT_MATNR4
BW_CKF_CPMMIM07_0002Total Stock Val (Eur)IF('0VALUE_LC' <> 0; '0VALUE_LC'; 0)N/ACTK_GS04

Broadcast

None

Maintenance

Known bugs

Recurring procedure

Flat File Import Procedure for Support Team

A Flat File (Excel file) will be transmitted to the Support Team monthly to update filters and scrapping/reworking values in APMMIM05.

  1. Selective deletion of the loaded period in APMMIM05. (Cautionary measure: in a normal run, no data should exist for the period loaded as each period is loaded once)
  2. Run Program ZBW_COPQ_FILE in SE38
  3. Select your file and wait for it to be checked by the program
  4. Press “Check File” to confirm there is no error in file according to set Business Rules
    1. If there are errors, check last column of displayed table to see error message
    2. Correct file in Excel and repeat from step 1
  5. Press “Load File” to launch Process Chain PC_MMIM_42 (through Event of the same name) that will load APMMIM05
  6. Import completed.

Planned Evolution

Changes to the way we handle Reworking Cost calculation are planned for the second semester of 2021.

Extension to more GBUs than Specialty Polymers is expected, but not planned yet.


  • No labels