Skip to Content
Author's profile photo Suresh Ramajeyam

Finding KPI’s Where Used in Bex Queries.

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….

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Suresh,

      Thanks for sharing wonderful information.

      Regards,

      Bansi

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      Bansi,

      Thanks.I was glad to do it.

      Suresh

      Author's profile photo Phani KV
      Phani KV

      HI,

      Good blog suresh.

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      Thanks Pani.

      Author's profile photo Former Member
      Former Member

      Nice man.

      Author's profile photo Rajat Kumar Sahu
      Rajat Kumar Sahu

      Thank you Suresh for most seeked information.

      Regards,

      RKS

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Good workaround to meet the requirement 🙂 . Thanks for sharing with the community 🙂

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      Thanks Suman.

      Author's profile photo Former Member
      Former Member

      Thank you Suresh. It is very helpful.

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      You Welcome!