Sandra Silveira
 IS OtC Reporting Coordinator
Miriam Luttrin

General Description

The Orderbook Highlights is an excellent source for looking at critical analytical data on your order book. You can pivot the view of the details table to see your order book by product, Payer, ship to, plant, or one of a number of other views that can be interesting to your business. Use the cyclical button on the order book details to switch the view.
Data on Orderbook is from OBAS BW Cube.

 

Calculation 
Invoiced
..........
Shipped not billed
.......
.........
.......
  
BFR
BFR is provided by the GBU and uses the latest version, updated quarterly: BFR03, 06, 09 etc.
Budget
Budget is provided by the GBU and is static for the year.

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)
QVSD_BW_QRY_MVSDSO07_001 (PO Orders for "invoiced" current month)


WP1:

ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 [in Qlikview Folder]

QV_NOVECARE_ORDER_BOOK_WW_NOVPPS_PPE_R001

QV_ORDER BOOK PPE (LAST YEAR - LAST MONTH - INVOICES) CWWPPE_004

 
Refresh frequency
Daily
 
   

Specific Dimensions

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

Scope

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