Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Extract, Transform, and Load for SAP R/3 >
Siebel General Ledger Analytics Information for Nonsales Transactions for SAP R/3
Loading transaction information other than sales is handled in the same fashion as sales order lines and invoice lines data. All the transactions from
TS_STAGE_GL that do not exist in
TS_STAGE_IV_HDR are selected. Also the tables
TS_STAGE_GL join to get the keys, split the transactions and set the Balance ID. In addition, a lookup is performed on the
TS_STAGE_FIN_STMT staging table. Data then loads into the six staging areas.