| 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: 4) 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 | |||
| Fcst Volume (KG) | This is the forecast sale quantity. It is directly retrieved from Forecast query. | [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity | |||
| Fcst Sales (€) | This is the forecast sale. It is calculated in the transparency dashboard. Fcst Sales (€) =Fcst Volume (KG)* Fcst price (€/KG) Important Note: there is a measure in BW (Snapshot\Measures\Amount) but it has NOT been used in the transparency dashboard | ||||
| Fcst price (€/KG) | This is the unit price forecast which calculated in transparency dashboard | ''\Measures\Net price'' is a forecast unit price reported in the forecast query monthly basis for 18 months ahead this measures is used to calculated the Fcst price.
| Link to the logic https://app.diagrams.net/#G1GuqjSLqoK1zjw2jr4DRt07uxWzGFZEK6 | ||
| CPC | For Novecare CPC is the combination of ship-to, material, and incoterm. | Note: For other GBUs like SpP the definition of CPC is different | 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) | ||
Ship-To | [C_SHIPTID] Ship-to party | ||||
Sold-To | [C_SOLDID] Sold-to party | ||||
Ship-To KA | |||||
Manufacturing Plant | [C_MANPLNT] Manufacturing Plant | ||||
Shipping Plant | |||||
Incoterms | [CPCOPC02P] Further Characteristics\[C_INCDYNS] Incoterm Dyn. Solvay [CPCOPC02P] Further Characteristics\[C_INCDYNR] Incoterm Dyn. Rhodia One for WP1, and PF1 (when one is empty to take the other one) | ||||
Product | [C_MATNR2] Material (key & name) | ||||
| Unit of measure | [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[0UNIT] Unit of measure |