| Google Drive Live Link | ||
|---|---|---|
|
| Google Drive Live Link | ||
|---|---|---|
|
...
QVSBS_BW_QRY_CPCOPA03_0001
QV_BW_QRY_CPCOPC07_0001
...
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]
...
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
...
Country (Name)_[C_SOLDID].[10COUNTRY]
"[0COUNTRY] Country if empty => [C_SHIPTID] Ship-to party\Attributes\[0COUNTRY] Country key"
...
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
...
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
...
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)
...
QV_BW_QRY_MVSDSO61_0001
QV_BW_QRY_CPCOPC07_0001
Bus_Rank__Corp_
...
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.
...
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
...