Diogo Paiva
 IS OtC Reporting Coordinator
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. The report tab can be used to build your own report for the data you need.

 

 

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)
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

 

 

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