Data objects used in Pricing Data Mart

Term	Description	Data lake Table/Attributes	Data source system/ table	Transformation			Deployment Status
Term	Description	Data lake Table/Attributes	Data source system/ table	Transparency	Price optimization Novecare	Price optimization SpP	Deployment Status
Customer	Customer	V_DIM_customer	SAP BW/ MC_CUSTID SAP BW/TC_CUSTID SF CORE/ACCOUNT				Deployed
Customer group	Identifies a particular group of customers (for example, wholesale or retail) for the purpose of pricing or generating statistics.	V_DIM_customer_corporate_group V_DIM_customer
Ship to	Refers to the customer that the material sold are shipped to. It is not necessarily the customer that buy the material.
Sold to	Refers to the customer that the material/product are sold to. This is the customer who is going to be invoiced.
Ship to KA	This concept addresses the final customer receiving the material sold. It is important to note that it is different from the ship to concept mentioned above.
Final consignee	Ship to KA mentioned above and Final consignee have the same meaning. The final consignee is used only for specialty polymer GBU.
Sales rep
Country	Refers to the country where the customer address is (the customer can be ship to or sold to)
Region (Zone)	Region of the account
GBU region	It is a customize dimension made in the transparency dashboard based on the data object "Region (Zone)" to reflect the pricing organization of the GBUs. There are 4 known Solvay regions but it can happen that for one activity, GBU decides to change the region for a country.
Account manager
Team cluster
GBU customer segment	Customer segmentation is being defined at GBU level, allocating accounts to one of the 5 following segments: Strategic Key Accounts (SKAs), Key Accounts (KAs), Critical Accounts (CAs), Standard Accounts (SAs), Key and Standard Distributors (KDs and Ds)
Group customer segment	At Group level, GBU segmentations are consolidating into one Group segmentation, mainly for performance monitoring purpose, according to 2 elements: i) Per ExCom decision, a selection of accounts have been elevated to Group Strategic Key Accounts (GSKAs) status at Group level given their importance and stake for Solvay overall (see GSKA workstream playbook). All GSKAs are segmented as SKA at the GBU-level. ii) All other accounts are consolidated into the Group segmentation being either a Distributor (KD or SD) or considering their highest segments (SKA > KA > CA > SA) in case of cross-GBU accounts with different segment allocation per GBU
Material
Material group/Product
Product H4
HPAM
Product hierarchy PIF
Product hierarchy
GBU product family	One product/material belongs to a product family per GBU. It is unique per combination of GBU and product/material
GBU material group
HPAM
Business line (Business Unit)
Product manager
Product line (0 to X)
Product line E2E
Packaging type
Product brand
Unit conversion rate
Market	It has been defined at group level. It is linked to consumers behavior that has been chosen to be strategic for the Solvay Group. It should be considered as an end-Market (e.g. Automotive)
End use	Subcategory of Application and describes mainly objects manufactured by the direct customers (e.g. Camera: modules) or the main functionality of the product (e.g. moisturizing agent for shampoo)
Application	Subcategory of the Segment and represents a description of objects or chemicals that have a specific action/function (e.g. aroma, nutrient..)
Segment	Represents functionalities (e.g. light weighting), based on Market's needs. In residual cases (e.g. Consumer Goods), describes categories of parts or goods regrouped by usage (e.g. food packaging
Enterprise segment
Market cluster
BDM
Investor market group
GBU segment	Segment related to the account (CS1 -SKA, CS2 - KA, CS3- CA, CS8 - KD, CS4 - SA, CS5 - SD, CS6 Not Valid, CS7 - Not yet Assigned)
GBU	It stands for Global Business Unit. There are 9 GBUs defined
Group of activity
Exchange rate	Exchange Rate

Space shortcuts

Page tree