Skip to Content
0
Feb 14, 2011 at 11:32 AM

Existence check on lookup table in MDM data manager

20 Views

Hi all,

I need to do existence check for a particular field in a main table.

For example: In main table i am having the following fields.

MATERIAL_MASTER(Main table)

1. Material Number (Text)

2. Material type (Text)

3. Plant (Text)

PLANT_MASTER(Lookup flat)

1. Plant (Text)

2. Plant name

I need to validate like "whatever entries of plant are in main table, should be exist in lookup flat".

MATERIAL_MASTER.Plant(PLANT_MASTER.Plant)

Is it possible to validate like this in MDM? Can anyone please help me?

Thanks in advance,

Guna