BW_QRY_MVGSVQM_0003
This query allows you to :
Analyze the supplier non-conformances activity : number of non-conformances registered, open and closed notifications, treatment time, demerit rate…
Take into account all QM* registration related to suppliers from both Rhodia and Solvay legacies according to SAP Quality Management module deployment (QM)
Adapt the query to your scope: Analysis by GBU, plant, gravity level, domain…
Table of content
A1710 - Prompt
- The selection of the period of Non-Conformance analysis is mandatory.
- You can select several values such as the domain, segment or material group but also the coordinator or the author of the notifications.
- An analysis by gravity level is also available
- Total Notifications items
Number of notifications created
- Closed Notifications items :
Number of notifications closed (with a completion date)
- % of closed notifications :
Number of closed notifications divided by the total number of notifications
- Notifications open after 2 months :
Number of notifications still open after 2 months.
This indicator is based on the creation date of the notification ("Date created record") and the notification status (must be different from the "notification completed“)
- % of Notifications open after 2 months:
Number of Notifications still open after 2 months divided by the total number of notifications
- Treatment time (in days) :
Number of days of treament for each notification.
Calculation done once the notification closed
- Financial Impact :
Amount recorded in the non-conformance.
« -1 » means «financial impact to be confirmed later »
- Demerit :
The demerit is based on the following gravity levels:
G1=1; G2=10; G3=50; g4=100
- Average Demerit
Total Demerit level divided by the total number of notifications
