Data Mapping

Sales data comes from MVCOPA01_0004 for all GBUs within SAP. Some NonSAP legal entities are already within this query as well. For all Legal entities not in SAP (CM Industrial, Chemlogics for historical data, Monterrey ?), we need a manual flat file.

1. For SpP data, we get the Final Consignee (=ShipTo KA) at the SoldTo level, whereas ShipTo KA is at Copr Group Level. Therefore we need to get the group from the Final Consignee code.
   
   
   
2. Untill the groups are totally clean in BW, including for SpP, we need to add an exception list to correct the groups (SoldTo / ShipTo Corp Groups) based on the ShipTo / SoldTo codes. For SpP this group override is first done by mapping the groups from ICARE CRM. Then, for all other GBUs (mostly for SpP and CM) we have a manual file
   
   
3. Then we identify the given 23 GSKA based on the condition : SoldTo Group OR ShipTo KA (Final Consignee).

Sales linked to a given GSKA are selected if they match one of the 2 following connditions :

• GSKA = SoldTo Group
• GSKA = ShipTo KA (based on Final consignee for SpP)

In the here beside example, regarding Baker Hughes Sales :
 

1. SoldTo is Baker Hughes (= direct sales)
   (orange bucket)
    
2. SoldTo is NOT Baker Hughes (= indirect sales)
   (yellow bucket)

For a given GSKA, here is the "transformation matrix" from the SoldTo Group / ShipTo KA dimensions to the split direct / indirect Sales :

If you compare with CRM Analytics (or BW), it is straight forward to get the direct sales (example Samsung). Direct sales to Samsung are 95.8M€ : the total of sales having Soldto Group = Samsung.

For the indirect sales, you can't find directly the result in CRM Analytics (or BW). You need to select ShipTo KA = Samsung first. You can see that the 72.1 M€ figure (SoldTo Group = Samsung AND ShipTo KA Samsung) is already counted in direct sales (see previous screenshot). You need the to remove these 72.1M€ to the 91.4 M€ total. Indirect Sales for Samsung is : 19.3M€.