Versions Compared

Old Version 13

changes.mady.by.user Kyle Amlung

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.


Info
iconfalse
titleReporting Coordinator
Sandra Silveira
Diogo Paiva
 IS OtC Reporting Coordinator


Info
iconfalse
titleD&PS Expert
Miriam Luttrin



General Description

The Order Book
tab
section is an excellent place to get details of your daily order book.
Data on Orderbook is from OBAS BW Cube.

 

  
BFR
BFR is provided by the GBU and uses the latest version, updated quarterly: BFR03, BFR06, BFR09 etc.
Budget
Budget is provided by the GBU and is static for the year.
It is divided into two tabs: Orderbook Highlights and Orderbook Report. Highlights is a great place to get a general view of your orderbook. 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]

Sources

Orderbook

 

Core query
PF1:

BW_QRY_MVSDSO01_SD004
BW_QRY_MVSDSO07_001 

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)
QVSDQVSBS_BW_QRY_MVSDSO07MVCOPA01_001 (PO Orders for "invoiced" current month)0004 (Invoiced P&L)

 

WP1:

ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 [in Qlikview Folder](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_ORDER BOOK PPE (LAST YEAR - LAST MONTH - INVOICES) CWWPPE_004

 

_SALES RESULTS_CWWPPE_R002 (NON ERP) (Invoiced)

Refresh frequency
Daily

 

 

  

Specific Dimensions

  • .............
  • .............
  • .............
  • .............
  • .............
  • .............

Scope

  • .............

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