Consolidating data of SAP Business One
I wish to consolidate data within SAP Business One. Now, the scenario here is,
I have 4 subsidiary companies using SAP Business One at each end, also the head office where the data is to be consolidated uses SAP B1. Can I be able to consolidate the subsidiary companies data into head office using SAP MDM?
I have read few articles on SAP MDM which helps consolidating data, but each article suggested to have R3 at the head office end. Is SAP MDM compatible with SAP B1?? Will it help me consolidate data if I have B1 at target end??? If not SAP MDM what other means through which I can use to consolidate data within SAP B1??
Yatsea Li replied
SAP MDM is a Central Master Data Management for different sources(ERP, CRM, SCM etc) for Keep Data Consistence and Data Unification, Improve Data Quarlity. Avoiding incompleted , unconsistent and duplicated master data. Serve as Global and Unique master data source for several IT system. Technical speaking, yes, you can use SAP MDM as your global master data source, while it is too heavy for small business. Your case is Master Data Synchonization. I am queried with this scenario before. I will suggest to have a Central Master Data Sychonizer AddOn in you B1 landscape.
1.Listen the creation, updating, deletion of master data via FormDataAdd,Update Event or SBO_SP or DI Event Service.
thus any change in master in each side will be notified, then save it into XML
2.Import into Head Quarter DB with XML. Either Schedule to run DTW to do so, either do it in your addon.