What systems are connected to my BW?

Recently for purposes of one SAP BW upgrade project I needed to find out what systems are connected into particular BW. Easy way is to run t-code RSA1 and loot at Modeling -> Source systems. Of source I needed to have more technical information about the sources. Also I wanted to have a central source of this information so I dig into the system to find out what table stores this information. It is RSBASIDOC – Assignment of source systems to BIW systems incl. IDoc type. The table as all about source system connections, status of particular connection, what kind of IDOC Basic type is used for the connection, prefix used for particular source system, etc.

Let’s have a closer look at all its fields:

SLOGSYS      log.name of system connected to the particular BW system

RLOGSYS      log. name of receiver; identifies BW system into which SLOGSYS is connected to

OBJSTAT      Object Status; wheatear connection is active (ACT) or inactive (INA)

BIDOCTYP    IDoc Basic type used for the connection

TSIDOC3X    Transfer structure 3.x number state for a source system; not used in BW 7.x

TSPREFIX     Transfer structure prefix for a source system; 2 chars used in field BIDOCTYP; it identifies the source system connection for source system dependent objects

SRCTYPE      Type of the source system: 3 = SAP R/3 from version 3.0D onwards; B= External system, data staging done by BAPI; M = used for connection of BW itself (myBW); D = SAP BW system; F = External system based on File; G = DB Connect type of source system; S = UD Connect type of source system; I = Web Service type of source system

SAPREL        Release of SAP System (version of SAP Basis component)

TSTPNM       User who changed it last

TIMESTMP    Time Stamp of the last change (in format YYYYMMDDhhmmss)

SBWBCRL     Release of SAP Sending System

RBWBCRL     Release of SAP Receiver System

So to answer my question from the title of this blog spot: go to the RSBASIDOC table and look at values of SLOGSYS field.