| Fields in the Sales Forecast Revenue QV_BW_QRY_CPCOPC07_0001 | Rules | Measure | |
|---|---|---|---|
| 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 (€) calculation [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity→ used for Fcst Volume (KG) calculation [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price → used for Fcst Unit price (€/KG) and 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) | |
| 4 | [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price | Note: This is known as SAP active price 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) | |
| 5 | [C_VALCOMP] Value Component | Used only to filter Net price (item 4) | |
| 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 It is retrieved from Forecast query. (In the query it is available per month for the period of the 18 months in advance) | = [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) |
| Last forecast invoice price (€/KG) | Last monthly price available in forecast query 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. |