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 Order Lines Table

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

Sales order lines are the itemized lines that make up a sales order. This information is stored in the IA_SALES_ORDLNS table.

By default, only booked orders are extracted from the SAP R/3 source system as shown in Figure 52. Therefore, all orders loaded into the Sales Order Lines and Bookings tables are flagged as booked (EXT_BOOKING_FLAG = 'Y').

Figure 52. SAP R/3: Default Configuration for Loading Booked Orders

In SAP R/3, the booking flag (EXT_BOOKING_FLAG) is calculated by EXT_SD_DOC_CATEGORY expression. The source for the EXT_SD_DOC_CATEGORY expression is VBAK-VBTYP. The following code is the preconfigured expression for EXT_BOOKING_FLAG:

IIF(EXT_SD_DOC_CATEGORY = 'C' OR

EXT_SD_DOC_CATEGORY = 'H' OR

EXT_SD_DOC_CATEGORY = 'L' OR

EXT_SD_DOC_CATEGORY = 'K','Y','N')

Using this code, only sales orders in the C, H, L, and K categories are booked and extracted. If you need to extract other document categories, you can change the expression in the MPLT_SAS_SALES_ORDLNS mapplet.

To configure the booking flag calculation in the Sales Order Lines table

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

   The Edit Transformation dialog box is displayed

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