Automate tool Program to check the dependency Queries where same calculated / Restricted Key Figure are used.

Purpose of this as follows :–>

The goal of this work is to create a new tool to find out the total query name where the same calculated and restricted key figures are used Calculated Key Figures CKF/ Ristricted Key Figures (RKF).

This initiative was born because recently we faced the same issue in production when someone has changed for example the structure of CKF Z_XXX_XXX in one or several queries and this change have produced an impact in the others queries that have a dependency with the modificated query.

Conclusions : Before making any changes in CKF/RKF (in fact in X or Y also) please use this tool to find out the dependency Queries and impacts. And then consult with leads and do the changes accordingly.

Creates the following program through transaction SE38 as per the following screen-shots.

      Creates ZFIND_KF_QUERY program–>

     /wp-content/uploads/2016/05/p1_944670.png

     Attributes of the Main Program:

         

          /wp-content/uploads/2016/05/p2_944671.png

     Text elements used in the Main Program:

          

               /wp-content/uploads/2016/05/p3_944672.png

Selection Screen Texts used in the Main Program:

          /wp-content/uploads/2016/05/p4_944673.png

Use Calculated Key figure:

  Step 1: Put CKF: Z_SUM_REV in the selection screen and execute this program.

     

          /wp-content/uploads/2016/05/p5_944674.png

Step 2: Now you can display the next output.

             

               /wp-content/uploads/2016/05/p6_944675.png

In That way you can find the dependency Queries name before any changes in CKF and RKF Key Figures. These program given as dependency query lists.


Custom Code should be as follows :–>


Attached as Txt Files.

Thanks & Regards,

Puneet

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply