How to compare objects between systems

[Former Member]

Hi,

At the moment I am busy activating business content in BW for an SAP IS-U project. Here I encounter the following problem:

In the past others have been activating business content objects and they have assigned a developer class to it. Then they decided they did not need those objects and they deleted their transports.

Now when I want to transport objects to the acceptance environment quite often transports fail due to missing objects (which have never been transported). The automated activation does not include these dependent objects, as it thinks they are already available.

Is there a way to compare two systems to see which objects are missing and need transporting (without sifting through each InfoObject/transfer rule etc by hand to check its existence)?

Preferrably I would like to know table names so I can compare SE16 lists, but other suggestions are also more than welcome.

Otherwise an easy way to see the technical names of those objects so that I can add them manually to a transport request?

Thank you very much,

Crispian

[Former Member · Accepted solution]

Hi Crispian,

Welcome to SDN!!

You can use the following tables for comparing:

RSDIOBJ - For info-objects

RSDCUBE - For Cubes

RSDAREA - InfoAreas

RSDCHA - Characteristic Catalog

RSDCUBEIOBJ - Objects per InfoCube (where-used list)

RSDIOBC - InfoObject catalogs

RSDIOBCIOBJ - InfoObjects in InfoObject catalogs

RSDKYF - Key figures

RSIS - InfoSource (transaction data)

RSTSRULES - Transfer structure transfer rules

RSDODSO - ODS

Hope this helps.

Bye

Dinesh

<i>Assigning point to the helpful answers is the way of saying thanks in SDN. you can assign points by clicking on the appropriate radio button displayed next to the answers for your question. yellow for 2, green for 6 points(2)and blue for 10 points and to close the question and marked as problem solved. closing the threads which has a solution will help the members to deal with open issues with out wasting time on problems which has a solution and also to the people who encounter the same porblem in future. This is just to give you information as you are a new user.</i>

Message was edited by: Dinesh Lalchand

[Former Member · Accepted solution]

Thank you for your quick reply, Dinesh. This list looks really promising!

Since I am not too experienced with BW yet, I am not sure how to use the info properly.

Say I have the InfoSource 0UC_ISU_01 (Sales Statistics in IS-Utilities). What would be the best approach to check if all the included InfoObjects are available and things are consistent?

Since I am an ABAP developer I am thinking about writing a small program to check this automatically.

With kind regards,

Crispian

[Former Member · Accepted solution]

Hi Crispian,

you have to check if (for example) there is difference among infoobjects contained in RSDIOBJ table (you can join RSTSRULES entries if you want to start from the infoobject related to a specific infosource)...if in one system an object is present with OBJVERS 'A' (this means that the object has been installed) and in the other one only in 'D', you have to transport its activation !

Hope it helps!

Bye,

ROberto