Sandra Silveira
 IS OtC Reporting Coordinator
Miriam Luttrin

General Description

The Order Book tab 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.

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

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