Applies to:
SAP MDM - Master Data Management 7.1
Abstract
This article provides a step-by-step procedure for how to auto map look up field values when value mapping is not possible.
To explain the scenario, let us take the example of ‘Material Groups’ look up table.
Material Groups look up table has two display fields Code and Name (Description). To import look up data into MDM from the ERP system, we shall use import manager. However, due to system restrictions, for importing the record(s) into the main table we can only send the code for ‘Material Group’ field. As this field is the combination of two display fields i.e. code and name, so the field values would not get auto mapped and manual mapping is not a good solution, like in case of large amount of data.
So the requirement is that the Lookup Field values should get auto mapped.
We’ll update Material Group table with remote keys and then import main table data without doing any manual mapping of look up field values.
Make the table ‘ Material Groups’ as key mapping enabled and create the remote system of type inbound or inbound/outbound as shown below:
Export the supplier records to excel using data manager.
Open import manager, select the remote system & connect to the prepared excel as shown below:
Select the source and destination tables:
Create a clone field of field ‘Code’ and rename it to Remote Key as shown below:
Perform field mapping by clicking Automap
Go to the tab ‘Match Records’, select the matching field as ‘Code’. If you are importing all the fields of the table, the default Import action would be ‘Create’. In our case the data of the table ‘Material Groups’ is already imported, we just need to update the records with remote keys, so the default import action would be ‘Update (All Mapped Fields)’.
Perform the import by clicking on Execute Import icon.
Open data manager and check the imported remote keys. Just right click the Material Group table record and press edit key mappings, a new pop up window will open with the remote system details.
Open import manager and connect to the source excel sheet.Perform Field mapping by clicking on the button ‘Automap’.Click on the Material Group field, you would find that its Field value is also mapped automatically.
Perform field matching step and execute the import.
http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm
http://help.sap.com/saphelp_nwmdm71/helpdata/en/43/D7AED5058201B4E10000000A11466F/frameset.htm
http://wiki.sdn.sap.com/wiki/display/SAPMDM/SAP+Master+Data+Management
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
8 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |