Price optimization Novecare

Price optimization NC							Transparency dashboard related
Context	Requirements	Description	Data type	Right source	Joint/Relations with other field	Comments	Name in transparency dashboard	Source in transparency	Technical name of the field in the sources	Transformation	Comments
Customer	Incoterm
Product/Material	Material code
Customer	Ship to code	SAP code for customer to whom Solvay is shipping the products	Transactional					QVSBS_BW_QRY_CPCOPA03_0001 QV_BW_QRY_MVSDSO61_0001 QV_BW_QRY_CPCOPC07_0001	[C_SHIPID] Ship_to_party		Customer: ship to, sold to, ship to KA
Customer	Ship-to name
Customer	Sold to code		Transactional								Customer: ship to, sold to, ship to KA
Customer	Sold-to name
Customer	Sold-to group			BW or SF
Organization	Group of Activity
Customer	Country ship to	Country of the customer delivered						QVSBS_BW_QRY_CPCOPA03_0001 QV_BW_QRY_MVSDSO61_0001 QV_BW_QRY_CPCOPC07_0001	[4CPCOPA03-SHIP_COUNTRY] Country of destination [10COUNTRY] Ship-to party > Country (Name) C_SHTCTRY
Customer	Country (Sold-To)	Country of the sold-to company- Invoice party						QV_BW_QRY_MVSDSO61_0001	"[0COUNTRY] Country if empty => [C_SHIPTID] Ship-to party\Attributes\[0COUNTRY] Country key"
Organization	GBU region	Customize field to reflect the pricing organisation of the GBUs SpP : ECCO region Novecare/TS : Region of Ship to with MX moved to LATAM Aroma = Region H1 Example: For SpP, the GBU region is China but for NC, it is Asia						Made in transparency dashboard		There are correction from BW → based on application requirements there are some rules	There are 4 regions predefined by Solvay and each GBU could have new/customized regions for spp there is a table in Icare to get the regions ) for others rules are hard coded
Organization	End use	refers to a market to be used (It is related to ship-to and product.		BW or SF(To check)							it comes from invoice query from BW. Better from SF . it is related to the custumer via an extra table
Product/material	GBU product family
Market	Enterprise segment	It is related to customer and product together. From BW transaction level.	Master			for price optimization not enterprise segment is not very important but GBU segment (below) is very important
Market	GBU segment	Refer to the market like automotive				For the moment only GBU segment of NC is important
Market	Market
Customer	Group customer segment	It refers to Solvay group level of segmentation for customer. Depends on the service level a customer receives from Solvay, it can be classified as KA, or standard, etc. The same customer segmentation can be applied at GBU level (below)	Master					QV_BW_QRY_MVSDSO61_0001 QV_BW_QRY_CPCOPC07_0001	Bus_Rank__Corp_
Customer	GBU customer segment	A customer receiving different service levels could be classified as KA for one GBU and Standard for other. Exceptions: GSKA- they remain GSKA for all GBUs.	Master	BW or SF(To check)		Use the query used in bw for 360 and focus in novecare. using costumer id to link. Guillaume VIAUX comment below in 360 dashboard BW COPA Query (sales) Corporate Segment = Sold_to_party -> Bus_Rank__Corp___Name_ Group Segment = Customer_Sales_Area -> Customer_group_2__Name_ -------------- To Check: -It refers to the master data related to customer area in SF (might be an attribute of the sold to) -joining from BW to SF but there might be a gap. -in sap there is segmentation at sales level How to link/ combine the Customer Solvay group and GBU segmentation (roberto navan , lavinia ) -there are two sfs how to merge for segmentation purpose Consider to use customer ID as the bridge for finding the customer segmentation at group and gbu level → from bw to sf		QV_BW_QRY_CPCOPC07_0001
Product/Material	Product name
Product/Material	Product code
Product/Material	Product brand name
	Sale Unite price
	Volumes
	Last invoice price							Made in transparency dashboard
	Shipping plant
	Manufacturing plant
	Forecast sale
	Forecast unit price
	Forecast volume

Space shortcuts

Page tree