The composition of every raw material, semi finished and finished good has to be described in Composition Database. This is a pre-requisite in order to assess its regulatory compliance.
Raw materials may have a lower ratio comparing with the BU/Enterprises because it’s often difficult to get the whole composition from the suppliers.
The KPI should measure:
B - Percentage of products without a composition in Compo Database.
A2 - Number of products which have a composition exclusively made of the 'Unknown' or 'Undefined' components.
"Undefined" corresponds to specification code "100000000000" and "Unknown" to "100000000001".
B - See A1 divided by the total number of products
Selections:
Remove from KPI data:
• Products which have a NAM PROD (language EN) with OBS are not taken into account.
• Authorizations group ALL.
Process chain is started monthly every 1st day.
For a product, the sum of its components should be equal to 100 %.
Raw materials may have a lower ratio comparing with the BU/Enterprises because it’s often difficult to get the whole composition from the suppliers.
The KPI should measure:
Remarks:
|
B - See A divided by the total number of products.
Selections :
Remove from KPI data:
Process Chain is started monthly every 1st day.
Extract from meeting minutes - 2009, 22 of september
> W8.2.2 : Number of products without DG Master data
> - Split by BU - Material being linked to commercial product
> - Only active materials (criterion ?)
Get active materials (without deletion flag) with ‘DG indicator profile’ = ‘GPP’. Then get the related PROD_COM and BU.
MM03 – Material Master Date, Basic Data 2 view:
For each of the materials, verify that a Dangerous Goods Master Data exists for IMDG regulation, and that this master data is released and active at time of extraction (control on validity period to be done).
DGP3 – Dangerous Goods Master
Technically
(Use Product Axis to get Material data (MM) and commercial product data (EH&S)
/footnote and BU also : access to ESTRH with SUBID = PRCO number to get AUTHGRP (Authorisation – meaning : BU)Access to DGTMD should be done considering :
o Material (MATNR) :come from material master data previously accessed
o Deletion Flag (DELFLG) : should be blank
o Valid-From Date (VALFR) : should be inferor to current date
o Valid-To Date(VALTO) : should be superior to current data
o Dangerous Goods Regulation (LWDG) : (according case – IMDG or others)
o Processing Status for Basic Data and Master Data (DGWOS) = ‘10’ (Released)
The extractor is based on Standard Extractor called 0EHS_SPEC_MAT, with no enhancement n SAP ECC (RCS).
The DSO EHS01 is used to store all data loaded from RCS as snapshot, so monthly all data available in RCS is loaded in order to keep the history in BW.
The transformation is used to convert all Fields into InfoObject and the only one business rule used is to get the current day and set it as “Last Change On”.
The main business rules in this transformation are to consolidate all necessary data from Master Data and convert all data to the necessary formats.
In the start routine the code is getting below data in order to be used in the routines conversion:
In the conversion routines:
The main business rule in this transformation is to clean the Specification not assigned, so in the start routine the data is checked if there is no Specification and, if there is any other records with the same condition if yes, a new record is added with the option Delete assigned (Record Mode = “D”).
The DSO EHS02 is used to store the aggregated data with respective flags and metrics to be used in the reports.
The transformation is used to aggregate the detailed data to the necessary level and delete unnecessary data from the report.
In the Start Routine the data deleted are:
In the routines:
As the data is aggregated in DSO_EHS2, the transformation is used to set all missing flags.
In the Start Routine the DSO_EHS1 data is get to be used in the routines.
In the routines:
In order to freeze the data related to KPI a DSO was created and snapshots from these data are stored.
The business in this transformation can be divided in groups:
In order to frozen the data related to KPI, a DSO was created and Snapshots from these data is stored.
The business in this transformation can be divided in groups:
The MultiProvider MPR_EHS01 was created to be used for all reports and to prepare the application to use extra InfoCubes or any other InfoProviders
error
To be done : original document in Eroom has information about the PP Objects not EHS
/error
Only one source system is used in this application : RCS Production WP1_400
The global filter is used to filter out all unnecessary data, the load process check in this Master Data what is the Reference Date to clean the data. This process is to avoid unnecessary data in the Objects improving the load and report performance.
If there are errors in the process chain no special actions should be done. The procedures to crrect are the standard ones.
The security will be through BEx (Business Explorer Role). All users should have access to this role : ZR_RCS_KPI_A01
All queries can be found in the menu role ZR_RCS_KPI_A01.
*InfoCube Design
SAP recommends tha all dimensions not line item for performences purposes should be represent less than 20% of the fact table. In TCODE SE38, the ABAP report : SAP_INFOCUBE_DESIGNS show the design.
