I am faced with a situation where my company has grown by acquisition and is looking to create a BW instance (our first!) loading from multiple ECC sources.
I feel I am shortly going to be faced with a number of issues including how we are going to manage the masterdata in BW. managing the data coming into important object like 0Material and 0BPartner are going to get complicated when there are differences in each system
- Overlapping number ranges
- Different codes, same material
- Same codes, different
- Different legal structures So things like...in US we are 1 CoCode and different sales orgs, in Europe we are set up with entirely different CoCodes for each sales org)
Is there any documentation you can point me to on how we might be able to handle this scenario in BW? Some pointers about things to think about.
Before you all rush and say 'MDM!' I dont think we are going to have the budget to bring in yet another SAP product... where possible we need to do this in SAP BW itself.
Any white papers anywhere?
thanks so much for help