Laure Imberti
Process Expert
Miriam Luttrin
General Description
This KPI seek to analyse the number of order and order lines created

 Indicator details results can be analyzed by :
  • Ship to Country
  • BFC BU
  • Sales Office
  • ZI Partner
  • Zone (SO)
  • GBU
 Date Reference:
Order Line Creation Date
       
  Refresh Frequency: 
Daily
KPI Name
Calculation
#Order Lines
Number of order lines created on the select period according to the report premise (source information)
%Order Lines
----------------------------------Number of order lines created by the selected dimension
---------------------------------------------------------------------------------------------------------------------------------------------------------
--Number of order lines created on the select period according to the report premise (source information)
  
#Orders
Number of orders created on the select period according to the report premise (source information)
%Orders
------------------------------------Number of orders created by the selected dimension
---------------------------------------------------------------------------------------------------------------------------------------------------
--Number of orders created on the select period according to the report premise (source information)
  
Average # of lines by orders
#Order Lines Number of order lines created on the select period according to the report premise (source information)
------------------ = ----------------------------------------------------------------------------------------------------------------------------------------------------
---#Orders Number of orders created on the select period according to the report premise (source information)
Source Information:
QV Query:
BI4 (Rhodia): NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001
BW (Solvay): QVSBS_BW_QRY_ZZVORD_0001
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)
BW Filters:
[0SOLD_TO__0CUST_CLASS] CUSTOMER CLASSIFIC <> [G] GROUP COMPANY
Doc Type:
PF1 (BW) - KBN, TDN, KEN, TAS, ZTAS, ZT1N, ZTDN, ZTDL, KLN, KNN, ZKMN, ZDMN, TDXR, ZTDR, ZORB, ZITI, ZRCM, ZRCS, ZIND, ZIRS, ZVEX, ZVEY, ZSAM, ZTES, ZDON, ZRAG, ZOUT, ZT1E, ZTDE, Z1IR, ZRDC, ZKLE, Z109, ZKNE, Z1QP, ZKMS, ZDMS, Z1Q5, ZEXP, ZRPE, ZRIN, ZVXI, ZVF1, Z1Q6, ZRGI, ZTDM, Z1E3, Z1RD, ZRVO, Z104, ZRP1, Z1IX, Z105, ZRP2, Z107, ZRP3, Z108
Specific Dimensions
Sales Office