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 Sales Invoice Extract

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

Sales invoice lines are payments for items ordered by a customer. This information is stored in the IA_SALES_IVCLNS table. This topic describes how to modify the type of information stored in this table.

By default, the Siebel Enterprise Sales Analytics application is configured to extract completed sales invoices when performing the Sales Invoice data extract. In SAP R/3, the VBRK-RFBSK = 'C' filter completes an invoice.

To extract incomplete sales invoices, and complete invoices, remove the extract filter statement.

To remove the extract filter for sales invoices

1. Open Designer, and open the Configuration for SAP R/3 folder.
2. Open a Sales Invoice Lines Business Component mapplet. Modify both the regular extract mapplet (MPLT_BCS_SALES_IVCLNS) and the primary extract mapplet (MPLT_BCS_SALES_IVCLNS_PRIMARY), and the partner extract mapplet (MPLT_BCS_STAGE_SALES_IVCLNS_PARTNER).
3. Open the Source Qualifier and click the Property tab
4. Remove the VBRK-RFBSK = 'C' filter.
5. Validate and save your changes to the repository.