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/we...! * </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.
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>
+
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.
* *
