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

Configuring the Transaction Types for Siebel Financial Analytics


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

Transaction types are stored in the IA_XACT_TYPES table. For a list of domain values in the Transaction Types table, see the Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

In Siebel Financial Analytics, the transaction type of a record is determined by the following three attributes:

  • POSTING_KEY
  • ACCT_DOC_TYPE_CODE
  • SPECIAL_G_L_INDICATOR

You can configure the transaction type by editing the xact_type_code_sap.csv file. Table 66 shows a sample layout of the xact_type_code_sap.csv file.

In Table 66, an accounting document item with a POSTING_KEY equal to 1, an ACCT_DOC_TYPE_CODE equal to AA, and a SPECIAL_G_L_INDICATOR with no value, appears in the Siebel Customer-Centric Enterprise Warehouse as an Invoice record.

Table 66. Sample Layout of xact_type_code_sap.csv File
POSTING_KEY
ACCT_DOC_TYPE_ CODE
SPECIAL_G_L_INDICATOR
IA_XACT_ TYPE_ CODE
IA_XACT_ STYPE_ CODE
XACT_CODE
SOURCE_ID

1

AA

 

ORIGINAL

INVOICE

RECEIVABLE

SAPR3

1

DA

 

ORIGINAL

INVOICE

RECEIVABLE

SAPR3

1

DR

 

ORIGINAL

INVOICE

RECEIVABLE

SAPR3

1

RV

 

ORIGINAL

INVOICE

RECEIVABLE

SAPR3

1

SA

 

ORIGINAL

INVOICE

RECEIVABLE

SAPR3

1

DA

 

ORIGINAL

CR MEMO

RECEIVABLE

SAPR3

1

AB

 

ORIGINAL

OTHER

RECEIVABLE

SAPR3

To configure the transaction types

  1. Open the xact_type_code_sap.csv file in the $pmserver\srcfiles folder.
  2. Insert your transaction types.

    For a list of domain values in the Transaction Types table, see the Siebel Customer-Centric Enterprise Warehouse Data Model Reference.

  3. Save and close the file.
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide