I can see many requesting how to check the queries inside a workbook during the last year. The steps are quite simple, and I will sumarize 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) - RSRPREPDIR
OBJVERS = A
COMPID = ZEDD_TEST3
Step 2 - Access table (SE16) RSRWORKBOOK
Basically, RSRWORKBOOK.GENUNIID = RSRPREPDIR.GENUNIID
So, for my case:
GENUNIID = 4UBUGC2QE23K7REMTHZQ5W3E9
OBJVERS = A
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.
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:
- Table RSRWORKBOOK - Search for your workbook, on version A.
- Copy all GENUNIID
- Go to table RSRPREPDIR and paste the GENUNIID there.
Future works: It is possible to consider a creation of a REPORT to check automatically.