Business Partner extract from R/3 (or SRM) to MDM without XI

[Former Member]

Dear SAP Experts,

do you have any solution for extraction of Business Partner data from R/3 (or SRM) to MDM without XI? I know transaction mdmgx and the reference data went to the MDM well. How can I do the same for master data without XI? Please write me a step-by-step solution, if you can, because we haven't got too much time, to solve this issue.

Thanks a lot!

Best regards,

Ádá

[Former Member · Accepted solution]

Hi Adam,

a solution may be to develop a Java Service able to extract data from R/3 via RFC and store data in MDM via MDM Java API (you can do it also in abap via abap API).

You can call the Java service periodically using a Scheduler Task.

Hope this help you.

Best regards,

Vito

[Former Member · Accepted solution]

Hi Vito,

thanks for the fast answer. Is it sure that there isn't any easier solution for extraction master data from R/3? I don't understand why is it, because the reference data with mdmgx can be transferred. I can't see the main difference between reference data extraction and master data extraction. Why is the first possible without using XI, and is not the other?

Thanks a lot,

Ádá

[michael_theis · Accepted solution]

Hi Adam,

there are different reasons for this:

1. MDMGX selects data directly from tables. Customizing tables are very simple tables, thus it was possible to implement a direct access. Master data itself is stored in distributed, multiple tables. It's not this easy to extract the data, thus MDM_CLNT_EXTR is using special extractors for the master data objects. Those object extractors are delivered by the object owners, not by the MDM group.

2. ALE IDoc and Proxy messages are the common way for data exchange between SAP systems. There are predefined IDoc and XML message types for master data. This was not the case for customizing data, so we decided to use FTP for MDMGX just as an exception.

3. The MDM data model for business partners has to combine different data models: R/3's customer and vendor with CRM's/SRM's business partner. Those models have to be combined to a general MDM Business Partner model. This requires a structural and value mapping of the different structures. Currently this is done on XI using a XSLT Message transformation.

BR Michael