Laure Imberti
Process 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 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"
#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
  
# LC
Order lines with order payment method = 010 / 011
% LC vs. Export Order Lines
------------# LC
--------------------------------
--#Export Order Lines
  
#Free Order Lines
Total Billing w/o taxes = 0 or empty
Order document type = KL/FG/ZAGR/ZKL
#Samples Order Lines
Order type = TA
PO type <> DFUE/WEBS and SMART samples + Order type KL/ZKL
#Return Order Lines
 
Source Information:
QV Query:
BI4 (Rhodia): NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001
BI4 Filters:
LEGAL COMPANIES <>ZFR9/7378
DISTRIBUTION CHANNEL <> 8I
SHIP TO KA <> GRCL200022/9999999999/GRCL000098
ORDER FLOW CODE = R
DOC TYPE = FG/KB/KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/KL
ORDER REJETION:
 CODE = 98 OR
EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)
Specific Dimensions
Sales Office