initial load from ECC/R3 to MDM

[Former Member]

Hi,

Could any one tell me the process for one time intial load from R3 to MDM.

preferably without XI.

how to extract data from R3 ?

what format?

how to map source to MDM repository?

Farah

[Former Member]

Hi Farah,

There are two transactions to extract the data from R/3

MDMGX - For Extracting Lookup data

MDM_CLNT_EXTR - For Extracting Main table data

MDMGX Steps:

1.Go to transaction MDMGX.

2. Define Object Types: There are some standard object defined in MDMGX, you can use from them as per your requirement and you can also create the new objects.

3. Define Repositories and associate it with the object created in the previous step.Also add the FTP Server details.

4. Maintain Ports and Check tables: Add the Codes of the ports and select the corresponding table from where you want to extract the data.

5. Generate XSD: to generate the XSD file to use in console while creating port.

6. Start Extraction: To Extract the data from the R3 to MDM via FTP Server.

MDM_CLNT_EXTR steps:

Refer the below link that contains the entire configuration needed to extract the Main table data.

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/50260ae5-5589-2910-4791-fc091d9bf797]

Regards,

Jitesh Talreja

[Former Member]

Hi Farah,

Apart from above replies which only talk about mdm generics etc... see this thread which talk about ALE configuration to take xml from R3 for idocs etc..

and for a table and report in R3 you can save excel files which can be imported into MDM. Just generate the output of table and report and go to List-->Save -->Spreadsheet and also xml for a report can be generated using Call Transformation statement.

An abaper can eaisly do that. please also check for the same.

BR,

Alok

[Former Member]

Hi Farah,

Regarding the integration of R3 with MDM please follow these steps:

1. Extract the lookup data from R3 suing MDMGX transaction.This will extract the data into 1 XMl file which can be directly used to upload data into the Lookup Tables of MDM.

2. For the Main Table Load - You will have to use MDM_CLNT_EXTR tx ( as mentioned in above post). This will extract the data in IDOCs format from R3.

3. Then using XI you will have to convert the IDOCS into XML files, which you can then import into MDM.

4. Fo mapping into MDM, you will have to first create a repository which will contain the relevant tables and fields.

5. After having a structure in MDM, you will have to map the source and the MDM repository in MDM IMport Manager.

6. Once the Mapping is done, you can perform Importing and then the Data will be imported into MDM.

Kindly refer these links for furthur assistance :

For MDMGX Transaction :

[;

Also please refer :

[;

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/5326] [original link is broken] [original link is broken] [original link is broken];

Hope it helps.

*Please reward points if useful

Thanks and Regards

Nitin jain

[Former Member]

Hi Farah,

To extract the reference data (lookup table data) from R3 to XI, yes, you can do this without using XI. SAP has provided standard transaction as "MDMGX"-mdm extractor, by using this you can replicate the reference data from R3 to MDM without using XI.

but for the main table data, you can use the MDM ABAP API.

otherwise there is another transaction as "MDM_CLNT_EXTR", by using this you can replicate the main table data from R3 to MDM but in this case you have to use XI.

Xi is used in this case to convert the idocs into Xml so that the main table data can be extracted in a language in which MDM understands.

Besides Xi is also used for Monitoring purpose and also for perfrming various conversion on data if required before extraction.

You can follow this link to help you in R/3 extraction of lookup tabls

/people/ravikumar.allampallam/blog/2005/09/06/mdm-import-manager--get-data-for-check-tables

Hope it helped

Kindly reward points if found useful

Thanks

Simona

[Former Member]

Hi Farah,

You can use MDM_CLNT_EXTR for intial load.

without XI , you need to convert your IDocs to XML (will send you the link how-to by evening).

Mapping will be done in Import manager.

if you are using standard business content, you can have pre-configured Import maps.

Pls come back for more queries.

hipe this helps,

+ An