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

Configuring the Date Parameters for the SAP R/3 Parameter File

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

You need to set the PARM_NVALUE_1 value in the file_parameters_sapr3.csv file to the number of days that you expect your orders to be open. This configuration is necessary for ETL as SAP R/3 does not update the last changed date for a table when a user updates that table.

The PARM_NVALUE_1 value is used by the following session parameter codes:

• S_M_S_PURCH_ORDERS_EXTRACT:INCRDATE
• S_M_S_PURCH_RCPTS_EXTRACT:INCRDATE
• S_M_S_PURCH_RQLNS_EXTRACT:INCRDATE
• S_M_S_PURCH_SCHLNS_EXTRACT:INCRDATE

NOTE:  There are always orders that are open for a long period of time. To make sure that ETL captures changes to these orders, it is recommended that you occasionally set the PARM_NVALUE_1 value to a value equivalent to that period of time.

To configure the date parameters for the SAP R/3 parameter file

1. Open the file_parameters_sapr3.csv file using Microsoft WordPad or Notepad in the $pmserver\SrcFiles folder.
2. Search for the column labeled PARM_NVALUE_1.
3. Change the default date value of parameter code to the date value you require.
4. Save your file.