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 >

Accounting for Negative Values in Orders, Invoices, and Picks

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

The Siebel Customer-Centric Enterprise Warehouse is preconfigured not to use negative values in the quantity or amount columns for the IA_SALES_IVCLNS or IA_SALES_ORDLNS tables. These two columns are preconfigured with a value of 1.0. However, you can change these values to negative values by using the VAR_NEGATIVE_SIGN and VAR_NEGATIVE_SIGN_QTY columns.

For example, to account for a negative value for the BV and ZUN document types, you can use the following conditional statement to define the VAR_NEGATIVE_SIGN and VAR_NEGATIVE_SIGN_QTY columns:

IIF(EXT_DOCUMENT_TYPE = 'BV' OR

EXT_DOCUMENT_TYPE = 'ZUN' , -1.0, 1.0)

To configure mapplets to account for negative values

1. Open Designer, and open the Configuration for SAP R/3 folder.
2. Open the applicable Source Adapter mapplet.
3. Double-click the Expression transformation to open the Edit Transformation box.
4. In the Ports tab, edit the VAR_NEGATIVE_SIGN and the VAR_NEGATIVE_SSIGN_QTY ports.
5. Validate and save your changes to the repository.