Relation between end use, enterprise segment, GBU segment and market
| 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 | Transfer responsibility between supplier and customer. | Transactional | QVSBS_BW_QRY_CPCOPA03_0001 QV_BW_QRY_CPCOPC07_0001 | [C_INCOTRM] Incoterms_P | ||||||
| Source system | Source System_[0LOGSYS] | ||||||||||
| Product/Material | Material code | Key_[C_MATNR2].[2C_MATNR2] | |||||||||
| Material name | Medium Name_[C_MATNR2].[5C_MATNR2] | ||||||||||
| 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 Key_[C_SHIPID].[2C_SHIPID] | Customer: ship to, sold to, ship to KA | |||||
| Customer | Ship-to name | Medium Name_[C_SHIPID].[5C_SHIPID] | |||||||||
| Customer | Sold to code | Transactional | Key_[C_SOLDID].[2C_SOLDID] | Customer: ship to, sold to, ship to KA | |||||||
| Customer | Sold-to name | Medium Name_[C_SOLDID].[5C_SOLDID] | |||||||||
| Customer | Sold-to group | BW or SF | CRM Cust.Corp.Group (Name)_[C_CUST_UC].[1C_CORPGR] | ||||||||
| Organization | Group of Activity | BFC Group of activities_[4CPCOPA03-TECM_PFCT2_2] | |||||||||
| Customer | Country ship to | Country of the customer delivered | QVSBS_BW_QRY_CPCOPA03_0001 QV_BW_QRY_MVSDSO61_0001 QV_BW_QRY_CPCOPC07_0001 | Country (Key)_[C_SHIPID].[20COUNTRY] [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 | Country (Name)_[C_SOLDID].[10COUNTRY] "[0COUNTRY] Country if empty => [C_SHIPTID] Ship-to party\Attributes\[0COUNTRY] Country key" | |||||||
| GBU Zone H1 | GBU Ship-to zone 1_[4CPCOPA03-TGB2_ZONEH1] | ||||||||||
| Organization | GBU region | Customize field to reflect the pricing organisation of the GBUs 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. First priority | 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 | GBR: Enterprise segment_W_[C_ENTSEG3] | ||||||
| Market | GBU segment | Refer to the market like automotive | For the moment only GBU segment of NC is important | ||||||||
| Market | Market | Less priority due to high correlation with end use | There is a hierarchy/relation between end use, enterprise & GBU segment, market → to duscuss separately | ||||||||
| 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_ Group Segm. (Corp) (Name)_[C_SOLDID].[1C_CUSTGRC] | ||||||
| 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 Corporate Segment = Sold_to_party -> Bus_Rank__Corp___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 Nestor Teijeiroprado → SF questions | QV_BW_QRY_CPCOPC07_0001 | GBU Segm. (Sold-to)_[C_CUSTSAL__0CUST_GRP2] | ||||
| Packaging type | Packaging type (Medium Name)_[C_MATNR2].[5C_MATGR2] | ||||||||||
| 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 | |||||||||||