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

Compare with Current View Page History

« Previous Version 15 Next »

Reporting Coordinator

Sandra Silveira
 IS OtC Reporting Coordinator

D&PS Expert

Miriam Luttrin

General Description

The Order Book tab is an excellent place to get details of your daily order book. It is divided into two tabs: Orderbook Highlights and Orderbook Report.
Orderbook Highlights has pre-generated tables and graphs that will give you information on your Orderbook status, such as Invoiced vs Open Orders, last months actuals, Forecasting (if available from your GBU), and your Orderbook ASP (Average Sales Price) trend. The section at the bottom of this page will give you a the details of your order book for the current month and up to 3 future months.
Data on Orderbook is from OBAS BW Cube.

 

  
BFR
BFR is provided by the GBU and uses the latest version, updated quarterly and provided directly by the GBUs. The different versions are based on quarter: BFR03, BFR06, BFR09
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

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

 

Not able to find the solution? Contact SBS Support.

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