Description | BW - QM - Inspection Results by Lot (Core Query) |
|---|---|
| Technical Name | BW_QRY_MVQM01_0002 Migrate to BW_QRY_CPQM02_0011 |
Application | QM |
Info-provider | MVQM01 |
Usage type | Direct Execution |
Expected users | Ex: GBU zone and WW controllers |
Workbook/Query General Description
This query is a simple view of QM Inspection Results general and quantitative data.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display |  | |
| Rows/Columns |  | |
| Value Display |  | |
| Planning |  | |
| Extended |  |
Variables
Definitions
Variable Description | Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|---|
| Task list type | V_0PLAN_TYPE_0001 | 0PLAN_TYPE | Selection Option | No | |
| Material (Interval, Optional) | V_C_MATNR2_0002 | C_MATNR2 | Interval | No | |
Equipment | V_C_EQUIPMT_0001 | C_EQUIPMT | Selection Option | No | |
| Group Counter | V_C_PLNAL2_0001 | C_PLNAL2 | Selection Option | No | |
| Task list group (Select. option, Optional) | V_0PLNNR_0001 | 0PLNNR | Selection Option | No | |
| Inspection Date | V_0CALDAY_0007 | 0CALDAY | Interval | No | |
| Inspection Lot (Single value, Optional) | V_0INSP_LOT_0002 | 0INSP_LOT | Single value | No | |
| Plant (Authorization with input select option) | V_C_PLANT_0012 | C_PLANT | Authorization with input select option | Yes |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| C_DETAILE | = # | |
| C_LREC | = X |
Add screenshot if relevant
Key figures
| Description | Object | Calculation rule detail | Text Replacement variable | Display | Currency Conversion | Unit Conversion |
|---|---|---|---|---|---|---|
| No. of values | 0NO_OF_VALS | Standard Key Figure | N/A | Default | N/A | N/A |
| Samples O.K. | 0SAMPS_OK | Standard Key Figure | N/A | Default | N/A | N/A |
| Rejected samples | 0SAMPS_BAD | Standard Key Figure | N/A | Default | N/A | N/A |
| Sum single vals | 0SUM_OF_X | Standard Key Figure | N/A | Number of Decimal Places: 0.0000 | N/A | N/A |
| Lower tol. limit | 0LWR_LIMIT | Standard Key Figure | N/A | Number of Decimal Places: 0.0000 | N/A | N/A |
| Upper tol. limit | 0UPPR_LIMIT | Standard Key Figure | N/A | Number of Decimal Places: 0.0000 | N/A | N/A |
Characteristics
| Location | Position | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|---|
| Row | 1 | 0PLNNR | Task list group | |
| Free | C_MATNR2 | Material | ||
| Row | 2 | C_PLANNOD | Node Operation | |
| Free | C_EQUIPMT | Equipment | ||
| Row | 3 | C_CHARTXT | Insp. Charact. Text | |
| Free | 0PMTVERSION | Insp. Meth. Version | ||
| Row | 6 | 0BATCH | Batch | |
| Row | 4 | 0CALDAY | Calendar Day | |
| Row | 5 | 0INSP_LOT | Inspection Lot | |
| Free | 0PPLANT | Plant of Insp. Meth. | ||
| Free | C_PMETH2 | Inspection Method | ||
| Free | C_INSP_CH | Insp. Charact. Numb | ||
| Free | C_DETAILE | Number of the Ind. | ||
| Free | C_LREC | Last Record | ||
| Free | C_PLNAL2 | Group counter | ||
| Row | 9 | C_RESULT | Result | |
| Row | 8 | 0ICHAR_UOM | Unit of measurement | |
| Free | 0LOGSYS | Source System | ||
| Row | 7 | 0INSP_LOT__C_BATCH2 | Batch | |
| Free | 0INSP_LOT__C_MATNR2 | Material | ||
| Free | 0INFOPROV | InfoProvider |
Cells
If you have 2 structures and special cells calculations, explain here.
Conditions
If you have conditions, explain here.
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
| Ex : Excl if <=10 | Yes/No | Sales Value | Greater Than | 10 | Ex : All Independently |
Exceptions
If you have conditions, explain here.
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ex : Red if <=10 | Yes/No | Bad 3 | Lesser Than | 10 | |