cancel
Showing results for 
Search instead for 
Did you mean: 

Synching the data between MDM and ECC

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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)?

Former Member
0 Kudos

Yeah, it can be done in free-form search.Expression will be something like below

Modify_Date >= SysDate - 7.

Thanks

Aamir

Edited by: Aamir Suhail on Feb 7, 2011 4:14 PM

Former Member
0 Kudos

Thanks Aamir. But how to write or get the system date? any operation/field?

Former Member
0 Kudos

Use ABS(SYSTIME(0))

Thanks

Aamir

Former Member
0 Kudos

Unfortunately I am not able to write the expression. Can you please write it in full?

Former Member
0 Kudos

Hi Indraveer,

Please use the following expression, it is working fine at my end

Update Date >= SYSTIME((NEGATE(7))

Regards,

Mandeep Saini

former_member208981
Contributor
0 Kudos

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