Tool For Inactive Objects- Multiple ALV Grid Display Concept

[Former Member]

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:

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.

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.

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

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

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-9d6489e4b...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a04dd32f-2638-2e10-5596-c5f97c400...