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.

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

CAR 3 (Y-1 M)

P&L:

QV query:
QVSBS_BW_QRY_MVCOPA01_0004

Core Query:
BW_QRY_MVCOPA01_0004

Posting date

M-1

Last month

CAR 3 (M-1)

Invoiced (M)

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

CAR 3 (M-1)

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

Daily rate of the order line creation date

Global Sales (Default):

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 (Only for Pepol, Chemlogics):
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

Monthly forecast rate (CAR4)

M+2

Orders to be invoiced on M+2

M+3

Orders to be invoiced on M+3

Revenue (CURR)

Original Currency

Volume

VKG

For more information about VKG click here

ASP

Average Sales Price = Revenue/Volume

Budget

Budget is provided by the GBU and is static for the year. Click here for more information.

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. Click here for more information.

Forecast

Click here for more information.