Multiple BW system One SAP ECC sourcesystem

[former_member302630]

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

[sander_vanwilligen]

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:

• SAP Note 775568 - Two and more BW systems against one OLTP system;
• SAP Note 844222 - Two OR more BW systems against one OLTP system.

Best regards,

Sander

[Former Member]

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

[Former Member]

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 🙂