| Info |
|---|
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 | ENERGY-Interface Consumption Qty report (Core Query) |
|---|---|
| Technical Name | BW_QRY_MVCOPP01_0004 |
Application | IMEP - Energy Interface |
Info-provider | MVCOPP01 |
Usage type | Direct execution via Analysis |
Expected users |
| Table of Contents | ||
|---|---|---|
|
Workbook/Query General Description
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 |
|---|---|---|---|---|
FISCP001 | 0FISCPER | Interval/Mandatory/ManualEntry | Yes | |
| V_CPFCTR1_2_0008 | CPFCTR1_2 | SelectionOption/Optional/Authorization/ManualEntry | No | |
| C_COMPCDE_04 | C_COMPCDE | SelectionOption/Authorization/ManualEntry | No | |
| V_AUT_C_PLANT_0001 | C_PLANT | SelectionOption/Optional/ManualEntry | No | |
| V_C_ZZRCSIT_0001 | C_ZZRCSIT | SelectionOption/Optional/ManualEntry | No | |
| V_C_EXACBMO_0001 | C_EXACBMO | SingleValue/Optional/ManualEntry | No | |
| V_C_KSTRG3_0001 | C_KSTRG3 | SelectionOption/Optional/ManualEntry | No |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider (0INFOPROV) | IMEP - Activities (Rhodia) (CRCOPP05) IMEP - Activities (Solvay) (CRCOPP04) | |
| Fiscal Year Variant (0FISCVARNT) | Calendar year, 4 spec. periods (K4) |
Key figures
| Description | Type | Restricted or Calculated KeyFigure | Calculation Rule | Conversion | Comments |
|---|---|---|---|---|---|
Consumed Quantity (LOCAL) BW_CKF_MVCOPP01_0001 | Display | Calculated |
| ||
Consumed Quantity (STD) BW_CKF_MVCOPP01_0002 | Display | Calculated |
|
Key Figure 1
Description
Calculation rule detail
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Row | C_PLANT | Plant | Key + Text Results rows : Always Suppress |
| Row | C_MATPNT2__C_LIP0GR | LIP00 product group | Key + Text Results rows : Always Suppress |
| Row | C_COSTCTR | Cost Center | Key + Text Results rows : Display if more than One Value |
| Row | C_KSTRG3 | Cost Price Code | Key + Text Results rows : Always Suppress |
| Row | C_EDITI | Code Edition | Key + Text Results rows : Always Suppress |
| Row | 0COSTELMNT | Cost Element | Key + Text Results rows : Always Suppress |
| Row | U_UNITUM | Unit (LOCAL) | Key Results rows : Always Suppress |
| Row | U_STDUNIT | Unit (STD) | Key Results rows : Always Suppress |
| Free | C_ZZRCSIT | Site | Results rows : Always Suppress |
| Free | C_INDEX1 | Index 1 | Results rows : Always Suppress |
| Free | C_ETABL | Etablissement | Results rows : Always Suppress |
| Free | C_ORIGIN | Origin | Results rows : Always Suppress |
| Free | C_EXACBMO | Excl.Actv/Blc.Mvts? | Results rows : Always Suppress |
| Free | C_MATNR2 | Material | Results rows : Always Suppress |
| Free | 0FISCPER | Fiscal Year/Period | Results rows : Always Suppress |
| Free | C_DCINDIC | Debit/Credit Indicator | Results rows : Always Suppress |
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 | |||||