Diogo Paiva


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




  

Details

Definition

Exchange rateSourceReference Date
Y-1 M
Last year
CAR 3
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
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):
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
CAR 4
Monthly forecast rate
M+2
Orders to be invoiced on M+2
M+3
Orders to be invoiced on M+3

To be invoiced date Rule*

Open orders with item category = TAS "Third Party Item" are excluded from the open orders and shipped not billed because they do not generate delivery documents, but a PO to an external vendor instead. Since vendor is in charge of the transport, we cannot estimate the goods issue/invoicing date for these orders. However they will appear in the “invoiced” section as soon as they are billed.


 
KPI
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.