Import Failed !!!

[Former Member]

Hi Folks,

We are importing vendor data from multiple r/3 systems - all but one are successful.[throught XI]

The error is

"Import failed. Cannot import qualifiers because the qualified lookup field is not mapped."

The map being used is CREMDM04_R3.

Could some one explain why this error comes and how to resolve.

Regards

Vinay

[Former Member]

Hello Vinay:

This error comes when you are trying to import some values into lookup tables, when those values don't already exist on MDM.

The reason for this is that lookup tables are meant to keep data integrity, by giving the user a set of choices for a given value, instead of allowing him/her to write that value. This way we can keep control and avoid typos, duplicity etc.

What you need to do, is to go to the Batch Input manager (in case you are using batch) and set the option on the ini file:

Automap Batch Unmapped Value=Yes

Batch Unmapped Value Handling=Add

Always Use Batch Unmapped Value Handling=YES

This way, you tell MDM that even tough you didn't map some values, MDM should create those values, instead of waiting for manual mapping.

In case you are using Import Manager (not batch), please check that all your lookup tables are mapped, not only at a field level, but at value level too.

I hope that helps

Alejandro