SAP MDM Vendor email addresses are not in order when sent to SAP R/3

[Former Member]

Hi Experts,

We were trying to maintain vendor email addresses in this order in SAP MDM:

-

---

E-mail address: massupa@nexus

Sequence Number: 001

-

---

E-mail address: win@nexus

Sequence Number: 002

-

---

E-mail address: satita@nexus

Sequence Number: 003

-

---

But when saving the record, its order get mixed up like below: (I believe it was arranged alphabetically automatically---> is this the standard MDM functionality?!)

-

---

E-mail address: massupa@nexus

Sequence Number: 001

-

---

E-mail address: satita@nexus

Sequence Number: 003

-

---

E-mail address: win@nexus

Sequence Number: 002

-

---

When it gets syndicated to ECC, its order was maintained incorrectly with incorrect IDs:

E-mail address ID

massupa@nexus 001

satita@nexus 002 -

---

> should be 003

win@nexus 003 -

---

> should be 002

we checked both the XML Files and the IDOC and found that it has the same order maintained in SAP MDM

massupa@nexus 001

satita@nexus 003

win@nexus 002

But how come the IDs were changed in R/3?

Many thanks in advance!

[Former Member]

Hi Mike

This is how it works, rightly intrepreted by you.

For any record the qualified links stored in MDM loses their sequence when syndicated.

This happens because of different data storage method used for qualified links.

If you want to maintain the order as well try defining 1 more field in the qualified table as ID as suggested.

hope this helps-Ravi

[Former Member]

Hi Mike,

As per your requirement, i feel that for ID either you can create a new field say sequence ID in this e-mail addresses table of MDM and thus can syndicate it or can also use ID as key using remote key concept. I mean for this e-mail addresses table, you can set property Key mapping = yes in MDM Console and thus can use this IDs as key for this email address e.g. for massupa@nexus you can save ID as Key.

So during syndication, map this field with target IDOC structure field and I mean Remote Key under e-mail addresses table with IDOC ID target field. In this way you can have correct IDs with their corresponding email addresses.

Kindly let me know if you are looking for something else.

Regards,

Mandeep Saini

[Former Member]

Hello Mike

If you so important e-mail address order

You can add additional field like "ID" or "Order" and save to it "Sequence Number" from ERP

Then modify your syndication maps

Regards

Kanstantsin Chernichenka