Existence check on lookup table in MDM data manager

[former_member1052991]

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

[former_member207367]

HI Guna,

Try checking the validation

Expression : Plant = PLANT_MASTER.Record

I did not run the validation at my end, please check and let me know the results hoping this should work.

When you run the validation it provides you whether it is sucessfull or failed by a status Field.

Thanks

Sowseel

[former_member1052991]

Hi Sowseel,

Thanks for your reply.

I tried with both the things as follows:

Plant = PLANT_MASTER.[Record] and

Plant = PLANT_MASTER.Plant

Its not working Sowseel. Is there any other options available?

Thanks,

Guna

[former_member1052991]

Hi Sowseel,

Is thr any other expression?

Plz help me ..

Thanks,

Guna