Marie-Ange Carrier

  

Diogo Paiva


EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong



General Description

This page displays the number of orders and order lines created per month with the opportunity to split the analysis by Sales Doc Type Group**, Sales Doc Type, and Sales Office
KPI:
Number of Orders
Number of Order lines
Average number of Order Lines per Order
Scope:
  • Exclusion of material types servicesa and packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
  • Exclusion of SOLD entities (consolidation method = SOLD)
  • Intra GBU flag = N
  • See this link to see the full default scope of the Customer Service KPIs by Sales Doc Types: Global Sales Order Doc Types



  • 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


**Sales Order Type Group
For the Grouping correspondance table see link


Technical Documentation
Source:
CORE: BW_QRY_MVSDSO57_0001
QV: QVBW_QRY_MVSDSO57_0001
Update:
Daily
Query filters applied:
Source Information:
Filters
BW
QVBW_QRY_MVSDSO57_0001
Exclusion of material types: Services & Packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
Exclusion of SOLD entities (consolidation method = SOLD)
Dimensions:

Global Overview of Dimensions




BW
Global Filters
















PeriodMonth YearOrder Line Creation Month

Organization


GBU

[CPFCTR1_2] GBU

Group of Activity

[0G_CWWE01__CPFCTR2_2] Group of Activities

Sub-Activity

[0G_CWWE01__C_MAGNITU] BFC Market

Company

[C_COMPCDE] Company
PlantZone[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant[CPLANT] Plant
Ship DestinationZone[C_SHIPTID] Ship-to\Attributes\[C_GZONE] Geographie/Zone
Country[C_SHIPTID] Ship-to\Attributes\[0COUNTRY] Country key
Corporate Group[C_SHIPTID] Ship-to\Attributes\[C_CORPGR] CRM Customer Corp. Group (PRS)
Ship Destination[C_SHIPTID] Ship-to
ProductProduct Hierarchy[C_MATNR2__C_PRDHIER] Product Hier (LIP03)
Product[C_MATNR2__C_PROD] Commercial Product / Material Group
Bulk/Packed[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group
Packaging Type[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type
Specific Filters




Sales Doc Type Group

For the Grouping correspondance table see link

Sales Doc Type

[C_DOCTYP2] Order document type

Sales Office

[C_SAL_OFF] Sales Office
CSR[C_CUSTSAL__C_ZIPART] CSR (Sold-to)


DashboardBW & BI4 Key FiguresSAP

CSR (Customer Service Representative)

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

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