Versions Compared

Old Version 3

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user Breteau-laurent, Laure

Saved on

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:

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:
    Services , Packaging, Internal GBU sales and Sold entities are excluded:
    • 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
    Supply Chain Excellence

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






    Calculation:


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


    **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
    Image ModifiedExclusion of material types: Services & Packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
    Image ModifiedExclusion 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 → ZIImage Modified
    • PF1: Partner functions → VWImage Modified