| 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\Amount→ used for Fcst Sales (€) and Fcst Unit price (€/KG) Last forecast invoice price (€/KG) calculation [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity→ used for Fcst Volume (KG) and Fcst Unit price (€/KG) calculation [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price → used for Last forecast invoice price (€/KG) calculation [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Unconstrained Amount | The first three are used to calculate measures in the transparency (see table below) The last three is used for cleaning purposes→ the rule is to extract only records with values on at least one of them Note: Net price in the query known as SAP active price applying the filter below and the measure 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 5) | Fcst Sales (€) Last forecast invoice price (€/KG) |
| 5 | [C_VALCOMP] Value Component | Used only to filter Net price (see above) | Last forecast invoice price (€/KG) |
| 6 | 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 | For Novecare is the combination of ship-to, material, and incoterm Ask which field of incoterms is for Novecare? | |
| 7 | [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[0CALMONTH] Forecast Month | Ask which field for Novecare?
|
| Measures in transparency | Definition | Calculations |
|---|---|---|
| Fcst Sales (€) | This is the forecast sale per CPC (Ship-to+Material+incoterms). It is directly retrieved from the Forecast query. | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Amount |
| Fcst Volume (KG) | This is the forecast sale quantity per CPC (Ship-to+Material+incoterms). It is directly retrieved from Forecast query | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity |
| Fcst Unit price (€/KG) | This is the forecast unit price per CPC (Ship-to+Material+incoterms). Calculated in the transparency dashboard by dividing the Amount by QTY retrieved from forecast query | |
| Last forecast invoice price (€/KG) | Last monthly price available in forecast query for a CPC. Either it is retrieved directly from the query (The query offers net price per month for the period of the 18 months in advance). 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 Relevant Net price: 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 5) |