Objective:

Every organization use multiple reports like Sales, Shipping, Billing and Profit & Loss to make good business decision. In this all areas we might have developed and used huge BEx reports, in all reports we might restrict (include/exclude) characteristics(like 0MATERIAL, 0PLANT) values 1001, 2002 for company codes, S01, S02 for Sales organization , Doc Type , Plant to meet business report requirement.

Every organization will expand their business, as part of business growth organization might merge or establish new plant, company codes, sales organizations etc.

Technical Impact due to organization changes.

Due to organization changes we might get into technical challenges/issues for example as part of business expand Company ABC new plant has been acquired (Plant 0567) and now I would like to include this new plant wherever already nearby plants (0545) included to same area manager to analysis inbound/outbound business data,  for this I need to search where existing plant 0545 is restricted so that I can include new plant 0567.

Approaches to find 0545.

  • Search manually respective reports in BEx designer like Filters Area, Default Area, Restricted Key Figure  and Selections, etc….might be restricted anywhere in report like cells, so its very tough job if its complex report’s
  • Search in table level,  however its required skill like BEx tables and relationship between tables
  • Search through FM however its gives unstructured data, need to format and also it works one report at a time.

Solution “One Click Away”

So, I had written ABAP program which will give list of reports which are restricted by given Infoprovider/InfoObect and characteristics value.

Here we can search based on Multiprovider/InfoCube/DSO OR Infoset wise, we have to select Radio button based on requirement as like below


/wp-content/uploads/2015/08/1_771379.png

Example for Mulitprovider.


Example 1

Now, I am searching based on Mulitprovider/InfoCube and selections as like below


Multi/Cube Tech Name: ALL (Means all Mulitproviders and Infocubes)


Infoobject Tech Name: 0PLANT (For Plant) You can give more infoobjects at a time.


Infoobject Value          : ALL (Means for All Plants).



/wp-content/uploads/2015/08/2_771417.png

Output:


Provides list of reports restricted by All 0PLANT values


Example 2

Now, I am searching based on Mulitprovider/InfoCube and selections as like below


Multi/Cube Tech Name: ALL (Means all Mulitproviders and Infocubes)


Infoobject Tech Name: 0PLANT (For to Plant) you can give more infoobjects at a time.


Infoobject Value            : 1111 (Where Plant equal to 1111).


/wp-content/uploads/2015/08/3_771431.png

Output


Provides list of reports where plant restricted by 1111


/wp-content/uploads/2015/08/4_771422.png

Example for InfoSet.

Example 1


Now, I am searching based on Infoset and selections as like below


Multi/Cube Tech Name : ALL (Means all Infosets)


Infoobject Tech Name  : 0PLANT (For Plant) You can give more infoobjects at a time.


Infoobject Value            : ALL (Means for All Plants).


/wp-content/uploads/2015/08/5_771432.png

Output:


Provides list of reports restricted by All 0PLANT values


Example 2

Now, I am searching based on Infoset and selections as like below


Multi/Cube Tech Name: ALL (Means all Infosets)


Infoobject Tech Name: 0PLANT (For Plant), You can give more infoobjects at a time.


Infoobject Value            : 111 (Where Plant equal to 111).


/wp-content/uploads/2015/08/6_771433.png

Output


Provides list of reports where plant restricted by 111

/wp-content/uploads/2015/08/7_771426.png


Attached ABAP Code.



Note:

  • Added code, provided option to  search ODS wise also,
  • And changed selection screen sequence for more convenient


Thanks for reading Blog.



To report this post you need to login first.

4 Comments

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

  1. Peter Chen

    These BW ABAP programs are great.  I had done a program to locate where an infoObject is used…you went a step further…Splendid.

    Thanks for sharing.

    (0) 

Leave a Reply