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:

See this link to see the full default scope of the Customer Service KPIs by Sales Doc Types: Global Sales Order Doc Types
See column "F" in the file for the Scope specifically for the eOrdering ratio. Generally the ones included for this KPI are Standard and Consignment Orders only.



  • 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: type M (daily exchange rate based) on 0BILL_DATE (Billing Date)

@vincent lapague Karina Keiko Tsuji - currently not working. Need to change to be based on Order line creation date (natalia)


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