Skip to Content
author's profile photo Former Member
Former Member

SAP MDM -how to reflect data changes.

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Nov 07, 2012 at 04:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2012 at 04:36 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2012 at 06:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2012 at 05:31 AM

    Thanks you all for your inputs,issue is solved.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.