Marie-Ange Carrier

  

Diogo Paiva


EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong



General Description

In this indicator, we measure both by number and by value of eOrdering order lines against total number of Order lines. The indicator is split by eOrdering via Website, B2B and Manual order lines.
**Website refers to eOrdering via Solvay's eCommerce Websites (Solvay4Me & Rhodia eCommerce)
**B2B is refers to eOrdering via third party systems (example EDI, Elemica, and Quicklink)


KPI:

% E-Ordering (by volume, by value)
#E-Ordering
% Website
#Website
%B2B
#B2B
#Manual

Scope:

  • Exclusion of material types servicesa and packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
  • Exclusion of SOLD entities (consolidation method = SOLD)
  • Intra GBU flag = N
  • See this link to see the full default scope of the Customer Service KPIs by Sales Doc Types: Global Sales Order Doc Types



  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers


All the accesses must be validated by:

Supply Chain Excellence

Click here for the Access form to get access to the Global Supply Chain Dashboard.


Calculation:


KPI Name
Calculation
#E-Ordering
#B2B + #Website
% E-Ordering
--------eOrdering
---------------------------------- x100
(#eOrdering + #Manual)
  
#Website
WP1:
Order Type = "Rhodia eCommerce - OMC" + "Rhodia eCommerce - Cust"
PF1:
Order Type = WEB (via web Slv4me) + WEBC (SpP Webshop - CC) + EVMI (e-VMI)
% Website
----------# Website
---------------------------------- x100
(#eOrdering + #Manual)
  
#B2B
Order Type = B2B (Via e-business B2B) + DFUE (By telecommunication)
% B2B
-------------#B2B
----------------------------------
(#eOrdering + #Manual)
  
#Manual
# Total Order Lines - #eOrdering
  
Value e-Ordering
Conversion CTK_OBAS1: CTK_GS08 and CTK_GS09: type M (daily exchange rate)
Conversion base dates:
If there is a shipment document: Billing date
If doesn't have a shipment document but there is a delivery document: Actual GI date
If doesn't have a delivery document : Order Creation date




Technical Documentation

Source:

CORE: BW_QRY_MVSDSO57_0001

QV: QVBW_QRY_MVSDSO57_0001

Update:

Daily

Query filters applied:

Source Information:
Filters
BW
QVBW_QRY_MVSDSO57_0001

Exclusion of material types: Services & Packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB

Exclusion of SOLD entities (consolidation method = SOLD)

Dimensions:

Global Overview of Dimensions





BW
Global Filters















PeriodMonth Year
Order Line Creation Month

Organization


GBU

[CPFCTR1_2] GBU

Group of Activity

[0G_CWWE01__CPFCTR2_2] Group of Activities

Sub-Activity

[0G_CWWE01__C_MAGNITU] BFC Market

Company

[C_COMPCDE] Company
PlantZone
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant
[CPLANT] Plant
Ship DestinationZone
[C_SHIPTID] Ship-to\Attributes\[C_GZONE] Geographie/Zone
Country
[C_SHIPTID] Ship-to\Attributes\[0COUNTRY] Country key
Corporate Group
[C_SHIPTID] Ship-to\Attributes\[C_CORPGR] CRM Customer Corp. Group (PRS)
Ship Destination
[C_SHIPTID] Ship-to
ProductProduct Hierarchy
[C_MATNR2__C_PRDHIER] Product Hier (LIP03)
Product
[C_MATNR2__C_PROD] Commercial Product / Material Group
Bulk/Packed
[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group
Packaging Type
[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type
Specific Filters




Sales Doc Type Group

For the Grouping correspondance table see link

Sales Doc Type

[C_DOCTYP2] Order document type

Sales Office

[C_SAL_OFF] Sales Office
CSR
[C_CUSTSAL__C_ZIPART] CSR (Sold-to)


DashboardBW & BI4 Key FiguresSAP

CSR (Customer Service Representative)

- the person in responsible to create and manage the Sales Order

BW
[_CUSTSAL__C_ZIPART]
ZI Partner sold to 
Customer masterdata (Sales area data)
  •  WP1: Partner functions → ZI
  • PF1: Partner functions → VW