| Fields in the Sales Forecast Revenue QV_BW_QRY_CPCOPC07_0001 | Rules | Corresponding measures | |
|---|---|---|---|
| 1 | [C_SOURCE] Loading Source | Values include DYNASYS and ORDERBOOK Exclude loading source= ORDERBOOK from the query | |
| 2 | [C_RUNPER] Run Period (calmonth | Extract only the last running period | |
| 3 | Measures: [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity→ used for Fcst Volume (KG) [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price → used for Last forecate price (€/KG) calculation (it is only used for the calculation of the sale) [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Unconstraint Quantity | These BW measures are used for:
Note: Net price in the query known as SAP active price applying the filter below. The unit is euro (other currency?) per kg For GBU= TS, only net price for which the value component key=15 For any other GBU Including Novecare, only net prices for which the value component key=2 (see item 4) | Fcst Sales (€) Last forecast invoice price (€/KG) Fcst Volume (KG) |
| 4 | [C_VALCOMP] Value Component | Used only to filter Net price (see above) | Last forecast invoice price (€/KG) |
| 5 | CPC (Ship-to+Material+incoterms) Ship-to [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_SHIPTID] Ship-to party Material [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_MATNR2] Material Incoterms [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_INCDYNS] Incoterm Dyn. Solvay [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_INCDYNR] Incoterm Dyn. Rhodia One for WP1, and PF1 (when one is empty to take the other one) | For Novecare CPC is the combination of ship-to, material, and incoterm. Note: For other GBUs like SpP the definition of CPC is different | |
| 6 | [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[0CALMONTH] Forecast Month |
| Measures in transparency | Definition | Calculations |
|---|---|---|
| Fcst Sales (€) | This is the forecast sale. It is calculated in the transparency dashboard. Note: there is a measure in BW (Snapshot\Measures\Amount) but it has NOT been used in the transparency dashboard | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity * [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price |
| Fcst Volume (KG) | This is the forecast sale quantity. It is directly retrieved from Forecast query. Note: The lowest granularity required for CS price optimization for calculation is at CPC | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity |
| Fcst Unit price (€/KG) | This is retrieved directly from BW. It is available in the query monthly basis for 18 months ahead. | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price |
| Last forecast price (€/KG) | It is the latest forecast price for a CPC. Either it is retrieved directly from the query. If it is not available in the forecast query, it is being calculated in transparency. For the months which is not available. It is simply a projection of the last available one in the query. | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price Note: Net price in the query known as SAP active price applying the filter below. The unit is euro (other currency?) per kg For GBU= TS, only net price for which the value component key=15 For any other GBU Including Novecare, only net prices for which the value component key=2 (see item 4) |