Validation Problem

[Former Member]

Hi,

Can i write a validation which checks and compares the Non qualifiers selected for a Record?

I have 2 qualified tables

table 1

process Type (Non qual) (lookup to table3 values)

status

table 2

Type (Non qual) (look upto table3 values)

Date

table 3 values

Name (Display Field)

-

---

non commercial

comercial

logistics

warehouse

Now when i have a record and they selected 2 values as Non qualifiers in table 1

Now i need to make sure that the user selects the same types (that are selected for Table 1) in table 2 - type field.

if the user select different types in table 2 which are not selected in table 1 then there should be an error.

I am not sure how to write this validation on the qualified tables..

Can anyone help???

KR

John

[Former Member]

Hi John

This is not possible in standard MDM validation to best of my understanding. A record can have different number of qualified table entries linked for QLTable 1 and QL table2. We can not guarantee the same number of occurences in 2 different tables with same sequence/order of NQs.

Workaround could be to achive the same using custom code in portal.

Thanks-Ravi

[Former Member]

Hello john12345

In qualifier you can have duplicate records with partually similar content related to one record in main table.

For example:

your QLUT contain two fields region(LUT) and price(currency) and for one record in main table you have next QLUT

UK 100$

USA 120$

USA 100$

PL 100$

if you want to validation all records with price 100$ you CAN'T(validation has returned jus first occurance of value)

If you want to validation all records with region USA you CAN'T(validation has returned jus first occurance of value)

You CAN use count for check - your QLUT empty or not (if count has returned 0 your QLUT field is empty if some value - in your case =4 your QLUT contain 4 records)

Another finctionality doesn't supported SAP MDM

Solution:

table 1( LUT has linked to main tabler as multivalued)

process Type (Non qual) (lookup to table3 values)

Date

status

Unique key Process+date

Regards

Kanstantsin Chernichenka

[former_member207367]

Hi John,

I checked this scenario at my end in customer master for Fax Numbers (Qualified Flat Table) which is referred to Main table field Fax and Phone Numbers (Qaualified Flat Table) which is referred to main table field phone where Country field is a Non Qualifier in both the qualified tables and it is referred to a look up flat table countries which has the different codes of countries.

With Validation Expression below problem is solved if the order in which the records are selected in both Qualified flat tables, Phone numbers and Fax numbers

Fax.Country.code=Phone.Country.code

Note: But there is a real problem, that user selected the records in the different order in both qualified flat tables, then this validation expression will not work.

I did my testing in MDM 5.5 SP06. please check in MDM 7.1 and see it may work in the way which you need.

In your scenario the Validation code will be like this

Table1.ProcessType=Table2.Type

If you have Portal in your landscape this can be handled better using JAVA API and ABAP API.

regards

Sowseel