Describe in a few words the content of application + link with functional or technical specifications (google links) done with during the project or linked with PPMO
Tool Leader + IT leader of the application: Name of project or main leader for the application + reporting coodinator
How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site
Initial project:11249: SpP IND QM - Quality Dashboard
First moved to Production on 24.06.2021
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 autorisation 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 |
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Detail of main topics with explanations of the rules and only the main + special rules about queries to run and use in the correct way
| Technical name | Description | Loading frequency | Explanations |
|---|---|---|---|
| PC_MMIM_42 | MM: IM - T - Filters for Scrapping & Reworking | Trigger, ~Monthly | Load Flat File data imported through Program ZBW_COPQ_FILE to APMMIM05. Triggered by event PC_MMIM_42. |
| PC_MMIM_43 | MM: IM - D - Scrapping and Reworking | Daily at 09:00 | Clear ABMMIM04, then load Current and Previous Month into ABMMIM04 from CPIMMM01, applying relevant filters from APMMIM05. |
| PC_MMIM_44 | MM: IM - M - Scrapping and Reworking M-2 | Monthly, 1st at 09:00 | Load Month M-2 into ABMMIM04B from CPIMMM01, applying relevant filters from APMMIM05. Contains all historical data. |
To be completed once WBP is available again.
| Key Figure | Estimation |
|---|---|
| ~ 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 |
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.
| Technical Query Name | Query Name | Detail |
|---|---|---|
| BW_QRY_CPMMIM07_0001 | MM: IM - Scrapping & Reworking filters (Control Query) | Control query, displays values in APMMIM05 |
| QV_BW_QRY_CPMMIM07_0001 | MM: IM - COPQ Scrapping costs (QV Query) | Calculates Scrapping Cost for Qlik application |
| QV_BW_QRY_CPMMIM07_0002 | MM: IM - COPQ Reworking costs (QV Query) | Calculates Reworking Cost for Qlik application |
Main key figures
| Calculated Key Figure | Description | Formula | Aggregation | Conversion |
|---|---|---|---|---|
| BW_CKF_CPMMIM07_0001 | Total Stock Qty (VKG) | '0QUANT_B' | N/A | QCT_MATNR4 |
| BW_CKF_CPMMIM07_0002 | Total Stock Val (Eur) | IF('0VALUE_LC' <> 0; '0VALUE_LC'; 0) | N/A | CTK_GS04 |
None
Give the list and explanation on the known, not-solved, bugs.
A Flat File (Excel file) will be transmitted to the Support Team monthly to update filters and scrapping/reworking values in APMMIM05.
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.