Description | BW-QM Statistics (Core Query) |
|---|---|
| Technical Name | BW_QRY_CPQM02_0002 |
Application | QM |
Info-provider | CPQM02 |
Usage type | Direct Execution |
Expected users |
Workbook/Query General Description
This query is a simple view of QM statistics 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 |
|---|---|---|---|---|---|
| Auth Scope on Plant (Auth with input) | V_C_PLANT_C_AUTHMA_002 | C_PLANT__C_AUTHMA | Authorization with input select option | No | |
Operation (Single Value, Optional) | Z_OPE | C_LTXA1 | Selection Option | No | |
| Task list group (Select. option, Optional) | ZPLNNR | 0PLNNR | Selection Option | No | |
| Date Usage Decision (Selection Option, Optional) | VDATU_01 | C_VDATUM | Selection Option | No | |
| End date of insp (Select Option, Optional) | PRUDT_01X | C_PRUDT | Selection Option | No | |
| Insp Start Date QM Lot (Select Option, Optional) | LSPAS_01 | C_LSPASTD | Selection Option | No | |
| Insp Start Dat- Glob (Select Option, Optional) | PRUDV_01 | C_PRUDV | Selection Option | No | |
| Insp. Char Text (Select Option, Optional) | CHART_01 | C_CHARTXT | Selection Option | No | |
| Date of lot creation (Select Option, Optional) | ENSTE_01 | C_ENSTEHD | Selection Option | No | |
| Inspection Lot (Select option, Optional) | ZINSPLOT | 0INSP_LOT | Selection Option | No | |
| Date of Manufacture (Selection Option, Optional) | HSDAT_01 | C_HSDAT | Selection Option | No | |
| WP1 Material Number | V_C_MATNR2_0010 | C_MATNR2 | Selection Option | No | |
| Plant(s) | V_C_PLANT_37 | C_PLANT | Selection option | Yes | |
| Key Date (Interval / Optional) | ZKEYDATE_001 | 0INSP_LOT__C_KEYDATE | Interval | No |
Variable Sequence
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| NA | NA | NA |
Key figures
Description | Object | Calculation rule detail | Text Replacement variable | Display | Currency Conversion | Unit Conversion |
|---|---|---|---|---|---|---|
| Quantitative Result | K_MITTEL | Standard Key Figure | N/A | Default | 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 |
| Total samples | 0SAMPS_TOTL | 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 |
| Nonconforming | 0NONCONFMNG | Standard Key Figure | N/A | Default | N/A | N/A |
| Proportion Faulty | 0FRAC_NONCF | Standard Key Figure | N/A | Default | N/A | N/A |
| Number Above | 0NO_TOO_HGH | Standard Key Figure | N/A | Default | N/A | N/A |
| Number Below | 0NO_TOO_LOW | Standard Key Figure | N/A | Default | N/A | N/A |
| Lwr tol. lvl exists | 0IND_LWRLMT | Standard Key Figure | N/A | Default | N/A | N/A |
| Upper tolerance level exists | 0IND_UPPLMT | Standard Key Figure | N/A | Default | N/A | N/A |
| ClassChar LowerLimit | K_LWRLIM | Standard Key Figure | N/A | Default | N/A | N/A |
| ClassChar UpperLimit | K_UPPRLIM | Standard Key Figure | N/A | Default | N/A | N/A |
| Sum single vals | 0SUM_OF_X | Standard Key Figure | N/A | Default | N/A | N/A |
| No. of values | 0NO_OF_VALS | Standard Key Figure | N/A | Default | N/A | N/A |
Restricted/Calculation/Formula Key figures
Description | Object | Restricted/Calculated/Formula | Calculation rule detail | Display | Currency/Unit Conversion | Comments |
|---|---|---|---|---|---|---|
| Nonconfirming Lot | 0NONCONFMNG | Formula | 0NONCONFMNG | Default | N/A | N/A |
| Mean Value | BW_CKF_CPQM02_017 | Calculated |
| Default | N/A | N/A |
| Standard Deviation | BW_CKF_CPQM02_002 | Calculated |
| Default | N/A | N/A |
| Ppk below | BW_CKF_CPQM02_003 | Calculated |
| Default | N/A | N/A |
| Ppk on Top | BW_CKF_CPQM02_004 | Calculated |
| Default | N/A | N/A |
| Ppk | BW_CKF_CPQM02_005 | Calculated |
| Default | N/A | N/A |
| Pp | BW_CKF_CPQM02_006 | Calculated |
| Default | N/A | N/A |
| Ppk OK | Formula | "[BW_CKF_CPQM02_005] Ppk" > 1.33 | Default | N/A | N/A | |
| Maximum Result | BW_QRY_CPQM02_020 | Calculated |
| Default | N/A | N/A |
| Minimum Result | BW_CKF_CPQM02_019 | Calculated |
| Default | N/A | N/A |
| Out of Spec (mean values/Sum include) | RCS_CPQM02_CDB_OOS | Calculated |
| Default | N/A | N/A |
| Ppk Below Class Char | BW_CKF_CPQM02_007 | Calculated |
| Default | N/A | N/A |
| Ppk on Top Class .Char | BW_CKF_CPQM02_008 | Calculated |
| Default | N/A | N/A |
| Ppk Class.Char | BW_CKF_CPQM02_009 | Calculated |
| Default | N/A | N/A |
| Proportion Faulty | BW_CKF_CPQM02_021 | Calculated |
| Default | N/A | N/A |
| Pp Class.Char | BW_CKF_CPQM02_022 | Calculated |
| Default | N/A | N/A |
Characteristics
Location | Position | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|---|
| Free | C_PLANT | Plant | ||
| Free | 1 | C_MATNR2 | Material | |
| Free | 0LOT_HERK | Inspect.Lot Origin | ||
| Free | 2 | C_BATCH2 | Batch | |
| Free | 3 | C_HSDAT | Date of Manufacture | |
| Free | C_VERID | Production Version | ||
| Row | 5 | 0INSP_LOT | Inspection Lot | |
| Free | 6 | C_ENSTEHD | Date of Lot Creation | |
| Row | 7 | C_LTXA1 | Operation short text | |
| Free | C_WORKCTR | Work Center | ||
| Row | 9 | C_CHARTXT | Insp. char text | |
| Free | C_SATZS | Res.Status | ||
| Free | 10 | C_DETAILE | Number of the Ind. | |
| Row | 11 | 0TOLERANCE | Tolerance value | |
| Free | 12 | C_RESULT | Result | |
| Free | C_MRPRMKT | Short Text(QAMR) | ||
| Free | 0MCHAR_PLNT | Plant of Charact. | ||
| Free | 0MASTERCHAR | Master Insp. Charac. | ||
| Free | C_ATTRI | Attribute Res.(Glob) | ||
| Free | C_PRUDV | Insp. Start Date | ||
| Free | C_LSPASTD | Insp StartDate QMLot | ||
| Free | C_PRUDT | End Date of the Insp | ||
| Free | C_VDATUM | Date of Code Used fo | ||
| Free | C_KOTEXT | TaskList description | ||
| Free | 0PLNNR | Task list group | ||
| Free | 0INSP_LOT__C_KEYDATE | Key Date | ||
| Row | 0ICHAR_UOM | Unit of measurement | ||
| Free | C_MBETG | Insp.Result Val-Glob |
Cells
Conditions
Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignment |
|---|---|---|---|---|---|
Exceptions
Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ppk ok | Yes | Good 1 | Between | 133.000 - 0 | |