on 02-06-2011 11:09 PM
Hi All,
We have been on SAP MDM Central Master Data Management scenario for more then a year now. In the pas we have seen many issues ike - Syndication server failures, idoc failures due to which the data is not 100% in synch between MDM and ECC.
Though we are working on the idoc failure tracking process but my question is this -
I need to create an automated program which runs on a weekly basis finds the data which is out of synch in MDM and FEP and gives me the same. So the logic should be something like this - Pick up the records updated during the last week in MDM, look for those records in ECC. Compare field by field and give me the delta.
Since it is a central master data management scenario hence there are cases in which records are created in MDM but not present in ECC may be because of syndication failures or idoc failures.
Any one worked n a similar sort of program/logic? Kindly let me know your experiences as well in efforts to keep the data in synch.
Regards,
Indraveer
Hello Indraveer
Yes you can do it.
You can configure exchange between ECC and MDM by schedule directly or through PI
or
SAP MDM 7.1 has own API for ABAP, JAVA, .NET. (5.5 for ABAP,JAVA, .COM)
That may be abap transaction or java(.net) application is working by schedule.
more about MDM API you can read here:
ABAP
http://help.sap.com/saphelp_nwmdm71/helpdata/en/48/edff445128209ce10000000a42189d/frameset.htm
JAVA and .NET
http://help.sap.com/saphelp_nwmdm71/helpdata/en/13/041975d8ce4d4287d5205816ea955a/frameset.htm
JavaDocs
http://help.sap.com/javadocs/MDM71/index.html
Regards
Kanstantsin Chernichenka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey,
Yeah, i have worked on this before.
There are two ways in which you can do this:
1. Write a Business Objects report which fetches data from MDM and ECC for the past 1 week, it compares the values in both the systems and gives a list of all the records which are different. Once you know the records which are different, you can manually syndicate it out. This is not fully automated (and i am not sure if it can really be fully automated).
2. Have a Interface which runs once a week, it syndicates all the records which were sent in last 1 week (filter based upon "Modify Date" parameter),if there was no discrepancy between MDM and ECC, that record won't be updated in ECC, if the records were different in both the systems, it will be updated with the latest data from MDM. This is fully automated.
Thanks
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the replies.
We do not have BO therefore won't be able to leverage that option.
We are thinking to create an automatic port which syndicates all the records updated during last one wee, every saturday.
My next question - Is there any way in the free form search expression using which we can save the search to get records updated last week (something like - Update Date < last monday or last week)?
Hi Indraveer,
For Weekly syndication, SAP MDM provides you the standard option mentioned below. I dont think you will need to write a expression for it.
Create a Port, Processing Type = Automatic, Pricessing Interval = Weekly.
There you can select the date for the first week.. which say is Monday.. then from next week onward MDM will automatically syndicate the record every Monday.
For the map assigned to this port, Select Suppress Unchanged Records.. so only the new/updated records of the week will be part of the output file.
Thanks,
Priti
Edited by: Priti Rani Patnaik on Feb 8, 2011 6:27 PM
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.