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 Order Types for Backlog Calculations

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

The BACKLOG_FLAG in the IA_SALES_ORDLNS table is also used to identify which sales orders are eligible for backlog calculations. The BACKLOG_FLAG value is derived from the Sales Document Category.

You can add or remove Sales Orders types. Valid values for the Backlog Flag are Y and N. The following code is the preconfigured expression for the backlog calculation:

IIF(ISNULL(EXT_REJECTION_CODE),

IIF(EXT_SD_DOC_CATEGORY = 'C' OR

EXT_SD_DOC_CATEGORY = 'E' OR

EXT_SD_DOC_CATEGORY = 'F' OR

EXT_SD_DOC_CATEGORY = 'G' OR

EXT_SD_DOC_CATEGORY = 'H' OR

EXT_SD_DOC_CATEGORY = 'I',

IIF(DOC_DELIVERY_FLAG = 'Y' AND ITEM_DELIVERY_FLAG = 'Y', 'Y', 'N'), 'N'), 'N')

To edit the Backlog flag

1. Open Designer, and open the Configuration for SAP R/3 folder.
2. Open the MPLT_SAS_SALES_ORDLNS mapplet.
3. Open the Expression transformation EXP_SALES_ORDLNS in the MPLT_SALES_ORDLNS mapplet to edit the Backlog Flag port.
4. Modify the statement in the BACKLOG_FLAG port.
5. Repeat Step 2 through to Step 4, for the EXP_SALES_SCHLNS expression in the MPLT_SALES_SCHLNS mapplet.
6. Validate the expression, and save your changes to the repository.