Mari-Ange Carrier
Process Expert


Miriam Luttrin



General Description
This KPI seeks 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
%Order Lines
  
#Orders
%Orders
  
Average # of lines by orders


Source Information:
QV Query:
BI4 (WP1): NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001
BW (PF1 Data): QV_BW_QRY_MVSDSO45_SD0005
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:
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.
Excluded orders are not considerated

 

Dimensions:

SAP
BW & BI4 Key Figures
OtC Dashboard
Comments
 
-
Sales Office Zone
BW query: QV_0COUNTRY_000
(Manual Mapping)
 
-
Country
BW query: QV_0COUNTRY_000
(Manual Mapping)
 
[C_COMPCDE]
Company Code
Legal Entity
 
 
[0G_CWWE01_CPFCTR1_2] BFC GBU
GBU
 
 
[0G_CWWWE01__CPFCTR2_2] BFC B.U
Group of Activity
 
 
[0G_CWWE01]
Sub-activity
Sub-Activity
 
 
[C_SAL_OFF]
Sales Office
Sales Office
 
  
SBS Perimeter
Made in QV SBS Perimeter (details above)
Customer masterdata (Sales area data)
  •  WP1: Partner functions → ZI
  • PF1: Partner functions → VW

BI4 (WP1):
ZI Partner
BW (PF1)
[_CUSTSAL__C_ZIPART]
ZI Partner sold to 

ZI Partner
The Customer Service Representative - the person in Customer Service responsible to create and manage the Sales Order