Jose-Pablo Leyva


Miriam Luttrin



General Description

xxxx - Jose Pablo Leyva


KPI:

Inventory Values (BFC)

DOS - Days of Stock (BFC)

Inventory Volumes (BW) - Only the products that can be converted in KG.

Granularity:

BFC = BFC Account

BW = BFC Account & WC Acct Subtype


Comments:

  • BW versus BFC Inventory Values: 

BW Inventory values are different from those coming from BFC.

The 2 main reasons are : the organization perimeter (only SAP companies in BW and all companies even non SAP in Finance) and the CONSO adjustments.

BW Inventory Values are not shown in this dashboard.


  • Conversion rules: conversion from a local currency to EUR is based on the exchange rate managed by Finance. For each inventory value, the rate considered is the one of the inventory month.

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).

So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.



  • 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.




Only the external sales of the GBU (We don’t consider the ‘Intra GBU’ flows)


DOS (Days of Sales): number of days of inventory in comparison to the executed sales. (inventory of month M, sales of month M)

Calculation:

 



Technical Documentation

Source:

BFC Extraction

Working Capital - QVWCAP_BW_QRY_MVFIWC01_0014

Update:

Daily

Query filters applied:

Dimensions:

Global Overview of Dimensions



Inventory Value

Inventory Volumes - Net Weight
Global Filters
















PeriodMonth YearPeriodname
Data shown in column by Month Year

Organization


GBU

entrp_name
1 - BFC GBU [C_SUBACT2__CPFCTR1_2]

Group of Activity

N/A2 - BFC Group of activ. [C_SUBACT2__CPFCTR2_2]

Sub-Activity

N/ASub-activity [C_MATPNT2__0G_CWWE01] Attribute/ BFC Activity 1 [C_MAGNUTU]

Company

N/A[C_COMPCDE] Company_code
PlantZonezonename
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Countrycountryname
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
PlantN/A
[C_PLANT] Plant
Ship DestinationZoneN/A
Ship Dest Geo Zone [C_PNTDS3__C_ZONE]
CountryN/A
Ship Dest Country [C_PNTDS3__0COUNTRY]
Corporate GroupN/A
Delivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
Ship DestinationN/A
Ship Destination Point [C_PNTDS3]
ProductProduct HierarchyN/A
Material Hierarchy C_MATNR2__0PROD_HIER]
ProductN/A
Commercial Product / Material Group [C_MATNR2__C_PROD]
Bulk/PackedN/A
C_MATNR2__C_BULKPAC] Material bulk pack
Transport Mode

N/A

[C_SHIPNU2__C_TR_MODE] Ship Transportation Mode
Specific Filters




BFC Account

BFC Account
QV Mapping based on BFC Account [0GL_ACCOUNT__C_MGN_ACC]* see tranco table

WC Acct Suptype

N/AGL Acct Subtype [0GL_ACCOUNT__C_GL_STYP]


Transcodition BFC Account
Inventory: finished gdsFinished Goods
Inventory: raw materials - Gross ValueRaw Materials
Inventory: work-in-progressWork in Progress
Inventory : prov work-in-progressWork in Progress
Inventory: prov. raw materialsRaw Materials
Inventory: prov finished/semi-finished goodsFinished Goods