Skip to Content
avatar image
Former Member

Order to import data in to SAP MDM using import manager

HI All,

Is this the order to import data in to SAP MDM?

Import look up tables

Import Hierarchy Tables

Import Taxonomy Tables -


Non -Qualifiers

Then import main table----map Qualifers along with Mian table and import...

Can we import entire taxonomy tables (Qualifiers, Non-Qualifers) along with main table after importing look up tables?

Thanks

Rajeev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 04, 2010 at 01:48 PM

    Hi,

    First we have to Import Lookup tables. After this Maintable data. Along with the main table data we can load Qualified table data / we can do it separately.

    After this you can load Hierachy and Taxonomy table data.

    For doing Taxonomy data imports, please refer below articles:

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/30aa1447-80a1-2a10-e483-a76087bcb12f

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/6090d0bd-1da7-2a10-468f-bdd17badb396

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/8090941f-a5a7-2a10-3ba6-b4af5ec6d97b

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/308c62a2-5faa-2a10-fda6-fa4aa7169734

    Hope this may help you,

    Thanks & Regards,

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Srinivas,

      If we import first main table then hierarchy and taxanomy then how you can link taxanomy and hierarchy to main table.

      It is possible then u have to create multi rows for each taxanomy for each record to link.

      if you have any different approach then pkease share with us.

      Thanks,

      Sudhanshu

  • avatar image
    Former Member
    Jun 04, 2010 at 02:01 PM

    Hello Rajeev,

    According to my understanding (worked in my projects).

    First you can go with all Look up tables (flat, Hirerachy) after hirerachy load taxonomy. while importing qualified, import Non -qualifiers first & then import Qualifers along with Main table data.

    Regards,

    MSR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 07, 2010 at 12:04 PM

    Hi Rajeev

    The sequence mentioned by you is correct for importing data in MDM- flat lookup, hierarchy first followed by Main table.

    Can we import entire taxonomy tables (Qualifiers, Non-Qualifers) along with main table after importing look up tables?

    I am assuming that you are implying Qualified table here.

    Import to qualified tables can be done in 2 ways-

    1. Import separately using the unique field for the main table for linkages to the main table records.

    2. Import can be clubbed with the main table import itself. In the import map we can use Join functionality to do a lookup based on the unique field for the main table.

    For more details on the mechanism please go through the threads below-

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/6090d0bd-1da7-2a10-468f-bdd17badb396

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/8090941f-a5a7-2a10-3ba6-b4af5ec6d97b

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/308c62a2-5faa-2a10-fda6-fa4aa7169734

    thanks

    Ravi

    Add comment
    10|10000 characters needed characters exceeded