Combined Transaction Processing and Reporting Benchmark - Benchmarking Transaction and Analytical Processing Systems - page 72

Order header:
Selection from
Customer data on customer ID
Customer sales data on customer ID
Customer partner function on customer ID, division,
sales organization, distribution channel
Address data on address ID
One row insertion into sales header
For each line item:
Selection from
Product data on product ID
Product description on product ID
Product sales data on product ID
One row insertion into sales item
Optional insertion into sales business data
For each specified role:
One row insertion into business partner

Listing 4.1 Transaction profile for sales order transaction

For each sales order line item, the ordered product and the order quantity
have to be entered. To complete the sales order, a sales order number is assigned
automatically, the creation date is saved, and the default value for a delivery date,
e.g., the next business day after the sales order has been created if no other date has
been specified, is inserted.
The transaction profile for creating a new sales order is shown in Listing 4.1 .
It includes the selection of context data from the customer and product master data
tables, the creation of a new row for the order in the sales header table and the
creation of a row for each ordered item in the order item table. Business partner
data about the parties taking part in this transaction and optional information per
sales item about the sales process, for example, customer group, pricing conditions,
means of transport, or rebate can be stored as well.

Create Shipping Document

Shipping documents can either be created automatically based on sales orders (one-
to-one relationship) or manually. If created manually, a check against the sales order
tables has to succeed, that all items to be delivered have been ordered beforehand
and are sent to the same receiving party. Line items in a shipping document may
have been ordered in different sales orders. Therefore, a reference is inserted to the
according sales document line item in the shipping item table.
The transaction profile for the shipping transaction is shown in Listing 4.2 .
The transaction comprises selecting context data from the sales item table and
inserting new data into the shipping header and shipping item tables.