Versions Compared

Old Version 8

changes.mady.by.user Karina Keiko Tsuji

Saved on

compared with

New Version Current

changes.mady.by.user Stephane BOURGEAUD-LIGNOT

Saved on

Key

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

 


Info
titleProcess Owner
Laure Imberti
Process Expert


Info
titleD&PS Expert
Miriam Luttrin



General Description
This indicator calculates the number Order Lines split by type: Manual, Export, Free, Sample and Return order lines.
 Indicator details results can be analyzed by :
  • GBU
  • ZI Partner
  • Ship to Group
  • Sales Office
  • Sales Office Zone
 Date Reference:
 Order Line Creation
  Refresh Frequency: 
 Monthly



KPI Name
Calculation
#e Ordering
# eOrdering Order Lines
Cust PO type = DFUE/WEBS
Order Created by "ID ELEMICA/WF-BATCH/OPSCHEDULE/ WEB METHODS" or "ID = (starts with "SC_" or ends with "_EC")" or "Rhodia eCommerce - OMC"
BI4:
Order Type = Rhodia eCommerce - OMC + Rhodia eCommerce - Cust + B2B
BW:
Order Type = WEB (via web Slv4me) + WEBC (SpP Webshop - CC) + EVMI (e-VMI) + B2B (Via e-business B2B) + DFUE (By telecommunication)
 
#Manual Order Lines
Else = Manual
  
#Export Order Lines
Legal Company BFC Zone Name = EU and NA vs. Ship to Geographical Zone Name
Legal Company Country Name = AP and LA vs. Ship to Country Name
* Intra Enterprise flag = N
BI4 and BW:
Order line with Flag Export = Y

Flag Export Rule:
  • For Company Zone = EU or NA
    Company Zone <> Ship to zone then Flag Export = Y

  • For Company Zone = AP or LA
    Ship to country <> Sales Office Zone then Flag Export = Y
  
# LC
BI4:
Order lines with order payment method = 010 / 011
% LC vs. Export Order Lines
------------# LC
--------------------------------
--#Export Order Lines
  
#Free Order Lines
BI4:
Total Billing w/o taxes = 0 or empty
Order document type =
KL/
FG/ZAGR
/ZKL
(#Samples Order Lines Excluded).
BW:
Item Category = 'ZKMS','ZR4N','ZTAS' (#Samples Order Lines Excluded).
#Samples Order Lines
BI4:
Order type = TA
PO type <> DFUE/WEBS and SMART samples + Order type KL/ZKL
BW:
Item Category =  'KLN','KNN','ZSAM'
#Return Order Lines
 


Source Information:
QV Query:
Filters
BI4 Query (
Rhodia
WP1 Data):
NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001
BI4 Filters:
Image ModifiedLEGAL COMPANIES <>ZFR9/7378
Image ModifiedDISTRIBUTION CHANNEL <> 8I
Image ModifiedSHIP TO KA <> GRCL200022/9999999999/GRCL000098
Image ModifiedORDER FLOW CODE = R
Image ModifiedDOC TYPE = FG/KB/KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/KL
Image ModifiedORDER REJETION:
 CODE = 98 OR
EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)
BW Query (PF1 Data):
QV_BW_QRY_MVSDSO45_SD0005
Image Added[0SOLD_TO__0CUST_CLASS] CUSTOMER CLASSIFIC <> [G] GROUP COMPANY
Image AddedDoc Type:
KBN, KEN, KLN, KNN, TAS, TDN, TDXR, Z104, Z105, Z107, Z108, Z109, Z1E3, Z1IR, Z1IX, Z1Q5, Z1Q6, Z1QP, Z1RD, ZDMN, ZDMS, ZDON, ZEXP, ZIND, ZIRS, ZITI, ZKLE, ZKMN, ZKMS, ZKNE, ZORB, ZOUT, ZR4N, ZRAG, ZRCM, ZRCS, ZRDC, ZRGI, ZRIN, ZRP1, ZRP2, ZRP3, ZRPE, ZRVO, ZSAM, ZT1E, ZT1N, ZTAS, ZTDE, ZTDL, ZTDM, ZTDN, ZTDR, ZTES, ZVEX, ZVEY, ZVF1, ZVXI.


Specific Dimensions
Sales Office