Hierarchy Import

[shanthi_kumar]

Hi Experts,

I have a scenario where in I have to import HIerarchy records into MDS. The source file has the records in the following manner 10,1001,100101,100101A,20,2001,200101... Now I want the records to be in the hierarchy format like

10                                        20

    1001                                   2001

          100101                              200101    

                   100101A                         200101A.

Kindly help me in achieving this.

Thanks,

Shanthi.

[Former Member]

Hi Shanthi,

You can check below link to get detailed information regarding import of Hierarchy:

http://help.sap.com/saphelp_mdm550/helpdata/en/2b/595cb4d29b408e8187ec1a100e340d/frameset.htm

This will help you to understand function of Create Hierarchy Field Command and will help you to prepare source file accordingly. Thank you.

Regards,

Ankush Bhardwaj

[Former Member]

Hi

For hierarshy loading you have to prepared source file next structure:

ChildID, ParentID, parameter1, parameter2,....., paramenter N

In you import manager you will got next structure:

ChildID

ParentID

Parameter1

Parameter2

.

.

.

Parameter N

Select both fields ChildID and ParentID at same time

Run submenu- select "Create Hierarchy Field"

after that you have got two new fields with your hierarshy  structure

map it to your destination hierarshy

map Prarameters to destination fields where it should be

according to you structure

10                                        20

    1001                                   2001

          100101                              200101    

                   100101A                         200101A.

if 10 is root and 1001 is child and 100101 is child of 1001 and in another column(20,2001...) your parameters

you should to prepare next source file:

ChildID, ParentID, parameter

10                                20

1001             10            2001

100101         1001         200101

100101A       100101      200101A

Regards

Kanstantsin Chernichenka

[shanthi_kumar]

Hi Kanstantsin ,

Thanks for the reply. Please see that I am doing the import mapping for automatic import. Except for the first time mapping the other times I can't create the source structure again. Also I have nearly 10,000 and for which creating the separate source is again a bigger task. Please help me to do it with the same source which has one column for the Hierarchy structure.

Thanks,

Shanthi

[Former Member]

Hi Shanthi

first of all:

Your hierarchy should be static.

If you want to create mapping - you should prepare source file for import which should contain full paths for all hierarchy's leaves

and create mapping between your source and destination hierarchy elements.

After that you can save this map.

Another way:

in your PI you can start some java or abap application and through MDM API update hierarchy elements or main table records directly without using standard import.

if you have to add many additional nodes to your hierarchy - this is maybe very long process...

You should to do next:

1) syndicate keys for all your records related to it hierarchy keys

2) export repository schema

3) delete your hierarshy table

3) restore your hierarchy table from repository schema

4) load full hierarchy with all new nodes

5) update all your records  in main table related to hierarchy

Regards

Kanstantsin Chernichenka

[Former Member]

Hello Shanthi,

You will have to modify the source file.

You may right a macro in excel to change the layout of the source file.

to

10                                       

    1001                                  

          100101                                  

                   100101A

20

    2001

            200101

                        200101A

each should be stores in separate colums.

else try to use a different delimiter between every header data, and select split by delimiter in the import map.

Like 10,1001,100101,100101A:20,2001,200101,200101A

Regards,

Abhishek