Collection of Dependent Objects in a Transport Request

Changes to BW objects and transporting those objects to another system is something that occurs quite often.

So now what happens when let’s say an infocube is changed and collected in a request? The DTPs associated with it are turned inactive!! The Multi Providers that use this particular info cube are inactive!!

And when these objects are not collected along with the infocube and when the corresponding request is transferred, this in turn would make the dependent objects inactive in the Quality and Production systems!

So When objects are collected in a request, it is considered to be a best practice to check if the dependent objects are also collected in the request.

Here is a list of objects and their dependent objects.

Object	Dependent Objects
InfoCube	DTPs that load from and to this infocube Transformations from the cube to further targets Transformations from the sources to this cube Multi Providers which use the infocube
DataStore Objects	DTPs that load from and to this DSO Transformations from the DSO to further targets Transformations from the sources to this DSO Multi Providers which use the DSO
IOBJ	DTPs that load from and to this DSO Transformations from the DSO to further targets Transformations from the sources to this DSO
InfoSources	Transformations from and to the infosources All Dtps for targets associated with this infosource
DTP	Error DTP for this DTP
Transformations	All DTPs associated with the target

Now to identify the list of inactive objects in the system, I have listed below the tables that can be checked.

1) Datastore objects

Goto table RSDODSOLOC and pass the input DSO name. (Let the objvers and activefl be blank when you pass values)

The DSO is inactive when:

a) When you find an entry with OBJVERS = “A”, OBJSTAT = “ACT” and ACTIVFL = “ “.

b) When you find an entry with OBJVERS = “M”, OBJSTAT = “ACT” and ACTIVFL = “ “.

c) When you find an entry with OBJSTAT = “INA”

For eg: The DSO ZTRDSO is inactive because an info object has been added.

The table RSDODSOLOC has the following entry for the DSO

As said earlier, the ACTIVFL flag is blank for the DSO that is inactive.

Case 2: Lets take another example – DSO DSO_SE is active

Hence the table has the entry with ACTIVFL = “X”

Similarly for other objects you can verify the following tables:

All the objects have the same conditions to be checked for inactive status. If either of the below mentioned conditions satisfy, then the object is said to be inactive

a) When you find an entry with OBJVERS = “A”, OBJSTAT = “ACT” and ACTIVFL = “ “

b) When you find an entry with OBJVERS = “M”, OBJSTAT = “ACT” and ACTIVFL = “ “.

c) When you find an entry with OBJSTAT = “INA”

Infocube RSDCUBE

MPRO RSDCUBE (with cube_type = “M”)

InfoObject RSDIOBJ

InfoSource RSKSNEW

Transformation RSTRAN

DataSource RSDS

DTP RSBKDTP