Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.




Image Removed

Info
titleSupply Chain Excellence
Marie-Ange Carrier

  


Info
iconfalse
titleIS Reporting Coordinator
Diogo Paiva
Info
iconfalse
titleD&PS Expert
EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong
Info
iconfalse
titleAuthorization & Rights
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.

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
Info
iconfalse
titleTarget Users
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers






Calculation:


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


**Sales Order Type Group
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
Period
Month Year
Order 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
Plant
Zone
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant
[CPLANT] Plant
Ship Destination
Zone
[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
Product
Product 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

...