Matching qualifier in Qualifier Update Option

[siowfong_chen]

Hi MDM gurus,

I am trying to understand the use of the qualifier update option in MDM. By selecting a destination field, I can right-click to set the qualifier update option. I just don't quite understand how the matching qualifier field work. Note that I have read the examples in the Import Manager guide but still do not know whether I fully understand that. If I pick a field to be a matching qualifier, does that mean that the system will check if there is a matching field value from the source and if so will update accordingly to what has been set up (like update or replace). If I do not add any matching qualifier, how does the system determine whether to add the record or replace it and which record it should be replacing? In the example from the guide, the system will replace the existing record.

Appreciate any clarification on the above.

Thanks

SF

[Former Member · Accepted solution]

Hi SF,

Matching Qualifier: If I pick a field to be a matching qualifier in MDM Import Manager, then it will check if there is a matching field value from the Destination(in MDM already or not) and if it finds any value other than matching qualifier source than it append new record else update the existing record.

In simple words, see this below example: you can also try it at your end and let me know if you find any issue.

Source File: Qualified Table say with main table field SAP Material No value 123

Field1(NQ) FIELD2(Q) FIELD3(Q)

2800 ZE03 003

2801 ZE02 004

Existing Record in MDM with SAP Material No = 123

Field1(NQ) FIELD2(Q) FIELD3(Q)

2800 ZE01 001

2801 ZE02 002

Your Action on Qualifed Update: New Links: Create , Existing Links: Update

When Matching Qualifier = None

Field1(NQ) FIELD2(Q) FIELD3(Q)

2800 ZE03 003

2801 ZE02 004

Here, update the existing records since we haven't set any Matching Qualifier And obviously append if we have different Field(NQ) say 2802 etc.

When Matching Qualifier = FIELD2(Q)

2800 ZE01 001

2801 ZE02 004

2800 ZE03 003

Here, update the existing record 2801 since we have Same(ZE02) Source Matching Qualifier and Existing Target Qualifier.

Here, Append(create) new record 2800 as we have different Source Matching Qualifier ZE03 and target ZE01.

Thanks and Regards,

Mandeep Saini

[siowfong_chen · Accepted solution]

Hi Mandeep,

Thanks for the wonderful example. I can understand the example with matching qualifier. However, just want to clarify more on the one with non-matching qualifier.

If my source only have

Field1(NQ) FIELD2(Q) FIELD3(Q)

2801 ZE02 004

and the existing records are

Field1(NQ) FIELD2(Q) FIELD3(Q)

2800 ZE01 001

2801 ZE02 002

When Matching Qualifier = None, would the system replace 2801 or 2800?

If replacing 2801, we will get something like this shown below right?

Field1(NQ) FIELD2(Q) FIELD3(Q)

2800 ZE01 001

2801 ZE02 004

If that is correct, it means that the system will still try to 'match' the field (NQ)?

Regards

SF

[former_member205403 · Accepted solution]

Hi,

Please Go through this wonderful document for understanding Qualifier Update option in MDM.

[How to Set Qualified Update in SAP MDM|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0991519-dcee-2b10-9180-b72c85b4debc?quicklink=index&overridelayout=true]

Revert if you still have any Query.

Regards,

Shiv

[Former Member · Accepted solution]

Hi SF,

Irrespective of Matching Qualifier is set to some field or not , it will always look into First NQ Field then it will look into if you have set any field as Matching Qualifier or not.

When Matching Qualifier = None, would the system replace 2801 or 2800?

When matching Qualifier = None

Field1(NQ) FIELD2(Q) FIELD3(Q)

2800 ZE01 001

2801 ZE02 004

2800 will remain same as source file does not contain Source NQ as 2800.

2801 will update as you said above, i mean your understandng is correct.

In this case, further if you set Matching Qualifier as Field2(Q), you will have two records only, Since your source and target Matching Qualifier corresponding to (NQ) 2801 are same ZE02 so it will update this record.

2800 ZE01 001

2801 ZE02 004

Kindly let me know if you still need any clarification.

Thanks and Regards,

Mandeep Saini