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.
