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 | IMEP - Manufacturing Local Report (Core Query) |
|---|---|
| Technical Name | BW_QRY_MVCOPP01_0002 |
Application | IMEP - Manufacturing |
Info-provider | MVCOPP01 |
Usage type | Direct execution in Analyzer / Broadcast / Qlikview Source / ... |
Expected users | Ex: GBU zone and WW controllers |
Workbook/Query General Description
Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.
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 |
|---|---|---|---|---|
FISCP003 | 0FISCPER | SelectionOption/Mandatory/ManualEntry | Yes | Explanation for the use of this variable |
| C_COMPCDE_04 | C_COMPCDE | SelectionOption/Optional/Authorization | No | |
| V_AUT_C_PLANT_0001 | C_PLANT | SelectionOption/Optional/Authorization | No | |
| V_C_MAT_TYP_0001 | C_MAT_TYPE | SelectionOption/Optional/ManualEntry | No | |
| SOO_C_MATNR2_0001 | C_MATNR2 | SelectionOption/Optional/ManualEntry | No | |
| ZV_0PROFIT_CTR | 0PROFIT_CTR | SelectionOption/Optional/ManualEntry | No | |
| DISPO_01 | C_DISPO | SelectionOption/Optional/ManualEntry | No | |
| C_COSTC | C_COSTCTR | SelectionOption/Optional/ManualEntry | No | |
| V_C_COORDER_0001 | C_COORDER | SelectionOption/Optional/ManualEntry | No | |
| C_COMPCDE__C_PZONE_0001 | C_COMPCDE__C_PZONE | SelectionOption/Optional/ManualEntry | No | |
| V_CORDTYP_0001 | C_CORDTYP | SelectionOption/Optional/ManualEntry | No | |
| V_0ACTTYPE_0001 | 0ACTTYPE | SelectionOption/Optional/ManualEntry | No | |
| V_C_ORIGIN_0001 | C_ORIGIN | SelectionOption/Optional/ManualEntry | No | |
| V_0COSTELMNT_0001 | 0COSTELMNT | SelectionOption/Optional/ManualEntry | No | |
| V_C_FEVOR_0001 | C_FEVOR | SelectionOption/Optional/ManualEntry | No | |
| V_C_ZZRCSIT_0001 | C_ZZRCSIT | SelectionOption/Optional/ManualEntry | No | |
| V_C_KSTRG2_0001 | C_KSTRG2 | SelectionOption/Optional/ManualEntry | No | |
| V_CPFCTR1_2_0008 | CPFCTR1_2 | SelectionOption/Optional/Authorization | No | |
| V_C_EXACBMO_0001 | C_EXACBMO | SingleValue/Optional/Authorization | No |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Fiscal Year Variant (0FISCVARNT) | Calendar year, 4 spec. periods (K4) |
Add screenshot if relevant
Key figures
| Description | Type | Restricted or Calculated KeyFigure | Calculation Rule | Conversion | Comments |
|---|---|---|---|---|---|
Key Figure 1
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Text Replacement Variable
If relevant, add the text replacement rule used for the key figure
Currency Conversion
Exchange Rate Type : Ex ZRH0
Currency : Variable, or fixed currency used
Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Free/Row/Column | 0COUNTRY | Country | Country of the customer |
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 | |