Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Apr 25, 2012 at 10:32 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 25, 2012 at 11:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2012 at 03:43 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 27, 2012 at 01:50 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2012 at 09:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 01, 2012 at 12:14 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2012 at 05:42 PM

    Hi Archana,

    Kindly update/close this thread.

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.