Laure Imberti
Process Expert
Miriam Luttrin
General Description
 This indicator explore the automatically order lines vs. manual order lines
 Indicator details results can be analyzed by :
  • ZI Partner
  • GBU
  • Sales Office Zone
 Date Reference:
Order Line Creation Date

 Refresh Frequency: 
Daily
KPI Name
Calculation
#eOrdering
#B2B + #Website
%eOrdering
--------eOrdering
---------------------------------- x100
(#eOrdering + #Manual)
  
#Website
BI4:
Order Type = "Rhodia eCommerce - OMC" + "Rhodia eCommerce - Cust"
BW:
Order Type = WEB (via web Slv4me) + WEBC (SpP Webshop - CC) + EVMI (e-VMI)
%Website
----------# Website
---------------------------------- x100
(#eOrdering + #Manual)
  
#B2B
BI4:
Order Type = B2B
BW:
Order Type = B2B (Via e-business B2B) + DFUE (By telecommunication)
%B2B
-------------#B2B
----------------------------------
(#eOrdering + #Manual)
  
Manual
#Order Lines - #eOrdering
  
Value e-Ordering
BI4:
Currency Conversion:
Rate Month M = M*Rate Cumulative Month M - (M-1)*Rate Cumulative Month (M-1)
→ Pivot: euro
BW:
Currency Conversion: day
→ Pivot: euro
Source Information:
QV Query:
BI4 (Rhodia): eCOMMERCE DASHBOARD_CWWPPS_R004
Tab: QlickView
BW (Solvay): BW_QRY_MVSDSO45_SD0006
BI4 Filters:
ORDER FLOW CODE = C OR
ORDER FLOW CODE = R AND SHIP TO KA <> GRCL200022/9999999999/GRCL000098
DOC TYPE = KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/NB/UB
ORDER REJETION CODE = 98 OR EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)
LEGAL COMPANIES <>ZFR9/7378
DISTRIBUTION CHANNEL <> 8I
BW Filter:
[0COMP_CODE] COMPANY CODE <> 5711/5696/5672/5622/4058/3469/1428/1427/1426/1425/1419/0292
Reversal indicator <> R
[0DOC_TYPE] SALES DOC TYPE = KA/KB/KBCC/KE/LA/SB/T1/TD/TDIV/TDR/ZFAC/ZIND/ZITI/ZORB/ZOUT/ZRAG/ZRCM/ZRCS/ZSE1/ZSER/ZSIT/ATD/ZTDL/ZTDR/ZTES/ZVEX/ZVEY/ZVNO
Specific Dimensions
Sales Office