Marie-Ange Carrier


Miriam Luttrin



General Description

This page displays the number of order and order lines created per month and split by type: Standard, Free, Samples, Return order lines.

KPI:

Number of Orders

Number of Order lines

Average number of Order Lines per Order




  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers


All the accesses must be validated by:

Supply Chain Excellence

Click here for the Access form to get access to the Global Supply Chain Dashboard.


Calculation:


KPI Name
Calculation
#Order Lines
#Orders
Average # of lines by orders


Standard Order Lines

Free Order Lines
BI4:
Total Billing w/o taxes = 0 or empty
Order document type = FG/ZAGR (#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


Technical Documentation

Source:

BW OBAS- QV_BW_QRY_MVSDSO45_SD0005

BI4:

NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001

NB SBS Monthly Dashboard CS Return orders CSWWPPS R001

Update:

Daily

Query filters applied:

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

Dimensions:

Global Overview of Dimensions





BWBI4
Global Filters
















PeriodMonth YearOrder Line Creation Month
Order document date YYYY/MM

Organization


GBU

[0G_CWWE01__CPFCTR1_2] GBU

Sector zone name

Group of Activity

[0G_CWWE01__CPFCTR2_2] Group of Activities

FC BU Name

Sub-Activity

N/A

BFC Market

Company

[C_COMPCDE] Company

Legal Company
PlantZone[C_GZONE] Geographie/ZonePlant geographical zone
Country[0COUNTRY] Country key
Plant country
Plant

[0PLANT] Plant

Plant name
Ship DestinationZone[C_GZONE] Geographie/Zone
Ship to geo Zone name
Country[C_SHIPTID__0COUNTRY] Ship-to country
Ship to country name
Corporate Group[C_CORPGR] CRM Customer Corp. Group (PRS)
Ship to group name
Ship Destination[C_SHIPTID] Ship-to
Ship to name
ProductProduct Hierarchy[C_PRODHIE] Product HierarchyN/A
Product[C_MATNR2] Material\Attributes\[C_PROD] Commercial Product / Material GroupProduct Name
Bulk/Packed[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group

Mapping based on:

Material Packaging Group Name Bulk =

Packed in Bulk else = Packed

Packaging Type[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type
Material Packaging Group Name
Specific Filters




Sales Office

Qv Mapping based on Sales Office

QV Mapping based on Sales Office

Sales Office Country

QV Mapping based on Sales Office

QV Mapping based on Sales Office

Sales Office

[C_SAL_OFF] Sales Office

Sales office name
CSR[C_CUSTSAL__C_ZIPART] CSR (Sold-to)
Order partner ZI actualized name


DashboardBW & BI4 Key FiguresSAP

CSR (Customer Service Representative)

- the person in responsible to create and manage the Sales Order

BI4 (WP1):
ZI Partner
BW (PF1)
[_CUSTSAL__C_ZIPART]
ZI Partner sold to 
Customer masterdata (Sales area data)
  •  WP1: Partner functions → ZI
  • PF1: Partner functions → VW