Not able to Populate Qualified Table in Import Manager

[Former Member]

Hi,

I am performing following steps for populating Bank Detail Qualified table in MDM from R3 but not able to populate the data.

1.Populating all lookup tables like Account_no,Bank-Key.......

2.Mapping all fields in Bank detail table except the 'Collect Auth'

field which is Qualifier

3.In Customer table(Main) mapping Collect auth to Bank Detail field and

customer_no to its corresponding ID.

It is not populating the Bank detail data which are available in lookup tables

Appreciate your suggestion

-regards,

reo

[Former Member]

Answered

[Former Member]

Hi Reo,

Take a look at this <a href="/people/pooja.khandelwal2/blog/2006/03/29/taming-the-animal--qualified-tables.

HTH

Suman

[Former Member]

Reo,

When you map the source field Collect Auth to the destination field Bank Details check what the "Set Qualified Update" action is by right clicking on the field Bank Details in the Destination Fields tab. The problem may be here

Rgs

C

[Former Member]

Hi Con,

Coll-Auth of source fld is mapped to Collect-Authorization of Customer(main) table by right clicking there "Set Qualified update" all are disabled(greyed out).

Do you know what is to be done here

Moreover in Bankdetail table it is not allowing to add non qualified field for match record.There are couple of flds like effective date etc not available in source and therefore not mapped but rest of the fields should be allowed for Match record process. But it is not working that way.

Appreciate your help

[Former Member]

Reo

Matching will be based on the Display field (at least one) of the Main table. This is for example the Customer Number.

You also need to map all the display fields of the qualified lookup table. Then you can set the Qualified Update Action by right clicking on the field in the main that is linked to the qualified lookup.(the Collection_Authorization I think). Set the option that well update/append/replace the qualified data fields of the looked table.

There is two how_to_guides that will help. You can download from SAP Service Market Place. (Otherwise I can email to you)

How To Troubleshoot MDM Import Manager

HowTo_LoadQualifiedFields

Rgs

Con

[Former Member]

Reo,

Is the import happening successfully, or is there any errors displayed in the log during import.

Triveni