Multiple BW connection - Plan to export/import RSBASIDOC table
I'm experiencing an issue at the moment as per below cronology:
- Did client copy from AB7 to UB7 (BW system) and A16 to U16 (ERP system)
- Made BW connection between UB7 and U16 with IDoc type ZSPC004 via RSA1 restore
- Did client copy from AB7 to MB7
- Made BW connection between MB7 and U16 with IDoc type ZSPC004 via RSA1 restore
After I executed 4th step, I had an issue with U16 and UB7 connection due to the Idoc type in U16 was replaced by connection between MB7 and U16. Then we had to make some manual creations for iDoc type, partner profile, and re-connect the system manually for the impacted system.
Understand if there is SAP Note to export all of the BW objects from source system and import it into the target system. But as we have a lot of BW objects to be converted, hence we did do this way.
Other than the above problem, our BW system is also connected to multiple system and for each system refrehs we must do manual reconnection, which is quite manual way, to open the client, and re-run the restore, especially if the systems blong to another party so we must arrange acoordingly.
We would like to check with you, whether is there any other workaround on this? Such as exporting RSBASIDOC table before the refresh and importing it as part of system refresh post step. Have anyone tried it before and did it work?
Appreciate for your feedback and suggestion.
Thanks and Regards.