Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

re: validations in MDM

I want the industry key to given for only account groups=a/b/c/d

Els if the account grp is other than a/b/c/d it should not accept industry key value.

I have written it as

IF((account group .Name(Not equals Symbol<>) Account group[a] or

account group .Name(Not equals Symbol<>) Account group<b> or

account group .Name(Not equals Symbol<>) Account group[c] or

account group .Name (Not equals Symbol<>) Account group[d] ),IS_NULL(Industry.[Record]))

This is working fine for the other account groups than a/b/c/d if the industry key value is given it is throwing error.......but the same with account groups a/b/c/d..but i want the account groups a/b/c/d to accept the industry key value.

Edited by: shifali charya on Sep 4, 2008 7:38 AM

Edited by: shifali charya on Sep 4, 2008 7:39 AM

Edited by: shifali charya on Sep 4, 2008 7:39 AM

Tags:
Former Member
Former Member replied

Hi Shifali,

Check the below expression.

Account Group is the lookup field in the main table

Account Groups is the lookup table

IF( (Account Group[Record] = Account Groups [a] OR Account Group[Record] = Account Groups <b> OR Account Group[Record] = Account Groups [c] OR Account Group[Record] = Account Groups [d] ) , IS_NOT_NULL(Industry.Record) OR IS_NULL (Industry.Record) , IS_NULL (Industry.Record) )

Note: Select everything from the list. Don't type anything by own

Regards,

Jitesh Talreja

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question