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

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. 

3) PO + SO (includes both)

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

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

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

4.2.2. KPI's/Calculations/Indicators 

Key figures for manual pricing 

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