2.0 Business Process

---

3.0 Application Feature Overview

---

Similar to order book, Historical data reports included in the global sales folder in BW are categorized in three main folders as below. 

For more details about sales order and purchase orders (transfers), refers to Functional Documentation- Orderbook. The same rules applies to historical data reports. 

1) PO folder 

Related to Purchase Orders (transfers): it is about moving of orders from one plant to another, mainly called stock transfers. There are two types:

a) internal that involves moving orders from one plant to another within the same company (UB document in SAP).

b) intercompany that involves moving orders from one plant to another, but in this case, the plants belong to different companies under the Solvay umbrella (NB document in SAP).

	Detailed		Technical name
PO → Sales orders	✓	Historical Data: PO's transfer deliveries (Detailed)	BE_WBK_MVSDSO43_SD001
	✓	Historical Data: PO's transfer invoices (Detailed)	BE_WBK_MVSDSO43_SD003
	✓	Historical Data: PO's transfer orders (Detailed)	BE_WBK_MVSDSO43_SD002
	×	Historical Data: PO's transfer deliveries	BE_WBK_MVSDSO42_SD001
	×	Historical Data: PO's transfer invoices	BE_WBK_MVSDSO42_SD003
	×	Historical Data: PO's transfer orders	BE_WBK_MVSDSO42_SD002

2) SO folder

Related to Sales Orders: it is about sales order documents placed in SAP/PF1 system. These reports include sales orders which are Invoiced within the reporting period, Open (planned to be invoiced by the end of reporting period), Shipped but not yet billed (this includes items that have left as planned and are on the way to the customer; the invoicing timing may vary depending on the agreed incoterms). It covers: 

• Sales orders
• Schedule lines
• Delivery
• Shipment
• Billing

Sales documents types: All the sales documents types are in the historic. A sales order line can be in one of the categories below:

• Sales
• Return
• Consignment
• Credit/Debit memo

This concept of categories isn't standard. It was created for Global Sales.

All the delivery types are in the historic. Nothing is done to group the delivery type.

All the billing document types are in the historic. Regarding the billing document type, a billing line can be in one of the categories below:

• Sales
• Pro Format
• Inter-company

This concept of categories isn't standard. It was created for Global Sales. 

	Detailed		Technical name
SO→ Sales orders	✓	Historical Data: Deliveries (Detailed)	BW_WBK_MVSDSO45_DS0002
	✓	Historical Data: Deliveries in EU Proof of reception	BW_WBK_CPSDSO54_DS0009
	✓	Historical Data: Invoices (Detailed)	BW_WBK_MVSDSO45_DS0001
	✓	Historical Data: Invoices (Document Flow Detailed)	BW_WBK_MVSDSO45_DS0005
	✓	Historical Data: Invoices (Document Flow)	BW_WBK_MVSDSO45_DS0006
	✓	Historical Data: PO's transfer orders (Detailed)	BW_WBK_MVSDSO43_DS002
	✓	Historical Data: Sales Order (Detailed)	BW_WBK_MVSDSO45_DS0003
	✓	Historical Data: Sales Order (Document Flow) by Last Req GI	BW_WBK_MVSDSO45_DS0008
	✓	Historical Data: Sales Order (Last Req. GI date)	BW_WBK_MVSDSO45_DS0007
	✓	Historical Data: Schedule line (Detailed)	BW_WBK_MVSDSO45_DS0004
	×	Historical Data: Sales deliveries	BW_WBK_MVSDSO44_DS0001
	×	Historical Data: Sales invoices	BW_WBK_MVSDSO44_DS0003
	×	Historical Data: Sales Invoices YTD-previous month	BW_WBK_MVSDSO44_DS0003B
	×	Historical Data: Sales orders	BW_WBK_MVSDSO44_DS0002
	×	Historical Data: Sales overview	BW_WBK_MVSDSO44_DS0004

3) PO + SO (includes both)

For more details about sales order and purchase orders (transfers), refers to Functional Documentation- Orderbook

	Detailed		Technical name
SO+PO	✓	Historical Data: Corporate Trade (SO+PO)	BE_WBK_MVSDSO53_001
	✓	Historical Data: Corporate Trade by Actual GI (SO+PO)	BE_WBK_MVSDSO53_002
	✓	Historical Data: Deliveries SO/PO (Detailed)	BE_WBK_MVSDSO57_0002
	✓	Historical Data: Invoice Document Flow by Creation date (SO&	BE_WBK_MVSDSO57_0005
	✓	Historical Data: Invoices SO/PO (Detailed)	BE_WBK_MVSDSO57_0001
	✓	Historical Data: Orders SO/PO (Detailed)	BE_WBK_MVSDSO57_0003
	✓	Historical Data: Sales & Transfer Order by Last Req. GI date	BE_WBK_MVSDSO57_0007
	✓	Historical Data -  Sales & Purchase deliveries overview	BE_WBK_MVSDSO56_0005
	✓	Historical Data: Consignments Overview	BE_WBK_MVSDSO44_SD0006
	✓	Historical Data: Sales & Purchase deliveries	BE_WBK_MVSDSO56_0001
	✓	Historical Data: Sales & Purchase Invoices	BE_WBK_MVSDSO56_0003
	✓	Historical Data: Sales & Purchase Orders	BE_WBK_MVSDSO56_0002
	✓	Historical Data: Sales & Purchase Overview	BE_WBK_MVSDSO56_0004
	✓	Historical Data: Sales Order blocks analysis	BE_KPI_SD001
	×	Historical Data: eCommerce	BE_WBK_MVSDSO44_SD0007
	×	Historical Data: eInvoicing	BE_WBK_MVSDSO44_SD0008
	×	Historical Data: Invoices vs Transport.Costs (SO/PO)	BE_WBK_MVSDSO65_0007
	×	Historical Data: Manual Pricing	BE_WBK_MVSDSO44_SD0005
	×	Historical Data: SESSI and NAF codes	BE_WBK_MVSDSO44_SD0010

4.0 Functional Specification

---

4.1 General Data/Calculations 

4.2 Process Detail 

Historical data in the global sales folder of  BW include more than 40 workbooks that provide overview on sales orders and purchased orders at detailed as well as aggregated level. The reports cover historical data over the last 3 years generated in SAP (Current Year + 2 Previous Years)

There are both aggregated and detailed categories of reports that draw from a single source of data from BW, providing similar insights but at different levels of granularity.

The detailed reports provide the finest level of granularity, offering in-depth information on sales orders, order lines, and even schedule lines. Conversely, the aggregated reports take a different approach by summarizing data based on regions or other factors, without going into transactional-level details.

Both type of reports are based on the same prompt BW. It's important to clarify that the month in the report corresponds to the month of the document's creation date, which is indicated in the title of the reports. For example, when a user opens a report on 'Sales Order Invoiced' and specifies 'OCT' in the prompt, the report includes sales orders for which the invoice documents have been created in October.

4.2.1.  Report/Process Definition 

Aggregated Queries: results at customer/material finest level

eCommerce

eInvoicing

Invoices vs. Transport cost (SO/PO): This report shows transport costs (accruals coming from TIERS) based on a sales axis reporting

Detailed Queries: results at the document number finest level

From Aggregated to Detailed Queries: JUMP queries

Manual Pricing: available at both detailed and aggregated level reports

General rules on all reports: 

• For billings without goods movement the quantity is forced to zero (WP1).

IMPORTANT: Rule not applied in PF1

• Filter objects 

Example: Some Material Types (services and packaging) are excluded from Order book, but not from Historical Data. These materials will never be converted to weight units of measure (TO, KG, LB,...). If you wish to remove those Material types (PF1/Z703, WP1/ZDIE, WP1/ZVER) you have 2 options: 

Example: Some Material Types (services and packaging) are excluded from Order book, but not from Historical Data. These materials will never be converted to weight units of measure (TO, KG, LB,...). If you wish to remove those Material types (PF1/Z703, WP1/ZDIE, WP1/ZVER) you have 2 options: 

Exchange rate method

Document type	Exchange rate
Sales Order	Exchange rate from the day the sales document was created
Open Order	Current Month: average monthly exchange rate M+1, M+2, M>2: forecasted exchange rate defined in BFC
Invoiced values	Exchange rate from the day the billing document was created
Order/Invoiced values in Reference Currency (CR)	The rate coming from the ERP:     Based on the billing date for the invoiced value     Based on the sales item creation date for order line value

INDEXES
PUQ	Unit prompt quantity. It is the unit quantity chosen when the report is refreshed. Can be: KG, VKG, TO...
CP	Prompt Currency. It is the currency chosen when the report is refreshed. Can be USD, EUR, BRL...
CO	Order Currency. It is the currency which the sales order was placed.
CR	Reference Currency. It is the currency of the legal company responsible for the sales.

4.2.2. KPI's/Calculations/Indicators 

Key figures for manual pricing 

Manual Pricing: Percentage of items with manual pricing

TOTAL of billing item: Total of billing items in the perimeter

ASP Gross Sales: Average Sales Price Gross Sales = Invoiced Gross Sales / Invoiced QTY

Credit memo: Credit memo(s) issued to the customer referring to previously invoiced order

Debit memo: Debit memo(s) issued to the customer referring to previously invoiced order

ASP Net Sales: Average Sales Price Net Sales = Invoiced Net Sales / Invoiced QTY

5.0 Non-functional Descriptions 

5.1 Usability

5.2 Regulatory Compliance

5.3 Security

5.4 Performance

5.5 Reliability

5.6 Scalability

5.7 Compatibility

5.8 Availability

5.9 Refresh of the Data