OBF Orderbook Follow-up - Draft

General Description

The Customer Engagement Analysis dashboard provides an overview of Solvay's complete Order Book with comparison capabilities that permits users to look at previous states of the Order Book.

The dashboard also gives a macro overview of Solvay's Opportunity Pipe.

Order Book

Opportunities

Scope:

All GBUs including Specialty Polymers and Composite Materials
Sales Orders only (External customers). No PO.
Exclusion of Peroxide JV.

Currencies and Exchange Rate:

EUR (CAR4 ) for Pending Orders
EUR (CAR3) for Invoiced (P&L)
EUR (already converted by the GBU) for Composite Materials
Snapshots are stored directly in EUR, with the rate at the time we take the snapshot. If the rate is revised (monthly revision for instance), it will have no impact on the snapshot.

Sources for the dashboard include:

BW Global Sales queries (MVSDSO)
BW P&L query (MVCOPA)
Manual flat file for Composite Materials (non-SAP scope)

Data Refresh Frequency:

Daily for all GBUs in BW including the CM scope in SAP
Weekly (on mondays) for CM Scope not yet in SAP

Useful links on General Information and Sources:

To be Completed

Target Users

ExCom members
Excellence Center
GBU Leadership Team

Authorization & Rights

All GBUs or by GBU.

Definitions

Definitions
(Definitions related to Orderbook, see EC Order management Playbook) Invoiced Y-1 = Invoiced from P&L Query (or flat file) Invoiced = Invoiced from P&L Query (or flat file) Pending = Confirmed + Shipped not Billed from Global Sale Query (or flat file) Not Confirmend = No confirmed from Global Sales Query (or flat file)

Data Sources / Mappings
QVSD_BW_QRY_MVSDSO41_SD004 (Snapshot to be invoiced).

Page tree

Jose-Ignacio Patino

All GBUs or by GBU.