Question Re: Multiple BW system One SAP ECC sourcesystem in Technology Q&A

Multiple BW system One SAP ECC sourcesystem

former_member302630 — Tue, 08 Mar 2016 09:12:51 GMT

Hi,

My client has planned to connect 3 SAP BW systems to one ERP system. I am wondering how to solve maintaining datasources deltas for 3 BW systems in one ECC system.

Is there any how to.. document for multiple BW systems to one SAP ECC system? how to connect and maintain deltas and extraction logic for multiple BW systems?

Regards,

Cleo

Re: Multiple BW system One SAP ECC sourcesystem

Former Member — Tue, 08 Mar 2016 11:15:46 GMT

1/ Your delta queues in your ECC will always be linked to the specific BW-system. So if you have the same datasource in the 3 BW environments and initialise a delta for it, you will find 3 entries to the specfic BW systems in your RSA7 in ECC

2/ Concerning extraction logic: if you want different user-exit processing depending on the BW system using the DAtaSource, you will have to code that wia IF-ELSE or CASE statements. I'm confident that during extraction you will have a parameter syaing which is the source system, but i don't know it 🙂

Re: Multiple BW system One SAP ECC sourcesystem

Former Member — Tue, 08 Mar 2016 14:34:40 GMT

Datasources work perfectly without any issues into multiple target systems. I am not able to load more documents but I will doing so soon. For starters, please follow below document.

I have implemented Finanance/Controlling, Inventory, Sales, Services, Purchasing datasources including standard/setup table based and custom datasources. All work fine and they work based on logical system delta queues. So if you have seperate logical systems created for each BW system then you should not have any issues.

Thanks

Amit

Re: Multiple BW system One SAP ECC sourcesystem

sander_vanwilligen — Tue, 08 Mar 2016 17:58:22 GMT

Hi Cleo,

Basically the RSA7 delta is capable of multiple connected BW systems. Logical System is identifying the different delta queues for the same DataSource. However, you have to be careful with parallel extraction by the two BW systems because they could interfere in case of timestamp delta mechanism (as is the case for DataSource 0FI_GL_14). Please refer to the following SAP Notes for more information:

Best regards,

Sander