SAP MDM -how to reflect data changes.

[Former Member]

We have a requirement where whenever basic data(30-40 fields)  of a material  is changed in ECC system and is sent to MDM, then
approval of the changed Basic Data should happen in Portal before that data is sent to downstream systems.

For this , a  new UI will be created in Portal to fetch only those records from MDM whose basic data
has changed since the last update. So the query is how can this might happen in MDM, as of now, we are not having any workflows in MDM, is it possible to have a new calculated field  whose status changes to ‘True’ whenever the material is updated with the changes in basic data.

Please suggest how this requirement can be achieved in MDM.

[Former Member · Accepted solution]

Hi Surbhi,

There could be one simple solution to this.

Plase try this -

• Create a Timestamp field which tracks changes to all fields
• Create a Timestamp field which tracks changes to only 30 fields mentioned.
• Create a calculated field with expression like If(Timestamp all = Timestamp few,TRUE,FALSE)

So this calculated field should hold a value TRUE when other fields 30 required fields are updated and a FALSE value when other non required fields are updated.

Now you can use this flag in syndication map as filter or workflow validation or portal driven syndication.

Please feel free to come back with queries.

Thanks,

Ravi

[Former Member]

Thanks you all for your inputs,issue is solved.

[Former Member]

Hi Surbhi,

Let me just confirm my understanding of the issue first.

Whenever data is changed in ECC for few fields of Material, Data is being sent to MDM inbound ports for auto import into MDM system. Further approval should be done using Portal interface and after the approval, Data should be distributed to various destination systems.

To achieve this:

• You can create one field in MDM Main Table called "Approval Status" or you can use some already created field.
• Whenever data is being imported into MDM through Import Map, you can set Approval Status to "Submitted".
• Now the UI you are creating, can search for all the records in Data Manager having Approval Status as "Submitted" and populate the records on user's screen(This population can be done whenever concerned approver logs in to Portal to avoid using any workflow in either portal or MDM).
• Once the records are approved, set Approval status to "Approved". Here, you can leave the records in Submitted status which are Rejected by approver.

• To syndicate records only after approval, We can create ports with Syndication map property set as "Suppress Unchanged Records" and Search Criteria will allow the records with Approval Status as "Approved" only to be syndicated.

• One more automation could be added that whenever updated data is extracted and sent to PI interface from ECC, an email could be sent to approvers that "You are requested to approve the changes of Material Data in portal", and link of Portal could be sent in the email.

So this will remove manual follow up and coordination to some extent. Please let me know your thoughts on this and share views.

Thanks and Regards,

Ankush Bhardwaj

[Former Member]

Surbhi,

You can achieve your requirement using two Time Stamp fields + one Validation + one Workflow configuration but not sure, if you want to use workflow.

Please refer to the How To… Activate Field triggers for Syndication document. Hope, this will help you.

Thx/ -Tarun