Versions Compared

Old Version 1

changes.mady.by.user Marie-Line Ardito

Saved on

compared with

New Version Current

changes.mady.by.user Miriam Luttrin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image RemovedImage Added


Info
iconfalse
titleKPI OwnerReporting Coordinator
Diogo Paiva
 IS OtC Reporting Coordinator
François Carette
 Performance & Capex Reporting Manager - GEC


Info
iconfalse
titleD&PS Expert
Marie-Line Ardito
Miriam Luttrin



General Description

The Order Book section is an excellent place to get details of your daily order book. It is divided into two tabs: Orderbook Highlights and Orderbook Report. Highlights is a great place to get a general view of your orderbook.
............
  • ......
  • .......
  • .......
Calculation 
Invoiced
..........
Shipped not billed
.......
................  
BFR
......
Budget
.........

Sources

Orderbook

.........

Core query
......... (PF1)

........(

..........
QV query
..........
...........
Refresh frequency
..........
.........
Filters
 
.......

Specific Dimensions

  • Version : Active version (last version updated in Colmar), Y versions, Y-1 versions
  • Project type : Capitalized, Not Capitalized
  • Planned : Yes, No (Yes = the forecast amounts are taken into account in the GBU totals)
  • Bundle : list of bundles (def + key)
  • Project status : Approved (as soon as there is an authorized amount), Not Approved
  • Project approval status : Present approval status of the project
  • Project approval year : for a bundle, 1rst date of approval of the projects of the bundle

Scope

  • All the projects entered in Colmar with forecasted budget on the available versions
The report tab can be used to build your own report for the data you need. '

Details on Indicators:

Current month Detailed Split:
  1. Invoiced- Orders based on the shipment start or completions date based on incoterms
  2. Ship not billed- Same as "Delivered not invoiced", pending confirmation from freight forwarder if vessel has sailed.
  3. Confirmed Open Orders- Orders not blocked by SAP (no credit blocks and capacity is available)
  4. Not confirmed open orders- Credit blocked orders or no capacity orders.

 

 

Sources

Orderbook

Core query
PF1:

SD Workbook: SNAPSHOT: Orderbook Business View (To Be Invoiced) [WBP]

WP1:

ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001

SALES TREND & MANAGEMENT REPORT CWWPPE_R001 (for invoiced sales)

 

QV query

PF1:

QVSD_BW_QRY_MVSDSO01_SD004 (Sales Orders)
QVSBS_BW_QRY_MVCOPA01_0004 (Invoiced P&L)

 

WP1:

ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 (Open Orders from BI4 - All GBUs except Novecare)

QVSBS_BW_QRY_MVCOPA01_0004 (Invoiced from P&L - All GBUs)


Specificities:

QV_NOVECARE_ORDER_BOOK_WW_NOVPPS_PPE_R001 (Open Orders from BI4 - Novecare including extrapolation)


Non-SAP:

Novecare Chemlogics - QV_SALES RESULTS_CWWPPE_R002 (NON ERP) (Invoiced)

Refresh frequency
Daily

 

 

*Note that orderbook data from PF1 does not include consolidation for Novecare.

Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by the
GBU Capex Coordinators
Authorisations' rights per GBU, Zone or Plant
Access form