Queries in Work Book

[Former Member]

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

[Former Member]

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="http://help.sap.com/saphelp_nw04/helpdata/en/88/3e1f3b5839e10fe10000000a114084/content.htm">http://help.sap.com/saphelp_nw04/helpdata/en/88/3e1f3b5839e10fe10000000a114084/content.htm</a>

[edwin_harpino]

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.