Skip to Content
Author's profile photo Renjith Kumar Palaniswamy

BW Source system consistency checks

During BI implementation we need to connect multiple source system to BI system, then only we can load the data. In this blog we will see various consistency checks for source system related issues. I have explained this more detail in my SAP note 1478123, If you need more info do check that note too. Here we will discuss about some factors.

h3. 1.Source system Types

We can connect multiple source system to BI system, It can be a SAP system, Non SAP system, Other RDBMS, from Flat file Etc. we can see the different source system types here.

</p><p>Note </p><p>When you enter RSA1 in BI system for first time, the myself source system is created by default and the entry is stored in relevant table.</p><p>!https://weblogs.sdn.sap.com/weblogs/images/251826996/one.jpg|alt=|src=https://weblogs.sdn.sap.com/weblogs/images/251826996/one.jpg! * </p>h3. 2.Check Table RSBASIDOC .

RSBASIODC is table that has info on source and bw system assignment, here SLOGSYS represents sender and RLOGSYS represents target system. The status shoud be active.

In case of myself source system, the SLOGSYS and RLOGSYS will have the same value.

!https://weblogs.sdn.sap.com/weblogs/images/251826996/two.jpg|alt=|src=https://weblogs.sdn.sap.com/weblogs/images/251826996/two.jpg!

h3. 3.Authorizations

The RFC user on BW, receiving data from OLTP system, should have profiles:

S_BI-WHM_RFC

The RFC user on OLTP, receiving request from BW system, should have profiles:

S_BI-WX_RFC

Human administrator in both systems with S_RS_ALL

See *Note 150315 *for more information

 

h3. 4.Partner profile check

Check the Partner Type LS parameter setting of transaction WE20 in both systems and search the logical system name in Partner Type LS:

 

In BW system: Search for the logical system name of the source partner system

</p><p>Outbound message type:</p><p>RSRQST ‘ double click ‘ receiver port ‘ double click  ‘ RFC    destination ‘ make sure that this RFC points to the correct    source system in sm59</p><p> </p><p>Inbound message type:+

   RSINFO

+   RSSEND</p><p> + 

In Source system+: +Search for the logical system name of the BW partner system

</p><p>Outbound parameter</p><p>RSINFO ‘ double click ‘ receiver port ‘ double click ‘ RFC destination ‘ make sure that this RFC points to the correct BW system in sm59</p><p>RSSEND ‘ double click ‘ receiver port ‘ double click ‘ RFC destination ‘ make sure that this RFC points to the correct BW system  in sm59</p><p> </p><p>Inbound Parameter</p><p>RSRQST</p><p> </p><p>+

!https://weblogs.sdn.sap.com/weblogs/images/251826996/three2.jpg|alt=|src=https://weblogs.sdn.sap.com/weblogs/images/251826996/three2.jpg!  

h3.  5. Disconnect obsolete links in BW

In the R3 system execute the function module+ RSAP_BIW_DISCONNECT to  disconnect all obsolete BW links. Never execute this function module ina BW system</p><p>Go to Transaction SE37 – function module *RSAP_BIW_DISCONNECT *</p><p>Single Test.  Parameter</p><p>          I_BIW_LOGSYS = <RLOGSYS> of RSBASIDOC</p><p>          I_OLTP_LOGSYS =<SLOGSYS> of RSBASIDOC</p><p>          I_FORCE_DELETE = ‘X’.</p><p>DO NOT enter a value in the “RFC target sys+” field. If you do, this causes the function module to run in the system specified there.

If you have further doubts, you can get info from SAP note 1478123.

* *

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.