This WIKI contains the different steps required to set up a connection between ERP Central Component (ECC) and SAP Financial Information Management (FIM).
The access to SAP ECC data can be done in three different methods:
• through SAP NetWeaver BW
• using FIM native jobs
• using Data Services connectors
This wiki highlights the second method: Direct Access to SAP ECC Using the Financial Information Management Native Jobs.
This scenario implies that you have SAP ECC 5.0 or higher.
This wiki is using the following: ECC 6.0, FIM10, UMC 4.0, IPS4.0
Activating a datasource
Before you can use the SAP ECC datasources, you need to activate the extractors on the SAP ECC end using transaction RSA5.
(This operation is to be performed by SAP ECC administrators)
Configuring drill to source
- When the source of your data is an SAP ECC, you can drill back to the source of data from the target application. From the target application, first you drill to the origin of data, and from there, you view the source of the data (redirection to a different transaction (FB03) based on the ECC extractor used).
- Only the FIM jobs whose source datastore is of SAP ECC type provide this feature.
- This Drill to Source feature is leveraging SAP Internet Transaction Server (ITS) to access SAP ECC via a web browser.
- When drill to source is enabled, the user enters the drill to source root URL, which connects to the SAP Web GUI.
(This operation is to be performed by SAP ECC administrators)
- Make sure Internet Communication Manager (ICM) is up and running. Use transaction "SMICM" and check that IMC status is “Running”.
- Make sure the Fully Qualified Domain Name is set up on the server. You can check it by calling transaction "RZ10" (Edit profiles). In Extended Maintenance, check the value of parameter icm/host_name_full.
- Set "INTERNAL" as the publishing site: Start transaction "SE80". In the top menu choose "Utilities(M)" --> "settings...". In tab "Internet Transaction Server", select "Publish" and make sure that "Integrated ITS" is selected.
- Start transaction "SE80". Choose "Internet Service" from the first drop down box located in the middle of the left side pane. Enter "SYSTEM" in the input field below and click the button "display" next to it. You will see the ITS service SYSTEM and its components in a tree structure. Right click on "SYSTEM" in the tree and select "Publish" --> "Complete Service" to publish the service. Once the publishing is completed the system will issue a message "Object published successfully; site INTERNAL".
- Repeat the previous step with "SHUFFLER" and "WEBGUI" instead of "SYSTEM" to publish both, too.
- Set missing parameters: Execute transaction "SICF". Enter "Hierarchy Type" = "SERVICE ", then click on checkmark "execute (F8)".
Now browse to "default-host" -> "sap" -> "bc" -> "gui" ->"sap" -> "its" -> "webgui". Right-click on it and choose "Display Service".
Under tab "Service Data" inside chapter "Interactive Options" click on button "GUI Configuration".
In the blank line, insert following parameter: Parameter Name: "~webgui_theme" Value: "sl"
- Clear cache:
Execute transaction "SITSPMON". Select tab "Template and Mimes tab". Under tabs "Invalidate Template Caches" and "Invalidate MIME Cache", click on "System-wide"
- Test WebGUI:
Execute transaction "SICF". Enter "Hierarchy Type" = "SERVICE", then click on checkmark "execute (F8)". Now browse to "default-host" -> "sap" -> "bc" -> "gui" ->"sap" -> "its" -> "webgui". Right-click on it and choose "Test Service".
A browser window (Internet explorer) pops up with the URL http://mybackend.project.mycompany.intra:8002/sap/bc/gui/sap/its/webgui?sap-client=100. It asks for username and password. Enter your credentials that you used for SAP-Logon. Then you should see a screen similar to the initial SAP-Logon screen: a screen titled "SAP Easy Access" with the SAP menu.
FIM Administration Console Configuration
When using SAP ECC as a source to extract data, you need to configure the related ECC parameters under FIM Administration Console :
The parameters are the following:
- ABAP Execute option : This option defines how the ABAP programs will be executed. You may choose between:
GenerateAndExecute : only used in SAP development environments
ExecutePreloaded: in other environments
- Generated ABAP folder : local folder to the DataServices Job server machine where the ABAP code will be generated
Data transfer methods
When you configure SAP Applications datastores in Data Services, you specify the data transfer method. This method defines how data that is extracted by the ABAP running on the SAP application server becomes available to the Data Services server (the computer on which the Data Services Job Server runs). The options are:
- Direct download: The SAP server transfers the data directly to the Local directory using the SAP-provided function GUI_DOWNLOAD or WS_DOWNLOAD.
- Shared directory: Default method. The SAP server loads the transport file into the Working directory on SAP server. The file is read using the Application path to the shared directory from the Job Server computer.
- FTP: The SAP server loads the Working directory on SAP server with the transport file. Then the Job Server calls an FTP program and connects to the SAP server to download the file to the Local directory.
Creating an ECC Datastore
The connection to SAP ECC does not require the Single Sign On session. FIM users will extract data from SAP ECC using the SAP credentials defined in the datastore.
Here are the steps required to create an SAP ECC datastore:
- On the "Home" page, under "List of Datastores", click New.
- Under "Datastore type" select "SAP ECC".
- Click Next.
- In the "Application server" box type the name of the application server to which you want to connect.
Enter the following:
• Client number
• System number
- Select the "data transfer method".
- Enable the drill to source feature.
- Test the datastore then save it.
ECC as a Source system in FIM
An SAP ECC datastore can be used to extract data from SAP ECC and not to import data into SAP ECC.
When you select SAP ECC as a source of data in the financial information management application, you see the list of activated datastores from which you select one:
The datasources supported by default with the financial information management application are as follows:
- 0FI_GL_10 - Interface to New General Ledger, data from Leading Ledger
- 0FI_GL_20 - Interface to New General Ledger, data from all ledgers
- 0FI_AP_4 - Interface to Accounts Payable
- 0FI_AP_30 - Interface to Accounts Payable
- 0FI_AR_4 - Interface to Accounts Receivable
- 0FI_AR_30 - Interface to Accounts Receivable
- 0EC_PCA_1 - Interface to Profit Center Accounting
- 0CO_OM_CCA_3 - Interface to Cost Center Accounting
- 0CO_OM_CCA_4 - Interface to Cost Center Accounting
- 0CO_OM_CCA_9 - Interface to Cost Center Accounting
- 0CO_OM_ABC_2 - Interface to Activity Based Costing
- 0CO_PA_1 - Interface to Profitability Analysis
The available ECC datasources and their drill-to-source definitions are declared in the sap-eccmetadata.csv file located in the following folder: <fim install directory>\WEB-INF\.
The datasource to CO-PA does not appear in the list of available datasources by default. You must add this datasource.
- It is possible to enrich this list by modifying the sap-ecc-metadata.csv file. The procedure is detailed in the FIM Administration Guide.
SAP Note 1809042 - FIM: What is the list ECC datasources supported by default with FIM?
Online documentation for Data Acquisition from ECC - Step-By-Step BW Connectivity