General presentation

Objective of the application

i-MEP stands for Integrated Manufacturing & Energy Performance

The I-MEP application provides to business the possibility to analyze the production target cost / actual cost / variance for each cost item in process order / cost collector, and to determine energy consumption and CO2 emission during production process.

BI manufacturing reports will replace house solutions :

• on RCS (WP1) : programs ZWPP40A/B/C
• on Solvay (PF1) : program Z1K_MATCOST (Prix de Revient)
• 
  

Tool Leader + IT leader of the application: 

Usage information

History

Roles & Access

Roles and access

Authorization objects

List of autorisation objects mandatory for the application.

See also file maintained by Authorization team : BW Catalog of Roles / link: https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

Dataflow overview

https://drive.google.com/open?id=18v4PEvS10Q4RmofZBDuuuTiyTqO9anDL3x-Bcxvnv2s

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Source tables

Table ZWPPMCKOST / i-MEP extraction table

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

This table is filled via program XXX and contains only the values for the previous period (The table is emptied before each loading)

to be completed

Table ZZX_CO2_COEFFS / Energy and CO2 Emission Coeffcients

This table exists on both systems PF1/WP1, and is filled manually by Energy Carbon team

to be completed

At datasource level (PF1/WP1)

Datasource : DTS_ZBW_V_ZWPPMCKOST based on view ZBW_V_ZWPPMCKOST

Controlling Area (0CO_AREA)

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 : 

• A plant belongs to a single company code (link found in table T001K where 'Valuation Area' (BWKEY) corresponds to the plant (WERKS)
• A company code belongs to a single controlling area (link found in table TKA02 / field 'Business Area' (GSBER) is always empty) 

Cost Component Structure (0CCOMPSTRUC)

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 :

• by default set id to 'Z1' except for exception managed in table TCK07 'Costing Variants for Organizational Units'
• Exceptions for certain company codes (BUKRS)
  • ignore value '++++'
  • keep only one valid record by company code (the latest)

At business level (WBP)

At reporting level (WBP)

GBU (CPFCTR1_2)

The GBU available for reporting is BFC Global Business Unit (CPFCTR1_2) found on Cost Center

Dependencies with other applications

Data loadings

Info providers and objects loaded

Global Filters (C_GLBFILT) used in Chains

ABAP Programs used in Chains

Further examplation for program ZBW_IMEP001 :

Further examplation for program ZBW_IMEP002:

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

 Once the file is choosen, the user can start the content checking of the file by clicking on "Check file" icon.

Once the file content is checked, the user can load the file to BW application server (AL11) and raise the event PC_CO_IMEP_15 by clicking on "Load file" icon.

 The event PC_CO_IMEP_15 triggers the process chain PC_CO_IMEP_15 - "IMEP: META - T - Main (Non-SAP Plant Flat Files)".

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

 The user can exit the program by clicking on "Exit" icon.

Main Chains

Sub  Chains

Other Chains

Loading frequency

IMEP is loaded daily from D1 to D4 only.

Events on Solvay ECC (PF1) and RCS (WP1) starts BW Process Chains.

In Process Chains we also check that we are between D1 and D4 (programme ZBW_IMEP001).

Average performance

Record Keeping

3 years plus current year is asked by business.

Older data are deleted from DSOs/Cubes at the end of the process chains RCS and Solvay.

The number of years to keep can be maintained in Global Filter masterdata (Stream IMEP / Rule RCS_HISTO or SOLV_HISTO/ Counter '001'

Reporting

Queries End User Documentation

Main queries

Main functionalities

Broadcast

No broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

This chain is starting when event xxx is received from RCS WP1.