Not able to Finding Duplicates using Excel as a Source

[Former Member]

Demo Scenario for 5.5 SP3:

I am using the standard Vendor repository for this demo that we are creating for a client. No XI in place yet. The source is Excel files (simulating source systems) that I have created based on all the fields in the Vendor main table i.e. 98. So a 100% match between the repo. and my Excel in terms of fields.

Next, I populated some of the 98 fields and mapped to the Vendor main table. Then I loaded the first Excel file with 11 records and loaded fine. Next, I loaded another Excel (same structure)with 11 records, but identical Vendor Name on 2 records. I did a match on 'Name 1' field as I imported this second Excel into the repository. Loads fine.

Result: The second set of records replaced/updated the records in the repo. since it found duplicate records with same 'Name 1' and assigned unique Auto Id. I end up with 20 records in the Data Manager instead of 22. When I do Edit Key mapings (right mouse click on any of the 20 records), nothing is in the dialog box. I was expecting MDM to create one auto id for records that have the exact match on 'Name 1'. Instead, it is creating 20 auto ids for all 20 records and replacing the ones where it finds a duplicate based on the matching criteria.

I want to take this to BW, I know how, but by not getting a group id, it does not help me. Hence, I was hoping someone can help me ..what am I doing wrong? Why is the dialog box empty..there are 4 columns all blank..they are Default, Vendor Number, Client System, Key. What is the Key?

How have others done it with Excel using standard Vendor (SP3_P1_Vendor) repo.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

Edit Key mapping values will be populated in the following scenarios.

1. In the "Main Table" Details, if the Key Mapping is set to "Yes". I hope it is set to Yes by default, because you are using the standard Vendor repository.

Unless if you did not change the property by mistake.

2. Once the Main table "Key Mapping" property is set to Yes, In the import manager when you try to import the data, Under "Map Fields/Values" tab -> Destination fields you see a field called "[Remote Key]". This "Remote key need to be mapped to some value, which ever your trying to identify between the source systems.

Based on your post, you are doing everything ok, but I strongly feel you did not map the "[Remote key]" to any of the source fields.

Hope this helps. If you need any additional information let me know.

Thanks and Regards

Subbu

[Former Member]

Hi Subbu,

1. Yes, in the Console for the main Vendors table, the Key Mappings is ON ..as a matter of fact all the tables under SP3_P1_VENDOR have it ON.

2. In the Import Manager or even in the Console, there is no sign of Remote Key in the main Vendors table. The only fields to be seen are id, vendor number, account group, title, name 1, name 2, etc. How come?

Also, I noticed that in the Console where you add client systems, I am showing 3 ...MDM, BW, and MDC R/3. The Key Generation column says NONE ...is that an issue? Also, I use Excel and MDM (client) to load the file ..the MDM is set up for Inbound only, is that an issue?

So, please let me know more about the Remote Key. Also, you said I can map to any source field, but what if that field, say 'Name 1' is already mapped to 'Name 1' of the main table?

Thanks.

[Former Member]

Hi,

In the Import Manager->Map Fields/Values Tab->Destination fields. Go thru the entire list of fields, you will find a field with name "[Remote Key]".

<b>This will only visible once your "Main Table" -> "Key Mapping" property is "Yes".

And Client System ->Type property is set to "Inbound/Outbound".</b>

Another Reason could be "You are selecting Client System as 'MDM' in the Import Managaer". "[Remote Key]" will not be visible in this Client System. Because Client System "MDM" type property is set to only "Inbound".

Try creating a Client System in the Console with type property as "Inbound/Outbound". Use the newly created Client System in the Import Manager.

Hope this should solve u r problem.

Let me know if you need additional information.

Thanks and Regards

Subbu

[Former Member]

Ok...I selected BW instead that had inbound/outbound and I can now see the Remote Key. What should this be mapped to on the source side? All 98 fields are automap except the id, create by, update by. Hence, need to know what should the RK on the main table be mapped to?

Thanks. Do you have a personal email or AIM or MSN id?

[Former Member]

Hi,

Which field to Map to the "[Remote Key]" is completely depends on the requirements.

In the standard maps provided by SAP for Vendor repository, it uses "Vendor Number" to map to the "[Remote Key]".

In your case you are using Vendor repository, you can use the "Vendor Number" field.

In the Import Manager->Source Hierarchy, Select the "Vendor Number" field and right click select "Clone field".

Now you will see 2 fields "Vendor Number" and "Vendor Number <Clone>". So map one to "Vendor Number" and other one to "Remote Key".

Just giving "Vendor Number" as an example. As I said it all depends on your requirement.

Thanks and Regards

Subbu

[Former Member]

Is the Key Mapping same as Group ID that I wound need for BW? That is, use Group ID an a nav attribute of 0Vendor. Is the Group ID system generated? In your example, if I map it to Vendor, it takes on the value on Vendor so not sure how that helps for sending it to BW.

In my flat file scenario, I would like to match on 'Name 1' field to identify duplicate records with same vendor names so it assings one group id to many records. So should I be mapping the Remote Key to the 'Name 1' field instead of 'Vendor'. Just trying to understand what Remote Key actually does and what you meant by requirements. Also, when I Remote Key to a clone, I do not see Remote Key as an option to map (not visible at all).

Thanks again. I think I am almost there!!