You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Forecast price calculation flow 

https://app.diagrams.net/#G1GuqjSLqoK1zjw2jr4DRt07uxWzGFZEK6


List of BW query field used for the calculation


Fields in the Sales Forecast Revenue QV_BW_QRY_CPCOPC07_0001Rules
1[C_SOURCE] Loading Source

Values include DYNASYS and ORDERBOOK 

Exclude loading source= ORDERBOOK from the query 

2[C_RUNPER] Run Period (calmonthExtract only the last running period 
3

Measures:

[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity→ used for Fcst Volume (KG)  

[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price → used for Fcst Sales (€)  and  Last forecate price (€/KG) calculation (it is only used for the calculation of the sale) 

[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Unconstraint Quantity

These BW measures are used for:

  • cleaning purposes→ the rule is to extract only records  with values on at least one of them
  • to calculate new measures in transparency 


4[C_VALCOMP] Value ComponentUsed only to filter Net price 
5 

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)

For Novecare CPC is the combination of ship-to, material, and incoterm.

Note: For other GBUs like SpP the definition of CPC is different


6

[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\[CPCOPC02P] Further Characteristics\[0CALMONTH] Forecast Month




Measures in the transparency dashboard  

Measures in transparency  Definition Source Related fields in the BW query 
Fcst Sales (€)

The amount of the sale forecast. It is calculated in the transparency dashboard monthly basis for 12 months ahead. 

Note: there is a  measure in BW (Snapshot\Measures\Amount) but it has NOT been used in the transparency dashboard 

QV_BW_QRY_CPCOPC07_0001



Fcst Volume (KG)

The quantity of the sale forecast. It is directly retrieved from the Quantity measure in the Forecast query.

Note: The lowest granularity required for CS price optimization for calculation is at CPC level.   

QV_BW_QRY_CPCOPC07_0001[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Quantity
Fcst price (€/KG)

The unit price of the sale forecast. It is based on the Net price measure in the forecast query.  

Note: Net price in the query known as SAP active price applying the filter below. The unit 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 4)

QV_BW_QRY_CPCOPC07_0001

[QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price


Last forecast price (€/KG)

It is the latest forecast price 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. 


= [QV_BW_QRY_CPCOPC07_0001] FL-Sales Revenues Forecast Snapshot\Measures\Net price

Note: Net price in the query known as SAP active price applying the filter below. The unit 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 4)





  • No labels