Reporting Coordinator

Diogo Paiva
 IS OtC Reporting Coordinator

D&PS Expert

Miriam Luttrin

General Description

The Order Book section is an excellent place to get details of your daily order book. It is divided into two tabs: Orderbook Highlights and Orderbook Report. Highlights is a great place to get a general view of your orderbook. The report tab can be used to build your own report for the data you need. '

Details on Indicators:

Current month Detailed Split:
  1. Invoiced- Orders based on the shipment start or completions date based on incoterms
  2. Ship not billed- Same as "Delivered not invoiced", pending confirmation from freight forwarder if vessel has sailed.
  3. Confirmed Open Orders- Orders not blocked by SAP (no credit blocks and capacity is available)
  4. Not confirmed open orders- Credit blocked orders or no capacity orders.

 

 

Sources

Orderbook

Core query
PF1:

SD Workbook: SNAPSHOT: Orderbook Business View (To Be Invoiced) [WBP]

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)
QVSBS_BW_QRY_MVCOPA01_0004 (Invoiced P&L)

 

WP1:

ORDER BOOK BUSINESS VIEW (TO BE INVOICED) CWWPPS_RO001 (Open Orders from BI4 - All GBUs except Novecare)

QVSBS_BW_QRY_MVCOPA01_0004 (Invoiced from P&L - All GBUs)


Specificities:

QV_NOVECARE_ORDER_BOOK_WW_NOVPPS_PPE_R001 (Open Orders from BI4 - Novecare including extrapolation)


Non-SAP:

Novecare Chemlogics - QV_SALES RESULTS_CWWPPE_R002 (NON ERP) (Invoiced)

Refresh frequency
Daily

 

 

*Note that orderbook data from PF1 does not include consolidation for Novecare.

Not able to find the solution? Contact SBS Support.

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