You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »


Supply Chain Excellence

Marie-Ange Carrier

  

IS Reporting Coordinator

Diogo Paiva

D&PS Expert

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

Target Users

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

Authorization & 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.

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
















PeriodMonth 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
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

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels