| 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). 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) |