Skip to Content
0
Former Member
Feb 16, 2011 at 09:35 PM

Hierarchy Loads using Import Manager

29 Views

Running on 7.1 SP05 using the SAP supplied Vendor Master repostory archive.

Attempting to load the Regions hierarchy table which contains three fields: Country (lookup flat), Region Code (text) and Region Name (text). When defining the map in Import Manager it will only allow me to select Region Name as the matching field. And, as a result, it will not load all of the data in my load file - it loads the first value of Region Name and skips the other records where Region Name is duplicated. This makes sense; however, I need to be able to select both Region Name and Country as my matching fields when defining the map. These two fields are the unique identifier for the load file and all the data would be loaded correctly if I was able to select Country as well. I have tried making Country both a unique field and a display field in Console, but to no avail.

Does anyone know how to get Country to appear in the "Mapped destination fields" so that I can match on both Region Name and Country?