Showing results for 
Search instead for 
Did you mean: 

Queries in Work Book

Former Member
0 Kudos

Hi ,

I need to write a Bex report which satisfies the Following Condition

1. If i give input = Work Book , I must get all details

about Queries contained in that Work Book.

2. If i give input = Qurey name , I must get the Work

books List which has that particular Query .

How to accompolish This ......

Message was edited by:

Kumar BI

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

Is this the Only way , Is there any standard Technical Content Queries Available ... Because if there is a Standard Query it will be easier

Can you check this link and tell me if any query listed could help on this Issue ..

<a href=""></a>

Active Contributor
0 Kudos

hi Kumar,

the idea is you need a 'table' store link for all workbooks and queries.

i think you can try to create an infoprovider with infoobject 0TCTQUERY and 0TCTWORKBK and populate with data from table RSRWORKBOOK

and RSRREPDIR (generic extraction datasource using view ?), the link for these 2 tables is GENUNIID, fill 0TCTQUERY with COMPID from RSRREPDIR and WORKBOOKID from RSRWORKBOOK. also load text for 0TCTQUERY and 0TCTWORKBK.

hope this helps.