How to import Hierarchy Data in MDM 7.1

[Former Member]

Hi All,

I am trying to import the hierarchy data to SAP MDM 7.1

I have the data in the Excel sheet in the following structure

Parent Code Parent Name Child Code Child Name

A1 Printer P1 Inkjet

A1 Printer P2 Canon

P1 inkjet Q1 Model - XXX

P2 Canon Q2 Model - YYY

In MDM i have 2 fields in the hierarchy table Code and Name as display fields.

I tried to do partition of fields, combine fields as per the Import documentation. But i was not able to import the hierarchy.

I have also seen some papers on SDN for Hierarchy import, but none of them talk about 2 display fields in the hierarchy table.

Can anyone help me to import the data to MDM.

Thanks,

Priya.

[Former Member · Accepted solution]

Hi Priya.

You have three level hierarchy in your example

A1 ! Printer

P1 ! inkjet

Q1 ! Model - XXX

Parent Code ! Parent Name ! Child Code ! Child Name

in your import manager

select "Partition Field/value" Tab

In source partition window select your "Parent code" filed

press add

select your "Parent name" filed

press add

in window "Partition by:" select "Parent name" and "Parent code" fields and press "Combine" button

for next fields you sould repeat previous steps

then select "Map Fields/values"

find in Field mapping Source field: "Parent code [Partition]"

map it to "Code"

in "Values conversion mapping" window

select all walues and press "Add" button then Add as Child

More about import hierarchy:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/b07849c7-3a5b-2b10-7586-c431d300a578

Regards

Kanstantsin

[Former Member · Accepted solution]

Hi ,

Thanks for the reply. I have already tried the option that you have given me, but it did not help.

The problem i am facing is because of 2 reasons.

1. The data is present recursively in the Excel Sheet and

2. There are 2 display fields Code and Name. I am not able to map these fields using partition field.

Thanks,

Priya.