2.0 Business Process

From a business perspective, the Orderbook provides users with estimated expected results in terms of sales for various timeframes: The current month, The month following the current month (M+1), Two months ahead (M+2), and Starting from the third month ahead (M+3 onwards).

These estimates encompass includes both quantity and turnover, allowing users to have a view of sales in these timeframes.

when The process begins with a customer service creating an order has been created in SAP, there are multiple steps that comes afterwards . This initial order document undergoes a series of steps, each managed by different teams . Custtomer service create it in the sap and then logistic teams creating a delivery document in reference to that order to plan the packing, the picking,..preparation at the plant to prepare the transport. Then another team that are involved in planning  the transport. They creat the shipment document related to the delivery document. There is chain of documents created one after another by various teams. The order book is looking into these documents to find out what is the best estimated invoiced date based on the most 

The reports include orders that fall into various categories:

1. Invoiced in the current month.
2. Open (planned to be invoiced by the end of this month).
3. 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).

at various points in time. For example, following the creation of the order document, the logistics team generates a delivery document related to the order. This step includes tasks such as planning for packing and picking, as well as any necessary preparations at the plant for transport. Subsequently, another team responsible for transport planning gets involved. They generate a shipment document that is related to the previously created delivery document. Consequently, a chain of documents is established, with each document following the other in sequence, each managed by different teams.

The Orderbook utilizes these documents to determine the best estimated invoicing date or the most accurate estimation for when the product will leave the plant. This determination is based on the most up-to-date and relevant information obtained from the interconnected documents.

It's important to note that these reports are highly dynamic due to the nature of our business processes. Orders can change, which It's important to note that these reports are highly dynamic due to the nature of our business processes. Orders can change, which impacts the results from one day to another. Therefore, the reports are loaded on a daily basis. As a result, we do not retain historical data, and we provide only snapshots based on new data loaded from SAP to BW.

3.0 Application Feature Overview

Orderbook reports included in the global sales folder in BW are categorized in three main folders as below. 

1) SO folder

Related to Sales Orders: sales orders it is about sales order documents placed in SAP/PF1 system, being possible to determine

Related to Sales Orders (transfers): 

2) PO folder 

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

2) PO folder 

Related to Purchase Orders (transfers): it is about moving of orders from Related to Purchase Orders (transfers): it is about orders that aremoved 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). 2) 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).

3) PO + SO (includes both)

For more details about sales order and purchase orders (transfers) see the links below. 

Sales Order

Purchase Order (Transfers)

4.0 Functional Specification

4.1 General Data/Calculations 

4.2 Process Detail 

The "Sales and Distributions" folder within BW BW includes a folder called sales and distributions that contains 14 workbooks, all related to orderbook data. The reports includes These reports can be categorized into two main categories, namely, : "To be Invoiced" and "To be Issued. The first one "

1. To be Invoiced:

   • This category provides the best estimation

1. • of incoming results expected by the end of the

1. • current month and for

1. • future months

1. • .
   • It is based on the sales orders placed

1. • in the SAP system

1. • .
   • For each sales order, it determines the expected date

1. • for invoicing, also known as the billing date

1. • .

2. To be Issued:

   • This category is primarily intended for

1. • the supply chain team

1. • .
   • It offers the best estimation

1. • of deliveries to be issued by the end of the

1. • current month and for

1. • upcoming months

1. • .
   • It determines the expected date

1. • for issuing these deliveries or provides the best estimation of when the product will leave the plant

1. • .

4.2.1.  Report/Process Definition

The details of the two main flows of the orderbook are as follows: 

Orderbook: To be invoiced

Orderbook:

Sales document used in the reports 

INVOICED

B1

Reb.Credit Memo Req.

RE

RE Returns

ZDRB

Debit Memo Req. BR

B2

Rebate Correctn Rqst

REA

REA Returns-AR

ZITI

Sales Order ITI BR

B3

PartRebSettl.Request

SB

SB Third-p.dir order

ZORB

Standard Order BR

B4

Reb.Req.f.Man.Accrls

SO

SO Rush Order

ZOUT

Other Outputs BR

CR

CR Credit Memo Req.

TA

Standard Order

ZPVA

ZPVA Ord.immed.ship.

CRV

CRV Credit Mem Value

TAF

Standard Order (FPl)

ZRCM

Sales Accnt/Order BR

DR

DR Debit Memo Req.

TAM

Delivery Order

ZREN

Returns NFe Custo BR

DRV

DRV Debit Memo Value

TAV

Standard Order (VMI)

ZROB

Own NFe Returns BR

KE

KE Consignment Issue

TD

TD Standard Order

ZSAM

Sample Order BR

KR

KR Consign. Returns

TSA

Telesales

ZTDL

ZTDL StdOrder w/o GI

R1

R1 Fictive Return

ZCRB

Credit Memo Req. BR

R4

R4 Returns free ch.

ZDON

Donation Order BR

OPEN ORDERS AND SHIPPED NOT INVOICED

KB

KB Consign. Fill-up

ZITI

Sales Order ITI BR

KBCC

KBCC CC Consign.Sto.

ZORB

Standard Order BR

SB

SB Third-p.dir order

ZOUT

Other Outputs BR

SO

SO Rush Order

ZPVA

ZPVA Ord.immed.ship.

TA

Standard Order

ZRCM

Sales Accnt/Order BR

TAF

Standard Order (FPl)

ZSAM

Sample Order BR

TAM

Delivery Order

ZTDL

ZTDL StdOrder w/o GI

TAV

Standard Order (VMI)

ZVEX

Fut. Dely Invoice BR

TD

TD Standard Order

ZVEY

Fut. Dely Shipmnt BR

TSA

Telesales

ZVNO

Del N/Prod(w/o acct)

ZDON

Donation Order BR

ZVNP

Non Product Order BR

Indexes 

with Contribution Margin→ The Order Book with contribution margin (integrated or standard) is provided for theTo Be Invoiced part, for the shipped not billed part and for the open order. You can find here details on the rules and calculations applied on the report.

Orderbook: To Be Recognized→ It is initially requested by technology solution to see the sales result from financial perspective (not sales perspective). For that, when a sales order is delivered to the customer considered for revenue.  There are criteria to consider a sale order as a recognized sales order to generate the report. 

Orderbook: To be issued

Indexes 

Gross Sales and Net Sales 

The Gross sales value is available for the order line and for the billing line. Regarding the pricing conditions of each documents, the value corresponds to the basic price.
To determine the Gross sales we follow the rules below:
    From the pricing conditions, considers the condition type which is in the condition class “B” (price).
    The condition price must have an Account type.
    The condition price cannot be a statistical condition.
    The condition must to be active.

The Net sales is available for the order line and for the billing line. Regarding the pricing condition of each documents, the Net sales is calculated according to the following formula:
    Net Sales = Gross Sales + Discounts&Surcharges + Rebates
    NOTE: Commissions are not considered

More detail is available in: Gross Sales & Net Sales 

Exchange Rate Method

4.2.2. KPI's/Calculations/Indicators 

4.2.2. KPI's/Calculations/Indicators 

5.0 Non-functional Descriptions