| Requirements | Descriptions | Comments | Source | Fields in the BW (Sales Forecast Revenue QV_BW_QRY_CPCOPC07_0001) | Transformation |
|---|---|---|---|---|---|
| Loading source | In sales forecast query there are two loading sources where the forecast transactional data are populated including DYNASYS and ORDERBOOK | In the context of price forecast in the transparency dashboard the ORDERBOOK as the source is irrelevant | QV_BW_QRY_CPCOPC07_0001 | [C_SOURCE] Loading Source | Values include DYNASYS and ORDERBOOK Exclude loading source= ORDERBOOK from the query |
| Running period | QV_BW_QRY_CPCOPC07_0001 | [C_RUNPER] Run Period (calmonth | Extract only the last running period | ||
| Value Component | QV_BW_QRY_CPCOPC07_0001 | [C_VALCOMP] Value Component | Used only to filter Net price | ||
| SAP active price | Note: Net price in the query known as SAP active price for which the value component field in the query (column above) is equal to 2 . The unit is euro (other currency?) per kg | This field is only relevant for calculating forecast price: Forecast price calculation FLOW | QV_BW_QRY_CPCOPC07_0001 | \Measures\Net price [C_VALCOMP] Value Component | \Measures\Net price filtered on [C_VALCOMP] Value Component=2 For TS, if there is no record of value component=2, the filter is on value component key=15 |
| Forecast month | QV_BW_QRY_CPCOPC07_0001 | [CPCOPC02P] Further Characteristics\[0CALMONTH] Forecast Month | |||
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) | ||||
| Used only to filter Net price (see above) | |||||
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 | ||||
[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) |