Overall Equipment Effectiveness (OEE) 
Query: 0PP_MP16_Q004
You use this query to analyze the Overall Equipment Effectiveness (OEE) of a work center at plant, work center or period level.
Analysis on the basis of the following factors is carried out in the dashboard:
OEE per plant
OEE per work center
OEE per month for plant
OEE per month for work center
OEE per day of month
OEE per material for work center
OEE per month for material
The OEE is calculated based on the formula OEE = Availability% * Performance% * Yield% /10000. This query is based on the InfoCube 0PP_MP16 and was developed for the business package for Production Supervisor.
Structure
Object Type | Name | Technical Name |
|---|---|---|
| Work Center |
0WORKCENTER |
| Material |
0MATERIAL |
| Calendary Year/Month |
0CALMONTH |
| Calendary Day |
0CALDAY |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Plant |
0PLANT |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Availability % |
0PP_MP16_CK0007 |
— |
| Performance % |
0PP_MP16_CK0014 |
|
| Yield % |
0PP_MP16_CK0003 |
|
| Overall Equipment Effectiveness % |
0PP_MP16_CK0017 |
|
| ActualProcessingTime |
0ACTPROCTME |
|
| Actual Setup Time |
0ACTSETUPTM |
|
| ActualTeardown Time |
0ACTTEARDWN |
|
| Operating Time |
0USINGTIME |
|
| Actual Quantity |
0CONFRM_QTY |
|
| TgtExecutionTime |
Ex. 0TGTEXECTMX |
|
| Target Quantity |
0OPER_QTY |
|
| Act. Exec. Time Exact |
0ACTEXECTMX |
|
| Actual Scrap |
0CONF_SCRAP |
|
| Rework |
0REWORKQTY |