Initial variable list for which the data extracted from transparency to price optimization engine (Novecare)
Transparency team (below has been clarified with Ayoub already)
1. For Novacare, we use below aggregation logic
a. Data will be aggregated on Shipto + Material +incoterm combination to derive CPC combination
b. Further aggregate on Order number to consider adjustments
c. Take the latest order by delivery date to derive Last Invoice Price (€/KG) attribute (Ayoub to conform the exact logic to derive "Last Invoice Price (€/KG)")
2. Rest of the attributes part of Transparency Feature extract will be a 1:1 mapping to COPA03 query
3. All the attributes part of Forecast extract will be a 1:1 mapping to QV_BW_QRY_CPCOPC07_0001
Last Invoice Price (€/KG)" derivation logic, confirming if there are any currency and UOM conversion in Transparency ?
Any data quality issues worth sharing at this stage?
0 sale in the month of Mar for some CPSs but there is a last invoice price. I assume the last order is not during Mar
"Last invoice price" according to c above has been generated in transparency dashboard based on the last invoice per CPC. what is the rule for the same field in forecast?
Price optimization (Novecare):
To aggregate the sales to consider:
sales by sites where solvay is 100% shareholder ?
Should we include internal sales (Ex: Sales between Novecare to SPP)