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

Compare with Current View Page History

« Previous Version 47 Next »

 


Fields in the Sales Forecast Revenue QV_BW_QRY_CPCOPC07_0001Rules Measure 
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\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 ComponentUsed 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 based on the Sales Forecast Revenue QV_BW_QRY_CPCOPC07_0001  Definition Calculations 
Fcst Sales (€)

Fcst Volume (KG)

Fcst Unit price (€/KG)

Last forecast invoice price (€/KG)





  • No labels