1 person found this helpful
just to confirm how the integration process works with SAP integration.
When you integrate SAP with FDMEE data will be extracted to a flat file in shared folder called FSMOUNT (typically located in the FDMEE server). The extract process is basically an ABAP program executed by ODI Agent. Then the ODI agent will take this file and import into FDMEE. Shared folder must be declared in SAP (Transaction AL11)
You need to ensure that the shared folder must be accessible from the SAP system using the <sid>adm user and from the operating system user that starts the ODI agent.
In the ODI Topology, you will have to configure Data Serve "FDMEE _SAP_FSMOUNT" to point the shared folder.
Regarding drill through, FDMEE will open the drill through url you configure in FDMEE depending on your requirements. You will have to enable ITS Server Version 6.2 or higher (Internet Transaction Server) so you can navigate your SAP instance through the web. FDMEE source adapter for SAP comes with some predefined drill through urls (including parameters) based on the SAP module you integrate.
I hope that clarifies.
Correct me if I am wrong, the pre-built SAP adapter which comes with FDMEE is for SAP BW and not for SAP G/L. Does this adapter also provides the ability to drill through to transactional data ?
FDMEE supports both SAP ECC 4.6+ / R3 (ERP Financials) and SAP BW.
So you can integrate SAP GL modules (NEWGL and Classic GL) and others:
- General Ledger
- Profit Center
- Cost Center
- Vendor Balances
- Customer Balances
For SAP BW, it extracts data from standard as well as custom infocubes.
Integration includes data load and drill through for all SAP integration.