Generally some objects become inactive in the BW systems due processes like transports, system upgrades,   refresh  etc. This can result in the various issues such as failure of data load and execution of queries. There is no single standard program or transaction code in SAP, that could read out the inactive objects in BW Systems. The following program has been developed to list out inactive objects category-wise in ALV format.

These lists can be saved to excel sheets.

The program identifies and reports the list of inactive objects in the below categories.

  1. Multiproviders
  2. Aggregation Levels
  3. Infocubes
  4. Datasources
  5. Data Store Objects
  6. Infosets
  7. InfoObjects
  8. Transfer structures
  9. Transformations
  10. Open Hub destination
  11. DTP’s
  12. Update Rules
  13. Process Chains

File is attached with the code.

When you execute the program you get the following result:

/wp-content/uploads/2016/08/1_1020631.jpg

To have proper naming conventions go back to the se38 editor open the program follow the steps as show in below.

1. Find GOTO in menu bar text elements selection text add the selection texts activate it.

/wp-content/uploads/2016/08/2_1020635.png

2. Similarly double click on  “text-002 FOR FIELD x_call” in the code and maintain the text there

You can see the selection screen as below.

/wp-content/uploads/2016/08/3_1020636.png

Now when you execute program you get the desired naming convention.

/wp-content/uploads/2016/08/4_1020637.png

If you select all the objects in selection screen and execute, the expected output is as follows:

/wp-content/uploads/2016/08/5_1020638.png

Advantages:

Single point access to all the Inactive Objects in the BW system

Eliminating manual effort to find the inactive Objects.

Can be used in case of frequent transports with huge dependencies, pre and post system upgrades & refresh to compare the list of objects

References:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00dbbfa9-dba2-2d10-bc80-9d6489e4b1c7?overridelayout=t…

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a04dd32f-2638-2e10-5596-c5f97c400ac7?overridelayout=t…

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Philipp Schornberg

    Hi Rahul,

    looks like a nice tool. Would it be possible to select also an Infoarea, from which the search would go down from? That would make it even better IMHO.

    Regards, Philipp

    (0) 
    1. Rahul Sindhwani Post author

      Hi Phillip,

      I have basically tried to select individual objects (example DSo Info object etc), you can modify it as per requirement. Main focus was to build alv grid display and get everything in single screen in a better way.

      Thanks,

      Rahul S.

      (0) 
      1. Philipp Schornberg

        Hi Rahul,

        ok.

        I noticed now that several type definitions are missing (ZRSDCUBE, ZRSDODSO, ZRSDIOBJ,…). Could you add that information to the source code maybe?

        Regards,

        Philipp

        (1) 
        1. Rahul Sindhwani Post author

          Hi Philipp,

          For the definitions that  are missing (ZRSDCUBE, ZRSDODSO, ZRSDIOBJ,…)..etc

          You can create Z structures in data dictionary and can use them.
          Example ZRSDCUBE structure based on table RSDCUBE selecting only the required fields, such as Info provider name, Object version etc.

          This will help in determining only those columns that are required in the output.

          Thanks,
          Rahul S

          (0) 

Leave a Reply