The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.
Remove the sections that are not relevant.
Description | SCM : E2E Dashboard - Planning Adherence (QV) |
|---|---|
| Technical Name | QV_BW_QRY_CPSCM01_0003 |
Application | IA_SCM - Supply Chain Management |
Info-provider | CPSCM01 |
Usage type | Qlikview source |
Expected users | N/A |
Workbook/Query General Description
This query is used to send Planning Adherence KPI data to E2E Value Chain Dashboard Qlikview application.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display | ||
| Rows/Columns | ||
| Value Display | ||
| Planning | ||
| Extended |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
CALMONT2 Calendar Month/Year (Interval, Mandatory) | 0CALMONTH | Interval/Mandatory/ManualEntry | Yes | Calendar Month/Year according the movement date |
V_C_PLANT_0010 Palnt (Selection option, Optional) | C_PLANT | SelectOption/Optional/ManualEntry | No | |
V_C_WORKCTR_0001 Work Center (Selection option, Optional) | C_WORKCTR | SelectOption/Optional/ManualEntry | No | Ressource |
V_C_MATNR2_0001 Material (Selection option, Optional) | C_MATNR2 | SelectOption/Optional/ManualEntry | No | |
VBASE_UOM__05 UoM for Qty Conversion (Single Value, Mandatory) | Yes | Unit of measure used for conversion of Actual Production and Planned Porudction |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| 0INFOPROV | APDYN01 | Key figures used to calculate the Planning Adherence KPI are only available in ADSO APDYN01 |
Key figures
Technical Name Description | Type | Restricted or calculated KF | Calculation rule | Convertion | Comments |
|---|---|---|---|---|---|
BW_RKF_CPSCM01_005 Actual Production | Always show | Restricted Key Figure |
| QCT_MATNR5 | Quantity used in calculation of Planning Adherence KPI |
BW_RKF_CPSCM01_001 Planned Production | Always show | Restricted Key Figure |
| QCT_MATNR5 | Quantity used in calculation of Planning Adherence KPI |
BW_CKF_CPSCM01_005 Planning Adherence | Always show | Calculated Key Figure |
|
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Row | C_MATPNT2__CPFCTR1_2 | BFC Gloabl Business Unit | Text |
| Row | 0LOGSYS | Source System | Do not display |
| Row | 0CALMONTH | Calendar Year / Month | Key / Text |
| Row | C_PLANT | Plant | Key / Text |
| Row | C_PLANT__0REGION | Region (State, Province, Country) | Key / Text |
| Row | C_WORKCTR | Work Center | Key / Text (Ressource) |
| Row | C_MATNR2 | Material | Key / Text (Material OEE) |
| Row | 0PO_UNIT | Qty unit | Key / Text |
| Free | C_MATPNT2__C_PFCTR1 | 1 - RCS Global Business Unit | Key / Text |
| Free | C_MATPNT2__C_PFCTR2 | 2 - RCS Business Unit | Key / Text |
| Free | C_MATPNT2__CPFCTR2_2 | BFC Group of activities | Key / Text |
| Free | C_MATPNT2__C_MAGNITU | BFC Activity 1 | Key / Text |
| Free | C_MATPNT2__0G_CWWE01 | Sub-activity | Key / Text |
Cells
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||