Process Owner

Benoit HORNYAK

 



General Description

This dashboard has been developed by Supply Chain Excellence to provide visibility on inventories. Visibility on inventories is a key element to start inventory optimization projects and ensure sustainability in the improvements. The visibility can support 5 to 10% of the reductions.

General features:

  • The tool provides graphical views, analytical functions, possibility to extract to Excel.
  • Ability to make a selection on inventory by month (end of Month inventory situation).
  • Visibility of inventory at each distribution point and globally.
  • For a given GBU, visibility by Zone/Company/Plant/Material (aggregation and dis-aggregation possible).
  • Ability to select a material or a group of material (from material number to product hierarchy/commercial product)
  • Make distinction between Finished Goods, Intermediates, Raw Materials.

Scope:

  • The tool covers Finished Goods, Intermediates, Raw Materials. The distinction between the different material types is done according to the SAP valuation class (Accounting 1 view of material master file MM03).
    • WP1: Z100 CS Raw materials, Z130 CS Trading goods, Z140 CS Intermediates.
    • PF1: Z000 Main raw materials, Z007 Main raw materials-import, Z049 Interplant raw materials, Z050 Other raw materials, Z053 Semi finished products, Z061 Semi finished products, Z100 Finished goods manuf, Z101 Finished goods purch.
  • Packaging and Spare Parts are not included in this dashboard.
  • Data available for the 2 past full years.

 

 

 

 

Tabs
Description
Key figures
Scatter
Comparison

Overview

Stock value by Zone / Country / Plant / Stock Type / Valuation Class   
Inventory Value    
Inventory Quantity    
Aging Stock    
Stock Typology    
Analytics    
Reports    

 

 

 

 

Dimension 
  



Key FiguresDescriptions

 Stock Value

 
Stock Quantity 
Global Sales 
Globales Consumptions 
Sales 
Restocking 
In Transit 
Source SystemData sourcesSource Query NameSource Query DescriptionWBP Qlikview Query Name
WP1Stock Value and Quantity, Stock Typology, Global Consumption, Global SalesWBP: BW_QRY_MPR_IC001_0014BW - Stock Movement All Types (Core Query)QVSBS_BW_QRY_MPR_IC001_0004 (VAL QTY)
PF1 & WP1Stock In TransitWBP: BW_QRY_MVFIWC01_0005BW - Working Capital Inventories (Core Query)QVSBS_BW_QRY_MVFIWC01_0001
WP1Aging StockWBP: BW_QRY_MPR_IC001_0051 BW - Stock Values and Quantities (Core Query)QVSBS_BW_QRY_MPR_IC001_0003(BATCH)
PF1Stock Value and Quantity, Stock Typology, Global Consumption, Global SalesWBP: BW_QRY_MVMMIC01_0003BW - Inventory Management - Stock Movement (Core Query)

QVSBS_BW_QRY_MVMMIC01_0001

QVSBS_BW_QRY_MVMMIC01_0002

PF1 & WP1SalesBI4: INVEX_LIST_OF_SALES_CWWPPS_R001INVEX_LIST_OF_SALES_CWWPPS_R001QVSBS_BW_QRY_MVSDSO44_0001
PF1 & WP1Purchase (Inter-company Stock Replenishment)BI4: INVEX_LIST_OF_SALES_CWWPPS_R001INVEX_LIST_OF_SALES_CWWPPS_R001QVSBS_BW_QRY_MVSDSO42_0001
Currencies
  • EUR
  • Conversion rate : ????? Yearly Cumulated average Monthly of Y-1

Target Users

Authorization & Rights

All the accesses must be validated by the process owner Benoit HORNYAK