Diogo Paiva


EMEA: Stéphane Bourgeaud-lignot
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong



General Description

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. 

  

Details

Definition

SourceReference Date
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 (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, 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
 To be invoiced date Rule*


KPI
Revenue
Rate:
Invoiced data: CAR 3
Current Month and Future Months (Opens Orders) : CAR 4
For more information about CAR3 and CAR4 click here
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.