cancel
Showing results for 
Search instead for 
Did you mean: 

Upload data into main table consisting of a lookup field

Former Member
0 Kudos

Hi,

I am new to MDM and i am struggling with how to proceed with the below scenario

I have a main product table(Shown below) with COO as a lookup field.I want to import this import this information into the repository.

Given product table with data to be imported

ProductProduct description
COO
AProduct AUS
BProduct BIN
CProduct CIN
DProduct DUS
EProduct EUS

Since MDM uses parametric inport, I want to store the distinct values of the COO in a lookup table as shown below.

Lookup table

COO
COO description
USUnited states
INIndia

When performing data import using the import manager, I first have to fill the lookup table.

Then I have to import the values in the main table ?

If this is the case, how can I link the COO already stored in the look up tables to the products in the main table?

Please help.

Thanks,

Vignesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vignesh,

In MDM you must be having main table with fields:

Product which is text

Product Description ( Text)

COO (Lookup Field referncing to Lookup Table )

Now First process you have to load lookup table for that:

Connect the file for lookup table to Import Manager(IM).

In Source select the file and in Destination select Lookup Table.

Go to Field maaping map the fields and Import.

Now to Load Main table product data.

Connect the file with product info with IM.

In source select the file.In Desctination select main table.

Go to field mapping .In destination you will find fields Product,Product Description and COO

Map the source fields to Main table

when you map source field COO to main table field COO which is lookup field ,you will get values enabled in Value Conversion and mapping pane.

Map the values also.

and then import.

Regards,

Neethu Joy

Former Member
0 Kudos

Hi Neethu,

Thanks for your detailed explanation.

Please help me undertand the below also.

After i finish loading the look-up table with COO values and when I proceed with mapping the main table records, do i have to map the value of COO for each product record that I want to import one by one?

If there a lot of product records, this will take time right?

Thanks,

Vignesh

Former Member
0 Kudos

Hi Vignesh

1) suppose you import look-up first , then you are importing main table, then under map fields\value tab-> value conversion and mapping, you have to map value from source to destination, if the the values you are importing is already present then it will be automaticaly got mapped(when u will click auto button), if value is new, you have to add it in destination by "add" button and then map.

2) second way is to use join

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1012f58f-a6e6-2a10-7caf-a46b7ad0f...

Regards

Nitish Sharma

Former Member
0 Kudos

Hi Vignesh,

In Value mapping pane for field COO you will get only values of Lookup record.

Eg. if you have thousand product and for products the COO values are US,IN or DE.

In Value map pane you will get 3 values ie. US,INand DE which you need to map.

Regards,

Neethu Joy

Answers (0)