Description | BW - Nov CCR Released cost estimates (QV) |
|---|---|
| Technical Name | QVNVPA_BW_QRY_CUB_PCP01_0010 |
Application | COPC - Production Costs (WBP) |
Info-provider | CUB_PCP01 |
Usage type | Qlikview Source |
Expected users | Qlikview - For the Novecare Price Advisor Dashboard |
Query General Description
This query provides the unit variable costs for each material/product for the Novecare GBU on the RCS system. It is used as a source for the qlikview dashboard "Novecare Price Advisor".
Qlikview will read the last 3 months (M, M-1, M-2) data in both EUR and USD (conversion done in the query).
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display | Irrelevant (QV) | |
| Rows/Columns | Irrelevant (QV) | |
| Value Display | Irrelevant (QV) | |
| Planning | Irrelevant (QV) | |
| Extended |  | By OLE DB for OLAP is checked as it is necessary for qV to read the data |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
0I_FPER | 0FISCPER | Interval | Yes | Used by Qlikview to select the period (M, M-1, M-2) |
Variable Sequence
Irrelevant for QV.
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Cost Component Grp 1 | = VC | We only include variable costs (Fixed and depreciation not needed for the dashboard) |
| Cost Variant | = #, Z25, ZEP, ZFO, ZPI, ZSL | Same values as in the core query. |
| Cost Comp Structure | =Z1 | Same values as in the core query. |
| Costing Status | = FR | Same values as in the core query. |
| Currency Type | = 10 | We take only company currency (then convert to EUR/USD) |
| Valuation View | = # | Same values as in the core query. |
| Material Type | = ZMAT, ZPIP | We are only interested in materials that can be sold. |
| 1 - RCS Global Business Unit | = NOVECARE (ZSECT00011) | This query only includes Novecare since it's only used for the Novecare Price Advisor Dashboard |
Key figures
Unit Cost EUR
Description
Unit variable cost in EUR. It's the Variable Amount in EUR / Lot Size.
Calculation rule detail
Update
Although the BW formula includes the fixed amount, it is not necessary as the query only includes variable costs (Filter on the Cost component grp 1)
Formula : (Fixed Amount EUR + Variable Amount EUR) / Lot Size
EUR Currency
Although the key figure says "EUR", in fact the currency is selected in the prompt. In this specific case Qlikview will run the query with "EUR" selected as it is what is needed in the dashboard.
Currency Conversion
Exchange Rate Type : CAR3
Currency : Variable
Conversion Type : CTK_CAR3FP
Time Reference : 0FISCPER
Unit Cost USD
Description
Unit variable cost in USD. It's the Variable Amount in USD / Lot Size.
Calculation rule detail
Update
Although the BW formula includes the fixed amount, it is not necessary as the query only includes variable costs (Filter on the Cost component grp 1)
Formula : (Fixed Amount EUR + Variable Amount EUR) / Lot Size
Currency Conversion
Exchange Rate Type : CAR3
Currency : USD (Fixed in query)
Conversion Type : CTK_FISCPR
Time Reference : 0FISCPER
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Rows | 0PLANT | Plant | Used by QV |
| Rows | C_MATNR | Materiel | Used by QV |
| Colums | 0FISCPER | Fiscal year / period | Used by QV |