At-Most Validation for Qualified Records

[Former Member]

Dear Experts,

We have a qualified table (Product Map) associated to the Main Table (Product). There is a qualifier field "Y/N" which is a lookup-flat field to another flat table which stores the values Y & N.

Hence the values the Y/N field may have is Y, N or blank (no value).

We need to create a validation to check that only one of the qualified records in the Product Map has the Y/N field value as Y.

I can check if At-Least one record has Y value. If it can also be checked somehow that At-Most one record has Y value, the requirement can be fulfilled.

Please let me know if you have encountered this issue and how was it solved.

We are currently using SAP MDM 5.5 SP06 Patch 05 (5.5.65.98)

Thanks a lot in Advance.

Regards,

Uday

[Former Member · Accepted solution]

Hi Uday,

If you can modify yr lookup table that contain Y and N values then there is one work around.

Add one more non display field in that table of type integer and assign 1 to Y values and other values assign 0.

Now in validation check

if(SUM(lookupfieldofmaintable.lookupfiledinqualifiedtablethatcontainYandN.newfieldthatyouaddedinlookuptable)>1,false,true)

Its working fine at my end please try if modification of table is not an issue.

Thanks,

Sudhanshu

Edited by: Sudhanshu Agarwal on Jun 30, 2010 6:52 PM