Update remote key back in MDM using MDM Auto ID for records created in MDM

[Former Member]

Hi Experts,

We are integrating MDM material master with ECC, in our case the client wan to create the material in MDM and distribute to ECC. MDM will have the standard auto ID and ECC will have its own material numbering.

We create a new material in MDM and syndicate to ECC for creation in ECC. ECC will create a new material no. and send back both the MDM ID and the new material no is ECC. Now we need to create the remote key in MDM based on MDM ID (Auto ID)

We need to achieve this with out any changes to the repository structure. I think it is not possible to import the based on Auto

ID in MDM using import manger/server.

My question is can we achieve this using APIu2019s or web services, if any one has already done this please explain me how exactly this can be done.

Please send your valuable inputs.

Thanks & Regards,

Arul

[Former Member]

Dear Arul,

It's possible using import map to update remote key based on auto ID.

Make sure that the Remote Key is enabled on your target table.

Map incoming Key to Remote Key Field.

Map incoming Auto ID to Auto ID Field.

In Key Mapping use Auto ID as key.

Regards,

Shaailesh.

[Former Member]

Hi Shaailesh,

I tried mapping to Auto ID in import manager by selecting the R3 as the remote system the map button is disabled. Auto ID mapping was never supported before.

If this possible kindly let me know if i am missing some setup.

Regards,

Arul

[Former Member]

Dear Arul,

May be because Auto ID field is not editable, hence not mappable in import map!

Well one option is you can try creating a simple text field for copying auto-id.

Populate the auto-id value in this field using assignment.

And then use this editable text field in import map.

You can make this field writable once, so that once copied auto-id wont change for a record.

Otherwise, the only option is using API (Java, .Net, or ABAP API)

Regards,

Shaailesh.

[former_member205403]

Hi,

Give a try to ABAP API for this.

Please check the below mentioned link of ABAP API guide:

[Method IF_MDM_CORE_SERVICES->CREATE_CLIENT_SYSTEM_KEYS|http://help.sap.com/saphelp_nwmdm71/helpdata/en/44/995c70ac415da3e10000000a1553f6/frameset.htm]

Regards,

Shiv