What is required for Rapid Mart connection to SAP R/3

Hi, My client is looking to buy Rapid Mart and told me to start investigation for what all is required for Planning.
I know that Rapid Mart has everything built-in and we just need to install, configure ( using DI) and execute.
Normally when we connect to SAP R/3 using Data Integrator ( through ABAP programs) then we save ABAP programs in SAP R/3 system to generate file on C:\Temp dir of SAP server.
So my question is

  1. if we use Rapid Mart then do we need to save ABAP code in SAP R/3? I know that ABAP is best way to extract data from SAP R/3 to load into datawarehouse.

  2. I want to understand how BODI connects to SAP R/3 in Rapid Mart? Is it ABAP or RFC function call or Direct table access??

  3. Can we just install Rapid Marts and schedule job in BODI ( after some configuration) or we need to import transports in SAP and do some more at SAP side?

Any help would be greately appreciated.

Thanks,
Pandeyji


Architect2009 (BOB member since 2005-10-26)

A RapidMart is nothing else then us having developed the dataflows for your. As a quick-start. You can still modify them like your own, actually they are built so you can adjeust them to your needs.

The RapidMarts always use R/3 dataflows like you did in the past. No difference.

  1. No, it is up to you.
  2. ABAP (R/3 dataflows) only
  3. Nothing to be done on the SAP side

Werner Daehn :de: (BOB member since 2004-12-17)

Thanks Werner, My client has one more question. I am Data Integrator expert not SAP.
Client was asking to gather information which rapid marts are available for SAP R/3 modules.
Below is the table I made for my client:

Rapid Mart SAP R/3 Modules
========== ==========
Account Payable ----> FI-FInance
Account Receivable ----> FI-FInance
Cost Center ----> CO-Controlling
Human Resources ----> HR-Human Resources
Inventory ----> MM-Materials Movement
Plant Maintenance ----> PM-Plant Maintenance
Production Planning ----> PP-Production Planning
Project Systems ----> PS-Project Systems
Purchasing ----> SD-Sales and Distribution
Sales ----> SD-Sales and Distribution

Can you have a look and confirm what information I collected is correct. There is very less information available for Rapid Mart.

Thanks,
Kalpesh


Architect2009 (BOB member since 2005-10-26)

In general I agree. Of course does the CO Rapid Mart contain CO data, so reading the SAP FI-CO module. But it is not a 1:1 relationship, e.g. CO RapidMart contains ProfitCenter accounting information as well. Or Sales is using an HR table to get some details for the salesperson dimension - if HR data exists.

But as said, from a practical approah your list is what I would have answered as well. I would now pick a few and actually test-install them to look at them. Maybe you want the get data from the SAP SD module and hence the SD RM is your best choice. But maybe it is not orders/deliveres and billings you need. I had once a customer who managed service and maintenance contracts via SD also. So what is one order then? A one year maintenance contract. What is the billing schedule? 100USD each month. The RM was not built for that kind of operation.


Werner Daehn :de: (BOB member since 2004-12-17)