i-MEP stands for Integrated Manufacturing & Energy Performance
The I-MEP application provides to business the possibility to analyze the production's target cost, actual cost, the variance for each cost item in process order, the cost collector, and to determine energy consumption and CO2 emission during production process.
BI manufacturing reports will replace house solutions :
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
Around 400 users worldwide.
Access to ZIMEP_FILE transaction for Flat File Integration is limited to Yoram Vandijk. In the short- to mid-term, access should be extended to a handful of users.
2018.04.25:
2018.03:
2018.01:
2017.12.21:
2017.11.21:
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M55 | IMEP - Integrated Manufacturing & Energy Performance | Gives access to queries & workbooks IMEP (Manufacturing & Energy reports) |
| ZBI_RCS_IMEP_A01 | IMEP - Integrated Manufacturing & Energy Performance | Gives access to InfoArea IA_FMCO_CO_IMEP* and all authorization relevant objects except
Authorization object ZBI_IMEP |
| ZR_RCS_CA_M551 | IMEP - Upload Data - Non-SAP Plant ZIMEP_FILE | Gives access to transaction ZIMEP_FILE which allows IMEP Flat Files upload. (same logic than for P&L / role ZR_RCS_CA_M432) |
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| GBU (CPFCTR1_2 ) | ZR_*_CA_P05 |
| Plant (C_PLANT) | ZR_*_CA_P02 ZR_7866_CA_P02 => Plant 7866 - Chalampé (ex 7027) - (Cie ZFR9) ZR_TOUT_CA_P02 => All Plants "Solvay" |
| Company (C_COMPCDE) |
See also file maintained by Authorization team : BW Catalog of Roles / link: https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
https://drive.google.com/open?id=18v4PEvS10Q4RmofZBDuuuTiyTqO9anDL3x-Bcxvnv2s


This table exists on both systems PF1/WP1, but the structure is slightly different.
Following additional fields exists for PF1 table, but not for WP1 table : append ZWPPMCKOST_EXTRA
Process Chain | Code |
|---|---|
| Code établissement DSI | ETABL |
| Code édition | EDITI |
| Libellé de la ligne d'édition | LIBLI |
| Type: Fix/Var/Dep | FVD |
| Cost collector for production process PROCNR | PKOSA |
| Material Ledger Cost | MLWRT |
| Material Ledger Variable Cost | ML_VC |
| Material Ledger Fixed Cost | ML_FC |
| Material Ledger Dependencies Cost | ML_DEP |
| Material Ledger Unit Cost | ML_UCOST |
This table is filled via program XXX and contains only the values for the previous period (The table is emptied before each loading)
This table exists on both systems PF1/WP1, and is filled manually by Energy Carbon team
This table exists on system PF1 and contains texts for Origin Group.
This view exist on system PF1 and references table:
View contains Texts associated to Origin Group.
View is filtered on Controlling Area = CHEF, Origin Type = 02 and Language = English.
This view exist on system PF1 and references tables:
View contains all levels of Cost Object Hierarchy as attributes, as well as the associated texts.
View is filtered on CKPHT Language = English. (obsolete)
Tables are filled from table KKPHIE. (To be confirmed)
This view exist on system PF1 and references tables:
View contains Texts associated to R/3 Establishments.
For PF1 only:
Datasource : DTS_ZBW_V_ZWPPMCKOST based on view ZBW_V_ZWPPMCKOST
The controlling area is unique on PF1 ( value CHEF), but not on WP1 ( Z006, Z025, Z026...)
The controlling Area is not available on ECC side specific tables, but, in order to match the BI referential, this information is necessary to get referential attribut and texts (example 'Cost Center' C_COSTCTR, 'Profit Center' C_PFT_CTR)
To get the information extractor are based on specific view with follow the business rule given :
The Cost Component Structure id is not unique on PF1 (on WP1, only id Z1 is used), and the id is not part of source table ZWPPMCKOST.
The append ZEXTRA_FIELDS has been added to extract structure of the data source (ZOXDF10019). Fields belonging to the append are field within class ZDTS_ZBW_V_ZWPPMCKOST.
To get the information :
Some Cost Elements do not fit the standard format for this Master Data - coded on 6 characters, they stand for Statistical Key Figures that are not used.
Because these Cost Elements do not exist in hierarchy CHEFXCS-ALL, values for attributes C_CELTHX1/2/3/4/5 are collected through Flat File flow based on DataSource DTS_FMCO_0COSTELMNT_01.
Statistical Key Figures are loaded using generic datasources 0STKEYFIG_ATTR (Attributes) and 0STKEYFIG_TEXT (Texts).
Texts from Statistical Key Figures are then copied in Cost Element texts.
Generic datasources exist in SOLVAY PF1 Dataflow only.
The GBU available for reporting is BFC Global Business Unit (CPFCTR1_2)
For Solvay PF1 data, the GBU is calculated at Business Level following below rule
Case 1: Profit Center (0PROFIT_CTR) & Company Code (C_COMPCDE)are filled
Case 1a: Profit Center is 10 characters long + starting with 'F' + plant is filled
Case 1b: Profit Center on 5 positions starting by 'D'
Case 2 : Plant (C_PLANT) & Material (C_MATPNT2) are filled
Case 3: Controlling Area (0CO_AREA), Cost Center (C_COSTCTR) are filled
The flag is set to 'X' when :

This rule is settled in transformation at Business Level for SOLVAY PF1 only
The flag is set to 'P' (Produced Component) when Index1 = 3 and Origin exists as an Index1 = 1 Material in the source package.
This allows users to filter out lines where a component of a Material already exists as a Material, to avoid counting the associated key figures twice.
This rule is settled in transformation at Business Level for both SOLVAY PF1 and RCS WP1.
For SOLVAY PF1 (DBCOPP01/04) and Flat Files (DBCOPP03), Material Ledger Costs are split between 3 components:
From Flat File, for index1 = 3 or index1 = 9, we check that K_MLWRT is not null.
At all times, K_MLWRT = K_ML_FC + K_ML_VC + K_ML_DEP.
The same split has been added to RCS WP1 (DBCOPP02/05) for MultiProvider assignment, based on Cost Component Group 0CCOMPGRP.
In DBCOPP01/04 (SOLVAY PF1), Origin details have been split between 5 infoObjects:
Their value is dependent on the Index1 value and C_ORIGIN structure:
The same split has been applied to DBCOPP02/05 (RCS WP1), with simplified rules:
Origin Texts are collected from PF1 and WP1. Loads are included in Main Chains and thus happen daily on Current Month (and Previous Month from 01 to 08 of each month).
Because of a large amount of missing texts, a corrective DTP runs every day to collect texts from other Master Data, once more based on the first 2 characters of C_ORIGIN:
There is also a special case where text exists but must be replaced: If INDEX1 = 5 and Text begins with 'ATY', apply the same text as 'KL' Origins.
Origin Group is collected as a subchain of CO Key Subnumber (C_COKSNB)
Origin Group Texts are collected from SOLVAY PF1 by datasource DTS_ZBW_V_TKKH2.
Origin Group is also collected as attribute of C_ORIMAP3, infoobject created in reference to C_MATPNT3 and identical to C_ORIMAT in our data. That Origin Group, C_ORIMAP3__C_HRKFT, is collected from SOLVAY PF1 by datasource DTS_MBEW_01.
Total Actual Quantity is converted to fill the values of the following attributes of Activities DSOs (DBCOPP04 for SOLVAY PF1, DBCOPP05 for RCS WP1):
Conversion is based on Real Factors DSOs (DBCOPP10 for PF1, DBCOPP11 for WP1) and ZBW_V_CO2_COEFFS DSOs (DBCOPP07 for PF1, DBCOPP08 for WP1).
If coefficient Real Factor Conversion (K_RFACONV) exists in Real Factors DSO, TAQ Standard and TAQ in EP are calculated using that coefficient. Otherwise, they are calculated using Local To Standard UoM Conversion (K_UOMCONV) and Primary Energy Coefficient (K_ENGCOEF), respectively, from ZBW_V_CO2_COEFFS DSO.
TAQ in CO2 are always calculated using coefficients CO2 Emission Scope (K_CO2EMI1/2/3) from ZBW_V_CO2_COEFFS DSO if they exist.
CHEFXCS-ALL Hierarchy Levels are stored in Master Data Cost Element, in attributes C_CELTHX1 to C_CELTHX5.
Levels are stored as follow:
| Attribute | Hierarchy Level | Example |
|---|---|---|
| C_CELTHX1 | 2 | XCS-SELL |
| C_CELTHX2 | 3 | XCS-SELLA |
| C_CELTHX3 | 4 | XCS-SELLB |
| C_CELTHX4 | 5 | XCS-SELLC |
| C_CELTHX5 | 6 | XCS-SALE01 |
Hierarchy Level 1 is always "XCS-ALL" and thus not stored.
(None known)
Stream | Rule | Explanation |
|---|---|---|
| IMEP | RCS_LOAD | Period (YYYYPPP) to load, RCS. NO_LOAD to avoid loadings Do not change active flag (Active = Y) This variable is used in decision block |
| IMEP | RCS_DEL | Period (YYYYPPP) to delete, RCS DSO/Cube. NO_DEL to avoid Do not change active flag (Active = Y) |
| IMEP | RCS_HISTO | Counter 1 = Number of Year to keep in all DSOs/Cubes RCS Counter 2 = Delete all data in all DSOs/Cubes RCS older than The counter 1 is entered manually, it is a number of years to keep in all DSOs and Cubes. If '3' is entered, 3 full years + current year are kept. The counter 2 is determined within program ZBW_IMEP001 depending of the loaded period and the counter 1. Example : we are the 01/08/2016, the period 007.2016 is loaded. As the counter 1 is '3', the calculated counter 2 is 001.2013. All period previous to 001.2013 will be deleted via the main process chain |
| IMEP | SOLV_LOAD | Same explanation as RCS_LOAD |
| IMEP | SOLV_DEL | Same explanation as RCS_DEL |
| IMEP | SOLV_HISTO | Same explanation as RCS_HISTO |
| IMEP | FF_DATA | Counter 1 = Input filename for ZBW_IMEP002 program. Counter 2 = Store actual delta queue of running process chain PC_CO_IMEP_15. Counter 3 = Total counter for ZBW_IMEP002 program file loading. Counter 4 = Version to be updated by program ZBW_IMEP002 (All existing data for that Version and that Version only are deleted) |
Program | Variant | Explanation |
|---|---|---|
| ZBW_DELDIM | ZVAR_IMEP_01 | Existing program, reused to clean cube dimensions. It delete unused dimension elements |
(Obsolete) |
|
|
| ZBW_IMEP002 | Program created for the project to allow users to load flat files to integrate additional IMEP data. Program is not used in Process Chain, but launches event PC_CO_IMEP_15 or PC_CO_IMEP_32, starting PC of the same name. | |
| ZBW_IMEP003 | ZVAR_DEL_RCS1 ZVAR_DEL_FF1 ZVAR_DEL_FF2 | Program created for the projet to :
Program replaces ZBW_IMEP001 and takes into account whether Current Month M (variants XXX1/XXX3) or Previous Month M-1 (variants XXX2/XXX4) is being reloaded.
Variables ZVAR_DEL_FF* used for Flat File imports, modifying filters so that data is deleted in Budget DSOs and Cubes depending on Version C_VERSF (and soon Plant C_PLANT) rather than Period 0FISCPER. |
| ZBW_IMEP004 | ZVAR_COPP01 ZVAR_COPP02 | Program created for the project to delete non-current data (M-2 and older) from InfoProviders. It is only used as of now to clear DBCOPP01/CRCOPP01 after the historical data has been sent to history flow (DBCOPP04) for SOLVAY PF1 and to clear DBCOPP02/CRCOPP02 after the hsitorical data has been sent to history flow (DBCOPP05) for RCS WP1. |


User must first indicate whether he is loading a Planned Data Budget File (Target: CRCOPP03, Event/Process Chain launched: PC_CO_IMEP_15) or a Cost Center Postings Budget File (Target: CRCOPP08, Event/Process Chain launched: PC_CO_IMEP_32). Only one type of file can be loaded at once, and both types have different format.
User can choose an Excel flat file from his local computer by using the "File to load" browser.

Once the file is choosen, the user can preview the content to be uploaded from his selected file by clicking on "Preview" icon.
Preview is color-coded: green entries are correct, while yellow ones return warnings and red ones return one or more errors.

Once the file is choosen, the user can start the content checking of the file by clicking on "Check file" icon.
If errors and warnings exists, they will be listed with a description of the error at the end of each line.

Once the file content is checked and all errors corrected, the user can load the file to BW application server (AL11) and raise the event associated with the type of import they chose by clicking on "Load file" icon.
The event PC_CO_IMEP_15 triggers the process chain PC_CO_IMEP_15 - "IMEP: META - T - Main (Flat Files)".
The event PC_CO_IMEP_32 triggers the process chain PC_CO_IMEP_32 - "IMEP: META - T - Main (CC postings) (Flat Files)".
Either process chain will load the user's file data into IMEP BW application.


User can view the history of loaded files by clicking on "History" icon.

The user can exit the program by clicking on "Exit" icon.
Report ZBW_IMEP002 contains several distinct forms:
Selection screen.
f200-import_file: Import the XLS file from user's workstation.
f210-upload_excel: Convert the XLS file in Internal table.
f220-check_file: Check content of the file as follow, only for Planned Data Budget Files:
For more details, see file ZWPPMCKOST_table structure & contents_QF1.xlsx. (obsolete)
BUSINESS RULE 2. FISCAL YEAR VALUE - IMEP_BR2
Year, between 1900 and 2999
BUSINESS RULE 3. PERIODVALUE - IMEP_BR3
Month, between 01 and 12
BUSINESS RULE 4. INDEX VALUE - IMEP_BR4
Index is 1 (Produced material), 3 (BOM Component) or 9 (SKF/Direct Posting)
BUSINESS RULE 5. COST OBJECT EXISTS - IMEP_BR5
Check DSO DBCOPP13 for Cost Object. Empty Cost Object is accepted too.
BUSINESS RULE 6. COST ELEMENT EXISTS - RK14_2
Check Master Data 0COSTELMNT for Cost Element with Controlling Area CHEF and Level 1 Hierarchy XCS-ALL
BUSINESS RULE 7. COST CENTER
BUSINESS RULE 7.1. COST CENTER MANDATORY FOR INDEX 9 - RK3_1
BUSINESS RULE 7.2. COST CENTER EXISTS - RK3_2
Check Master Data C_COSTCTR for Cost Center with Controlling Area CHEF
BUSINESS RULE 8. ORIGIN
BUSINESS RULE 8.1. ORIGIN MANDATORY FOR INDEX 3 - IMEP_BR8_1
BUSINESS RULE 8.2. ORIGIN EXISTS (as MATERIAL) - IMEP_BR8_2
Check Master Data C_MATNR2 for Origin with Source System PF1_020
BUSINESS RULE 9. UNIT EXISTS - RD12_2
Check Master Data 0UNIT for Unit
BUSINESS RULE 10. CURRENCY EXISTS - RD11_2
Check Master Data 0CURRENCY for Currency.
BUSINESS RULE 11. KEY FIGURES VALUES - IMEP_BR11
For index 3 and 9, check that Material Ledger Costs are not null (Sum of Fixed Costs, Variable Costs and Dependencies)
BUSINESS RULE 12. DUPLICATE ENTRIES (WARNING) - RD14
f230-check_file_cc: Check content of the file as follow, only for Cost Center Postings Budget Files:
Info: Business Rules sharing the same name are identical in both "check_file" forms.
BUSINESS RULE 2. FISCAL YEAR VALUE - IMEP_BR2
Year, between 1900 and 2999
BUSINESS RULE 3. PERIOD VALUE - IMEP_BR3
Month, between 01 and 12
BUSINESS RULE 6. COST ELEMENT EXISTS - RK14_2
Check Master Data 0COSTELMNT for Cost Element with Controlling Area CHEF and Level 1 Hierarchy XCS-ALL
BUSINESS RULE 7. COST CENTER
BUSINESS RULE 7.2. COST CENTER EXISTS - RK3_2
Check Master Data C_COSTCTR for Cost Center with Controlling Area CHEF
BUSINESS RULE 7.3. PARTNER COST CENTER EXISTS - IMEP_BR7_3
Check Master Data C_COSTCTR for Cost Center with Controlling Area CHEF
BUSINESS RULE 9. UNIT EXISTS - RD12_2
Check Master Data 0UNIT for Unit
BUSINESS RULE 10. CURRENCY EXISTS - RD11_2
Check Master Data 0CURRENCY for Currency.
BUSINESS RULE 12. DUPLICATE ENTRIES (WARNING) - RD14
f300-output_preview: Generate ALV grid to show Converted data from Excel.
f310-output_check: Generate ALV grid to show Converted data from Excel after check.
f400-load_pchain: Check if process chain is already in progress.
f413-csv_file_data: Import Customer file in ALL11.
f423-filename_data: Update Global filter master data with new file name.
f433-savelog_data: Update log after loading (DSO DBCOPP09 - "IMEP - Log Import (Non-SAP Plant) ( Direct Update )").
f440-finish_message: Pop-up message once the program's operations are complete.
f453-send_email_data: Send an email after data loading.
f463-delete-obsolete-data: Selective deletion of data in either DPCOPP03/DBCOPP03/CRCOPP03 or DPCOPP04/DBCOPP14/CRCOPP08 based on Version (C_VERSF) and Fiscal Period (0FISCPER).
f500-display_log: Display log.


All DSOs and Cubes listed in the program variant will be cleared of all M-2 data and older, leaving only Current and Previous Month.
PF1:
Z1C_RUNDMC_KOST for current month update
Z1C_RUNDMC_KOST_PREV_MTH for previous month update
WP1:
ZWPP_RUNDMC_KOST for current month update
ZWPP_RUNDMC_KOST_PREV_MTH for previous month update
Flat Files:
PC_CO_IMEP_15 for every Budget update
PC_CO_IMEP_32 for every CC Postings update
No chain runs on Sunday.
Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
| IMEP: META - T - Current month (Solvay) | PC_CO_IMEP_01 | MAIN | 09 to 31 | This chain is starting when event Z1C_RUNDMC_KOST is received from Solvay PF1. Global Filter IMEP/SOLV_LOAD is used in the decision block. Usually starts around 4:00 (CET)
|
| IMEP: META - T - Previous month (Solvay) | PC_CO_IMEP_20 | MAIN | 01 to 08 | This chain is starting when event Z1C_RUNDMC_KOST_PREV_MTH is received from Solvay PF1. Global Filter IMEP/SOLV_LOAD is used in the decision block. DBCOPP10 (Solvay Real Factors) is updated and activated in this PC only. Usually starts around 4:00 (CET)
|
| IMEP: META - T - Main (Current) (RCS) | PC_CO_IMEP_08 | MAIN | 01 to 31 | This chain is starting when event ZWPP_RUNDMC_KOST is received from RCS WP1. Global Filter IMEP/RCS_LOAD is used in the decision block. Usually starts around 1:30 (CET)
|
| IMEP: META - T - Main (Previous) (RCS) | PC_CO_IMEP_25 | MAIN | 01 to 08 | This chain is starting when event ZWPP_RUNDMC_KOST_PREV_MTH is received from RCS WP1. Global Filter IMEP/RCS_LOAD is used in the decision block. Usually starts around 4:00 (CET)
|
| IMEP: META - T - Planned data for Budget (Flat Files) | PC_CO_IMEP_15 | MAIN | Manually (Trigger) | This chain is starting when event PC_CO_IMEP_15 is received from ZBW_IMEP002 Program. |
| IMEP: META - D - Cost Object Hierarchy (DBCOPP13/C_KSTRG4) | PC_CO_IMEP_26 | MAIN | Daily | This chain is starting every day at 5:30 (CET) |
| IMEP: TXT - D - R3 Establishment | PC_CO_IMEP_27 | MAIN | Daily | This chain is starting every day at 8:05 (CET) |
| IMEP: META - W - Standard Key Figure (Solvay) | PC_CO_IMEP_30 | MAIN | Weekly | This chain is starting every Saturday at 8:00 (CET) |
| IMEP: META - T - Cost Center postings (Flat Files) | PC_CO_IMEP_32 | MAIN | Manually (Trigger) | This chain is starting when event PC_CO_IMEP_32 is received from ZBW_IMEP002 Program. |
| IMEP: TD - M - Historical Data (Solvay) | PC_CO_IMEP_37 | MAIN | Monthly | |
| IMEP: TD - M - Historical Data (RCS) | PC_CO_IMEP_38 | MAIN | Monthly |
Process Chain | Code | Type | Main chain | Comments |
|---|---|---|---|---|
| IMEP: MD - Referential & Conversion factors (Solvay) | PC_CO_IMEP_02 | subchain | 1/20 | Data requiered for Business Rules |
| IMEP: TD - Delete period in DSOs (Current) (Solvay) | PC_CO_IMEP_03 | subchain | 1 | Before loading a period, the same period has to be deleted from target DSOs. The same is done in cubes using a Delete Overlapping DTP after they are loaded. Global Filter IMEP/SOLV_DEL is used |
| IMEP: TD - Propagation (Solvay) | PC_CO_IMEP_04 | subchain | 1/20 | Global Filter IMEP/SOLV_LOAD is used to limit the InfoPackage + C_ORIGIN (textes) loading |
| IMEP: TD - Business (Solvay) | PC_CO_IMEP_05 | subchain | 1/20 | |
| IMEP: TD - Reporting (Current) (Solvay) | PC_CO_IMEP_06 | subchain | 1 | |
| IMEP: MD - Texts (Solvay) | PC_CO_IMEP_07 | subchain | 1/20 | This load could be done once a week or once a month |
| IMEP: MD - Referential & Conversion factors (RCS) | PC_CO_IMEP_09 | subchain | 8/25 | Data requiered for Business Rules |
| IMEP: TD - Delete period in targets (Current) (RCS) | PC_CO_IMEP_10 | subchain | 8 | Before loading a period, the same period has to be deleted from targets (DSO/Cubes) Global Filter IMEP/RCS_DEL is used |
| IMEP: TD - Propagation (RCS) | PC_CO_IMEP_11 | subchain | 8/25 | Global Filter IMEP/RCS_LOAD is used to limit the InfoPackage + C_ORIGIN (textes) loading |
| IMEP: TD - Business (RCS) | PC_CO_IMEP_12 | subchain | 8/25 | |
| IMEP: TD - Reporting (Current) (RCS) | PC_CO_IMEP_13 | subchain | 8 | |
| IMEP: MD - Texts (RCS) | PC_CO_IMEP_14 | subchain | 8/25 | This load could be done once a week or once a month |
| IMEP: TD - Propagation (Flat Files) | PC_CO_IMEP_16 | subchain | 15 | |
| IMEP: TD - Business (Flat Files) | PC_CO_IMEP_17 | subchain | 15 | |
| IMEP: TD - Reporting (Flat Files) | PC_CO_IMEP_18 | subchain | 15 | |
| IMEP: TD - Delete period in DSOs (Previous) (Solvay) | PC_CO_IMEP_21 | subchain | 20 | Before loading a period, the same period has to be deleted from target DSOs. The same is done in cubes using a Delete Overlapping DTP after they are loaded. Global Filter IMEP/SOLV_DEL is used |
| IMEP: TD - Reporting (Previous) (Solvay) | PC_CO_IMEP_22 | subchain | 20 | |
| IMEP: TD - Reporting (Previous) (RCS) | PC_CO_IMEP_23 | subchain | 25 | |
| IMEP: TD - Delete period in targets (Previous) (RCS) | PC_CO_IMEP_24 | subchain | 25 | Before loading a period, the same period has to be deleted from targets (DSO/Cubes) Global Filter IMEP/RCS_DEL is used |
| IMEP: TXT - Cost Element (through 0STKEYFIG) (Solvay) | PC_CO_IMEP_28 | subchain | 30 | Loads 0STKEYFIG Texts and copy them in 0COSTELMNT for Controlling Area CHEF |
| IMEP: MD - Standard Key Figure (Solvay) | PC_CO_IMEP_29 | subchain | 30 | Loads 0STKEYFIG Attributes |
| IMEP: TD - Delete period in DSOs for Budget (Flat File) | PC_CO_IMEP_31 | subchain | 15 | Before loading a period, the same period has to be deleted from targets (DSO/Cubes) Global Filter IMEP/SOLV_DEL is used for Period, and IMEP/FF_DATA/4 is used for Version. New filter to be added for Plants |
| IMEP: TD - Delete period in DSOs for CC postings (FF) | PC_CO_IMEP_33 | subchain | 32 | Before loading a period, the same period has to be deleted from targets (DSO/Cubes) Global Filter IMEP/SOLV_DEL is used for Period, and IMEP/FF_DATA/4 is used for Version. New filter to be added for Plants |
| IMEP: TD - Propagation (CC postings) (Flat Files) | PC_CO_IMEP_34 | subchain | 32 | |
| IMEP: TD - Business (CC postings) (Flat Files) | PC_CO_IMEP_35 | subchain | 32 | |
| IMEP: TD - Reporting (CC postings) (Flat Files) | PC_CO_IMEP_36 | subchain | 32 |
IMEP is loaded daily. Previous month is loaded from 01 to 08 only while Current month is loaded from 09 to the end of month.
Events on Solvay ECC (PF1) and RCS (WP1) start BW Process Chains. These events are not expected to run on Sundays.
Flat Files (Excel file) can be loaded manually in transaction ZIMEP_FILE, at will.
if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 1 hour 20 minutes (PC 01/20) 40 minutes (PC 08/25) 10 minutes (PC 15/32) 5 minutes (PC 26) <1 minute (PC 27/30) |
| ~ Average nb of rows loaded per load | CRCOPP01 - 0 → 15.000 CRCOPP04 - 0 → 200.000 CRCOPP06 - 0 → 100.000 CRCOPP07 - 0 → 6.000 CRCOPP09 - 0 → 400.000 |
| ~ Total nb of rows loaded (if full) | Business level on 2018.06.28: DBCOPP01 - 260.000 DBCOPP02 - 600.000 DBCOPP03 - 16.000 DBCOPP04 - 2.600.000 DBCOPP05 - 4.800.000 DBCOPP06 - 1.550.000 Others - <1.000 DBCOPP12 - 108.000 DBCOPP13 - 58.000 DBCOPP15 - 6.450.000 DBCOPP16 - 1.810.000 Total in MVCOPP01 - 17.200.000 |
| ~ Average Runtime for 10k lines |
Business requires 3 years of historical data in addition to current year. (Y to Y-3)
Cubes contain data since 2017. Historical data beyond this is stored in Propagation/Business level.
The number of years to keep can be maintained in Global Filter (C_GLBFILT) masterdata (Stream IMEP / Rule RCS_HISTO or SOLV_HISTO/ Counter '001')
Older data are deleted from DSOs/Cubes at the end of the RCS and Solvay process chains (PC_CO_IMEP_01/08/20/25).
Data availability for go live (01.2017)
From Solvay PF1 : 2014 + 2015 + 2016
From RCS WP1: 2015 + 2016 (2014 was not available anymore as year was archived in WP1)
Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.
Report | Technical name | Type | Comment | Link to documentation |
|---|---|---|---|---|
| MANUFACTURING - Local Core Query | BW_QRY_MVCOPP01_0002 | QRY | Manufacturing report will be used to display all the characteristic and key figures loaded from the ZWPP40x program. This report will display key figures only on company code currencies and local base unit of measure. | https://drive.google.com/open?id=14wAf4AjUgq2jcQko5A2AyEYY_pd2evwVokizwSomUPQ |
| MANUFACTURING - Consolidation Core Query | BW_QRY_MVCOPP01_0008 | QRY | Manufacturing report will be used to display all the characteristic and key figures loaded from the ZWPP40x program. This report will provide the possibility to display unit of measure and currency in a consolidate target unit. | https://drive.google.com/open?id=1-UP2e782f6PX1huigJezI6_rLRnVWskAQp5YonjgNG0 |
| MANUFACTURING - Consolidation QV Query | QVIMEP_BW_QRY_MVCOPP01_0008 | QRY | This report is based on BW_QRY_MVCOPP01_0008 report, and is dedicated to QV application. | https://drive.google.com/open?id=1S9WSHO0R2ecDV7pPkupkcO4fRJdAHtC1OC4Vz9lnEdo |
| ENERGY: Consumption, Expenses and Carbon Footprints (Core Query) | BW_QRY_MVCOPP01_0003 | QRY | Report will display the energy purchase information | https://drive.google.com/open?id=1MbtEZhYOs87E_jcm9JXTqwfvbSNdjrMEIiZ6JwDAkzI |
| ENERGY: Consumption, Expenses and Carbon Footprints (QV Query) | QVIMEP_BW_QRY_MVCOPP01_0003 | QRY | This report is based on BW_QRY_MVCOPP01_0003 report, and is dedicated to QV application. | https://drive.google.com/open?id=1LbrgXlPPQacJRqqX-OU6c7ZhX8uX-oLL2IEq2RagsMI |
| DEPRECATED - ENERGY - Primary Energy and Emission report (Core Query) | BW_QRY_MVCOPP01_0007 | QRY | Report will display the primary energy consumption. DEPRECATED: Merged with BW_QRY_MVCOPP01_0003. | https://drive.google.com/open?id=1bDPL8PQk0xd7FJcVyjK78qxf6ew_QOvJTWY5nkwqhLU |
| ENERGY - Interface Production Report (Core Query) | BW_QRY_MVCOPP01_0006 | QRY | 3 reports will be used to provide source data to the EPS system. As this is a temporary solution, the reports will be executed manually by the users. No automation process will be implemented | https://drive.google.com/open?id=1H8vxrSJ01jwvmUvA4movkau8umTE-18rbV48Mb1tCmc |
| ENERGY - Interface Cost Production Report (Core Query) | BW_QRY_MVCOPP01_0005 | QRY | 3 reports will be used to provide source data to the EPS system. As this is a temporary solution, the reports will be executed manually by the users. No automation process will be implemented | https://drive.google.com/open?id=1bT_alWdGYpmnMUqvvfyGSfWHjNRcvtnrLhPeM6ckCLA |
| ENERGY - Interface Consumption Quantity Report (Core Query) | BW_QRY_MVCOPP01_0004 | QRY | 3 reports will be used to provide source data to the EPS system. As this is a temporary solution, the reports will be executed manually by the users. No automation process will be implemented | https://drive.google.com/open?id=1LIajg9nEMubjjA8znhnEnoT3Bncjcp8ftVlQxwbpckI |
| MANUFACTURING - Reconciliation (Workbook) | WB | Manufacturing data reconciliation workbook will be created to compare VC, FC, DEP key figures between the P&L – legal view report and the manufacturing report. | ||
| BW - IMEP - Energy Interface (Core Workbook) | BW_WBK_CO_0001 | WB | https://docs.google.com/document/d/1EMEAbFrL_blJWnpHMN_rT8TuwPWZ2gzGxkMwosd0J1c |
Short description | Explanation | Formula | Comments |
|---|---|---|---|
AUQ AI | Actual Unit Quantity (in French QUR) in Active Ingredient | - Total Actual Qty in AI
Total Actual Qty in AI : ratio K_AQTY_AI, origin field ACT_QTY_AI of table ZWPPMCKOST
Qty Produced in AI : ration K_QTYPRAI, origin field MEGP_AI The produced quantity in AI is found only for Index 1 = '1'. The quantity has to be used to calculate the coefficient on others indexes |
Restricted Keyfigure for Quantity Produced in AI with Constant Selection for all characteristics except Period/GBU/CompanyCode/PlantMaterial
Calculated Keyfigure for AUQ AI
|
| QUS | Standard Consumption factor of the item for one unit produced | - Std Qty SCE
Std Qty SCE: ratio K_STQTSCE, origin field MEVS5 of table ZWPPMCKOST Std Qty SCE (produced material): ratio K_STQTSCE limited on index 1 = '1' (Produced material) | Restricted Keyfigure for Std Qty SCE (produced material) with Constant Selection for all characteristics except Period/GBU/CompanyCode/PlantMaterial Calculated Keyfigure for QUS |
| QUR | Actual Consumption factor of the item for one unit produced | - Total Actual Quantity
Total Actual Quantity : ratio K_ACT_QTY, origin field ACT_QTY of table ZWPPMCKOST Produced Quantity : ratio K_PRODQT, origin field MEGP of table ZWPPMCKOST The produced quantity is found only for Index 1 = '1'. The quantity has to be used to calculate the coefficient on others indexes Lot Size : generally 1000. The Lot size is not currently available, use 1000 for the moment. | Restricted Keyfigure for Produced Quantity with Constant Selection for all characteristics except Period/GBU/CompanyCode/PlantMaterial Calculated Keyfigure for QUR
|
| CUS | Standard unitary cost of the item for one unit produced | - Std Cost SCE
Std Cost SCE: ratio K_STCSSCE, origin field WKVS5 of table ZWPPMCKOST Std Qty SCE (produced material): see upper definition | Calculated Keyfigure for CUS |
| CUR | Actual unitary cost of the item for one unit produced | - Actual Cost
Actual Cost : ratio K_ACT_CST, origin field WKGIB of table ZWPPMCKOST Produced Quantity & Lot Size: see upper definition | Calculated Keyfigure for CUR |
| SUQ AI | Standard Unit Quantity (in French QUS) in Active Ingredient | - Std Qty SCE in AI
Std Qty SCE in AI : ratio K_SCEQ_AI, origin field MEVS5_AI of table ZWPPMCKOST Std Qty SCE in AI (produced material): ratio K_SCEQ_AI limited on index 1 = '1' (Produced material) | Restricted Keyfigure for Std Qty SCE in AI with Constant Selection for all characteristics except Period/GBU/CompanyCode/PlantMaterial Calculated Keyfigure for SUQ AI |
| Lot Size | Lot Size used for calculating standard cost | This KPI is coming from ZWPPMCKOST table. The value is repeated on each lines. Then in BW, for aggregated analysis, the sum of all values is displayed which is not correct. The Lot Size should be a masterdata information. | |
| ML Cost |
| ||
| ML Price |
| ||
No broadcast
Give the list and explanation on the known, not-solved, bugs.



Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016