To find the KPI’s (CKF, RKF,Formula) where used in Bex queries.

Access required to SE11/SE16, SE37.

Views – V_COMPDIR_COMPIC

Steps to Follow

  1. Go to SE11/SE16
  2. Enter the View Name – V_COMPDIR_COMPIC

/wp-content/uploads/2014/06/1_477618.png

3.Select a Definition type of an Element with A version, I am selecting  RKF here.

/wp-content/uploads/2014/06/7_477619.png

4. Execute and get the COMPUID .

/wp-content/uploads/2014/06/2_477626.png

5. Go to SE37 , use the FM RSZ_DB_COMP_WHERE_USED

/wp-content/uploads/2014/06/3_477627.png

6.Input the COMPUID  got from STEP 4 into I_COMPUID

/wp-content/uploads/2014/06/4_477628.png

7.After Execution you will get the where used list entries as highlighted/wp-content/uploads/2014/06/5_477632.png

8. 9 Entries shown below. Since i have chose RKF, the list shows the RKF’s used in CKF’s and the query names

/wp-content/uploads/2014/06/6_477633.png


PS : You can get the COMPUID  from the table  RSZELTDIR .By choosing the needed element definitions , input the COMPUID in the FM.


Hope this helps….

To report this post you need to login first.

10 Comments

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

Leave a Reply