Replicating SAP BW datasources automatically
Since a long time ago I’m back into SAP BW datawarehousing, currently I’m working in a project where SAP BW is a main focus. From datasources to BEx queries…. I need to retrieve my knowlegde from years ago :-) During a transport procedure on the ECC side from development to test I transported some datasources. Normally after every transport with datasources, a manual replication for the datasources on the BW side is necessary. I found a simple solution that you will not need replicate the datasources manually. If you add an object into your transportrequest, the replication can be automatically be done.
Follow the next procedure to replicate your datasources automatically:
- Modify your current transportrequest with the datasources in SAP BW
- In your BW transport add an extra object “ISFS” with program ID “R3TR”
- Save your transportrequest
- Transport your request to the next environment (be sure that de datasources will exist on the source side, i.e. ECC)
This is not a new solution, but it’s very useful to share :-).