Copy of Orderbook

The Order Book section is an excellent place to get details of your daily order book.

In Highlight tab you are able to see a quick glimpse of your order book on the graph and easily compare your current month orderbook to future month open orders or previous month and same month of previous year actuals. Forecast is available as well for some GBUs. 

On the graph, hover your mouse over the different colored sections in order to get a pop up with the exact amount constituting that section. On the right, you can get a view of your order book by the ASP (Average Sales Price). The ASP calculation is Revenue/Volume (or price per volume unit). At the Bottom of this page is the Detailed Orderbook View table. 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 (see dimensions list below) that can be interesting to your business.You are able to see a quick glimpse of your order book on the graph and easily compare your current month orderbook to future month open orders or previous month and same month of previous year actuals. Forecast is available as well for some GBUs. On the graph, hover your mouse over the different colored sections in order to get a pop up with the exact amount constituting that section.

My Report allows you to build your own pivot table based on the available Dimensions, Indicators, and Details from their respective menus. As long as you make at least one selection from each section, a pivot table will appear based on those selections. 

Y-1 M

Last year

P&L:

QV query:
QVSBS_BW_QRY_MVCOPA01_0004

Core Query:
BW_QRY_MVCOPA01_0004

Posting date

M-1

Last month

Invoiced (M)

Orders based on the shipment start or completions date based on incoterms for current month

M

Current Month Total:
Invoiced (M) + Shipped Not Billed (M) +Confirmed Open Orders (M) + Not Confirmed Open Orders (M)

Shipped Not Billed (M)

Same as "Delivered not invoiced", pending confirmation from freight forwarder if vessel has sailed for current month

Global Sales:

QV query:
QVSD_BW_QRY_MVSDSO41_SD004 (Global Sales Orderbook)
QVSD_BW_QRY_MVSDSO47_SD001 (Global Sales PO Orders - Only WP1 data)

Core query:
BW_QRY_MVSDSO41_SD004 (Global Sales Orderbook)
BW_QRY_MVSDSO47_SD001 (Global Sales PO Orders - Only WP1 data)

BI4:
Pepol, Chemlogics, Bangpoo:
ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 

Global Sales Orderbook:
To be invoiced date*

Global Sales PO Orders:
To be issued date

Confirmed Open Orders (M)

Orders not blocked by SAP (no credit blocks and capacity is available) for current month

Not Confirmed Open Orders (M)

Delivery blocked orders and no capacity orders for current month

M+1

Orders to be invoiced on M+1

M+2

Orders to be invoiced on M+2

M+3

Orders to be invoiced on M+3

Revenue

Rate:
Invoiced data: CAR 3
Current Month and Future Months (Opens Orders) : CAR 4

Revenue (CURR)

Original Currency

Volume

VKG

ASP

Revenue/Volume

Budget

BFR

Business Finance Review

Forecast

Forecast (Volume)