Versions Compared

Old Version 7

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user POLOSSON-ext, Damien

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.






Image Removed

Info
titleSupply Chain Excellence
Marie-Ange Carrier

  

Info
iconfalse
titleIS Reporting Coordinator
Diogo Paiva
Info
iconfalse
titleD&PS Expert
EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong
Customer Service

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
  • Scope for eOrdering Ratio: Sales Doc. Type Group = Standard Order and Consignment. See column "F" in file Global Sales Order Doc Types.
Info
iconfalse
titleTarget Users
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Account Managers
    • Info
    iconfalse
    titleAuthorization & Rights
    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
    Image Modified Exclusion of material types: Services & Packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
    Image Modified Exclusion of SOLD entities (consolidation method = SOLD)
    Dimensions:
    Global Overview of Dimensions



    		BW
    Global Filters
    Period
    Month 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
    Plant
    Zone
    [C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
    Country
    [C_PLANT] Plant\Attributes\[0COUNTRY] Country key
    Plant
    [CPLANT] Plant
    Ship Destination
    Zone
    [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
    Product
    Product 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
    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 c reate and manage the Sales Order
    BW
    [_CUSTSAL__C_ZIPART]
    ZI Partner sold to  
    Customer masterdata (Sales area data)
    •  WP1: Partner functions → ZI
      Image Modified
    • PF1: Partner functions → VW
      Image Modified