I can see many requesting how to check the queries inside a workbook during the last years. The steps are quite simple, and I will summarize these steps here.

If you want to check which workbooks have an specific query as dataprovider, you need to know the query technical name.
As example, I will use my query with technical name ZEDD_TEST3.

Step 1 – Access table (SE16) –  RSRREPDIR 

/wp-content/uploads/2016/01/1_877459.png

OBJVERS = A

COMPID =  ZEDD_TEST3

Execute(F8)

/wp-content/uploads/2016/01/2_877469.png

Step 2 – Access table (SE16) RSRWORKBOOK

Basically, RSRWORKBOOK.GENUNIID = RSRREPDIR.GENUNIID

So, for my case:

/wp-content/uploads/2016/01/3_877471.png

GENUNIID = 4UBUGC2QE23K7REMTHZQ5W3E9

OBJVERS  = A

Execute(F8)

WB.png

We can see that I have only one workbook with my query.

Workbook ID is 3EGGEJQPR1MX5CKP6AFH0Q8DB

If you need to know the workbook title, access table RSRWBINDEXT and use the workbook id on the proper field.

/wp-content/uploads/2016/01/4_877472.png

All steps mentioned are also valid if you have to check which queries an specific workbook is used.

For this case, you have to do the reverse path:

  1. Table RSRWORKBOOK – Search for your workbook, on version A.
  2. Copy all GENUNIID
  3. Go to table RSRREPDIR and paste the GENUNIID there.

Future works: It is possible to consider a creation of a REPORT to check automatically.

To report this post you need to login first.

1 Comment

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

Leave a Reply