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 |
|
DataStore Objects |
|
IOBJ |
|
InfoSources |
|
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
tnx
K M R