How to define a Matching Field

[anthony_bateman3]

I have a need to define a field as a matching field, but cannot figure out how it is done. Although the field is mapped, it does not appear in the list of potential matching fields. In fact only one field appears there.

How can I define a field as a matching field so that it appears as a candidate in the matching Fields window?

[Former Member]

Hi Anthony,

As suggested in the earlier post, you need to check the Data Type of the destination field, which you want to use as Matching field. If the Data type falls in the categories mentioned on right hand side, then you would not be able to use that field as Matching field and you might need to use some workaround.

If the required field falls under the categories mentioned on Left hand side, and still that field is not appearing in the available matching fields list, them you need to check if any of the condition mentioned under the table is not violated.

You can check Import Manager Reference guide, Section "Matching Records" for more details in this topic. Please let us know if you find the issue using this information.

Thanks and Regards,

Ankush Bhardwaj

[former_member198313]

Hi Anthony,

Not all mapped destination types can be used for record matching. Those that appear in the Mapped Destination Fields list and that you can select as Matching Fields are listed below...

Available as Matching Fields **	Not Available as Matching Fields
AutoID Integer   Real   Currency   Date   Time   GM Time   Timestamp   Text   Text Normalized   Lookup [Flat]   Lookup [Hierarchy]   Lookup [Main]   Lookup [Taxonomy]	Text Large   Lookup [Text Block]   Lookup [Text HTML]   Lookup [Qualified]   Qualifiers   Attributes   Boolean

**

1 Cannot be multi-valued

2 Cannot be a promoted display field

3 If hierarchy table, must be the main display field

4 Cannot be a compound field (i.e. lookup to a table with multiple display fields)

5 Can be mapped only from Add, Clone or Split into Multiple Fields extended source fields

6 If mapped from extended source field, must connect to source with read/write permission

7 If not the main table or a hierarchy table, all of the display fields must be selected

http://help.sap.com/saphelp_mdm550/helpdata/en/43/4548a6270d321ae10000000a422035/content.htm

http://help.sap.com/saphelp_mdm550/helpdata/en/43/454e66270d321ae10000000a422035/content.htm

+ AG