| 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 | |
| 4 | [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price | Note: This is called SAP active price and the measure is euro per kg in transparency dashboard 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 for a forecast month per CPC (Ship-to+Material+incoterms) | = [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Amount Per CPC: combination of [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_SHIPTID] Ship-to party [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[C_MATNR2] Material [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 |
| Fcst Volume (KG) | ||
| Fcst Unit price (€/KG) | ||
| Last forecast invoice price (€/KG) |