Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics > Process of Configuring Siebel Enterprise Sales Analytics for SAP R/3 >

Configuring the Booking Flag Calculation in the Sales Schedule Lines Level

This task is a step in the Process of Configuring Siebel Enterprise Sales Analytics for SAP R/3.

Sales schedule lines detail when each order's items are slated for shipment. Each sales order is broken into sales order lines, and each sales order line can have multiple schedule lines.

For example, you might not have enough stock to fulfill a particular sales order line, therefore you create two schedules to fulfill it. One schedule ships what you currently have in stock, and the other schedule includes enough time for you to manufacture and ship the remaining items of the sales order line. This information is stored in the IA_SALES_SCHLNS table. This topic describes how to modify the type of information stored in this table.

About Loading Bookings at the Schedule Line Level

As initially configured for SAP R/3, bookings are recorded at the Sales Order Line level and the Sales Schedule Line level. For both book levels, the EXT_BOOKING_FLAG is set based on EXT_SD_DOC_CATEGORY. Sales document categories are booked at the Sales Order Line level or the Sales Schedule Line level. Figure 53 shows bookings recorded at the Sales Order Line level.

Figure 53. SAP R/3: Bookings at the Sales Order Line Level

Bookings recorded at the Sales Schedule Line level provide a more granular view, as the orders are segmented by schedule line. Bookings recorded at the Schedule Line level provide one row in the Bookings table for each schedule line, as shown in Figure 54.

Figure 54. SAP R/3i: Bookings at the Schedule Line Level

There are booking flags in the Sales Order Lines Source Adapter and Sales Schedule Lines Source Adapter mapplets. The EXT_BOOKING_FLAG expression in the Sales Schedule Lines level is preconfigured as follows:

IIF(EXP_SD_DOC_CATEGORY = 'E' OR

EXP_SD_DOC_CATEGORY = 'F', 'Y','N')

To configure bookings at the sales schedule lines level

1. Open Designer, and open the Configuration for SAP R/3 folder.
2. Expand the MPLT_SAS_SALES_SCHLNS mapplet.
3. Double-click the EXP_SALES_SCHLNS expression transformation

   The Edit Transformation dialog box is displayed

4. Click the Ports tab
5. Edit the EXT_BOOKING_FLAG expression.
6. Validate and save your changes to the repository.