You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »

Reporting Coordinator

Diogo Paiva
 IS OtC Reporting Coordinator

D&PS Expert

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.

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels