Ansicht
Dokumentation

/GSINS/REU_ETL - Specify Data Transfer for BI

/GSINS/REU_ETL - Specify Data Transfer for BI

ROGBILLS - Synchronize billing plans   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

In this IMG activity, you specify the data you want to extract, transfer, and load (ETL) from Financial Accounting (FI) and/or Collections/Disbursements (FS-CD) to Business Intelligence (BI). You use this IMG activity to specify data transfer for:

  • Statistical Reporting
  • Stabilization Reserves
  • Reserves of Incurred, but not Reported Losses (IBNR)

First you enter your company code on the main Company Codes selection screen, select the row and double-click any of the sections listed below.

If you want to transfer data from Financial Accounting (FI), choose Financial Accounting Selection Rules and enter data as follows:

  • Select the FI data type you want to extract
  • Enter the G/L account number and specify whether it is debited or credited
  • Specify the currency
  • Exclude a document that contains the corresponding G/L account item

For the balance calculation, in the G/L Account Balance Calculation Rules screen, you must specify whether the G/L account you entered in the Financial Accounting Selection Rulesscreen is debited or credited, so that the system can calculate the G/L account balance properly.

If the currency is other than RUR, you need to specify the rate at which the system can calculate the G/L account value from a foreign currency to the local currency. You can enter the rate in the Legal Currency Rate screen.

In the Industry Selection screen, you enter the industry key to which your company belongs, and specify the line number where the data appears in Form 1-SKin Statistical Reporting.

If you want to transfer data from Collections/Disbursements (FS-CD), choose Collections/Disbursements (FS-CD) Selection Rules and enter data as follows:

  • Select the FS-CD data type you want to extract
  • Specify the main and sub transaction number to which the data type belongs

In Financial Accounting (FI), if you want to calculate revenues, enter data as follows in the Financial Accounting Selection Rulesscreen as follows:

FI ETL G/L Account Currency Debit/Credit Exclude G/L Account Excl. G/L Account
Claims Settlement Expenses 26000000 RUB Credit X 99000000






Fill RESBD Structure from EBP Component Structure   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 3686 Date: 20240426 Time: 233336     sap01-206 ( 49 ms )