how many way we can extract data from ECC to MDM for main table records?

[Former Member]

how many way we can extract  data from ECC to MDM for main table records?

[former_member226173 · Accepted solution]

Hi Archana ,

The most common way to send data to MDM from ECC is using "IDOC" .

ECC -------> PI --------> MDM

Once a data is changed in the ECC environment trigger an IDOC which will be picked by the PI system where you can put any filters or conditions if you want to , then the data is imported into the MDM system via the MDIS

1) You need to custom code to send the information which are changed in the ECC system ,

2) PI configurations have to be done .

3) Ports and maps should be maintained to automatically import the values into the MDM system

Regards

Vag Vignesh Shenoy

[Former Member · Accepted solution]

Hi Vignesh,

I want to know about the possible alternatives like MDM extracter or other options.

Regards,

Archana

[Former Member · Accepted solution]

Hi Archana,

Apart from these you can also write custom code for extraction or even take excel dump from required tables.

Thanks,

Ravi

[Former Member]

Hi Archana,

Kindly update/close this thread.

Thank you.

[Former Member]

Hi Archana,

There are many ways to extract the data from ECC and to load into MDM

1.To update the lookup tables in MDM , you can use MDMGX transaction in ECC by which you local download the XML file into your system and upload it via FTP or import it manually through Import Manager.

2. To update the main table in MDM, you can use transaction MDM_CLNT_EXTR and auto import the data through PI channel for which you have to maintain some configuration settings in ECC,PI and MDM.

You can choose as per your requirements.

[former_member210627]

Hi Archana,

MDM extracts data from ECC in 2 ways:

1. For lookups, the tcode is MDMGX

2. For main table, tcode is MDM_CLNT_EXTR

As per the rules, first we extract lookup table and then the main table.

You may find the below link helpful

http://scn.sap.com/thread/970280

Regards

Priya Zutshi

[Former Member]

Hi Archana,

There are many possible ways to send data from ECC to MDM:

1. Use Standard Transaction MDM_CLNT_EXTR to extract data from ECC and auto import data in MDM through PI channels. To use this, you will have to do various configuration settings in ECC, PI and MDM.
2. Second way is to Write a custom program to extract data from various tables and save in XML file and send data to PI system. PI system would take data and convert it into an XML ready to be imported in MDM. Then create automatic MDM inbound port to auto import data using specified map.
3. Another way is to write extractiion program in ECC that will extract data in Excel format and save it on your desktop. Then you can use this Excel file to prepare import maps and then import data manually.
4. Also there are transactions like BD10, BD12 and BD14 for extracting data for data objects Material, Customer and Vendor respectively.

You can choose any option as per your requirement. Thank you.

[Former Member]

Hi Archana

use BD10 (Material), BD 12 (For customer) or BD 14 (for vendor) to extract the data but one IDOC per record.

or follow this link ....

http://scn.sap.com/thread/1706834

[former_member193350]

Hi Archana,

For sending the main table record you can either use  tcode MDM_CLNT_EXTR which will send the data in the form of IDocs or through BD10 tcode which also sends the sends the data in the form of Idocs.

Regards

Prateek Agarwal