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