Look up Table data

[Former Member]

Hi,

How to process Lookup table table data?whether we need to process along the maintable or how?

Regards

Yugandhar

[Former Member · Accepted solution]

Hi

To process lookup table data use MDMGX and select process level as 0.

First lookup tables data needs to be processed and then Main table data.

Thanks

Rupesh

[Former Member]

Hi Yugandhar ,

ECC:

From ECC side you need to first extract the Check table records ie your lookup table records using the MDMGX transaction in ECC

Then you need to extract the main table records using the MDM_CLNT_EXTR program in ECC .

MDM:

In MDM you first import and load the lookup table records.

Then you do the Main table importing

In the main table importing you will perform Value mapping which will link your lookup value to the main table record.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Yogesh,

what do you mean by process look-up table data?are you talking abt importing? if yes then first look up table to be imported followed by main table.

MDMGX can be used for refreshing it from ECC,this is when the values of look-up are changing frequently.

regards,

Bis

[nitin_mahajan2]

I think i got what you are asking,

Creation using Scenario:

It would depend on your usage of the lookup table.

Two options:

If you are using a lookup table as a reference table like a country table being referenced in the main table, then you will process the main table record only and use the lookup table's record Id to store the reference in main table.

If you are using a lookup table to store a static reference, (would be possible in qualified lookup tables/tuples), then you will first create the record in the QLT / tuple, and then use the recordid/reference as a field value to the main table to create a record in main table.

Importing Scenario:

But if you are talking about importing from ECC, lookups have to come first and then main tables.

Regards,

Nitin

PS: tuples are only available with MDM71.

Edited by: Nitin Mahajan on Jun 19, 2009 6:55 PM

[Former Member]

Hi Yogesh

Question is not clear, what do you mean by process. If you are asking for import part first lookup tables has to be imported before importing data in the main table.

regards

Ravi