Is there any table that relates BEx queries and BEx workbooks ?

[former_member186526]

Hello Gurus,

I was trying to get the list of BEx workbooks with BEx query list, but i don't see any table that has that relation.

Can someone who already have this experience help on this?

Thanks

John

[bhavinvyas · Accepted solution]

Check table RSRWORKBOOK which contains the WORKBOOKID and the GENUNIID.

Table RSRREPDIR contains GENUNIID, query name RNAME AUTHOR LASTUSER INFOCUBE

Table RSRINDEXT contains the WORKBOOKID and workbook TITLE

You should join the tables by GENUNIID and select in RSRREPDIR the rows that have COMPTYPE='REP' for queries and object version active/modified.

With this information an infoset query can be created to list all workbook-query-user relationship (and even the query-infocube relationship).

Check following thread for more details.

https://scn.sap.com/thread/842812

Thanks,

Bhavin Vyas

[former_member186526 · Accepted solution]

Hello Bhavin ,

Thanks for the information, but what i can see here is duplication of GENUNIID and some duplication of Workbook ID, What does it mean ? Can i take out the unique values and use it ? Because i'm getting 4000 workbook list for my search of 400 queries, which  is not at all realistic.

Please help me explain how a GENUNIID will work ?

Thanks

JOhn

[Former Member · Accepted solution]

http://scn.sap.com/people/deepak.chavan4/blog/2011/10/10/get-list-of-workbooks-in-roles-and-queries-...Get list of workbooks in roles and queries included in workbooks.

Hello John,

I am not sure about 400:4000 ratio.

But if workbook contains multiple queries, you could see duplicate workbook ids I suppose.

Refer to this blog link.

You may need to transport this code to Prod, if you are doing this in Prod.

Regards

[former_member186696]

Dear John,

There are several threads, blogs, documents about this topic on our SCN. This is a duplicated subject.

Kind Regards,
Edward John
SCN Moderator

[former_member13353]

Hi John,

The best way is use the report RSR_WORKBOOK_ADMINISTRATION

You can filter per responsible, "with/without" Data provider, Version (3.X, 7.X), etc.

Regards,

[Loed]

Hi,

These are the tables of queries and workbooks, just play with them..

Queries
RSZELTDIR	Directory of the reporting component elements
RSZELTTXT	Texts of reporting component elements
RSZELTXREF	Directory of query element references
RSRREPDIR	Directory of all reports (Query GENUNIID)
RSZCOMPDIR	Directory of reporting components
RSZRANGE	Selection specification for an element
RSZSELECT	Selection properties of an element
RSZELTDIR	Directory of the reporting component elements
RSZCOMPIC	Assignment reuseable component <-> InfoCube
RSZELTPRIO	Priorities with element collisions
RSZELTPROP	Element properties (settings)
RSZELTATTR	Attribute selection per dimension element
RSZCALC	Definition of a formula element
RSZCEL	Query Designer: Directory of Cells
RSZGLOBV	Global Variables in Reporting
RSZCHANGES	Change history of reporting components

Workbooks
RSRWBINDEX	List of binary large objects (Excel workbooks)
RSRWBINDEXT	Titles of binary objects (Excel workbooks)
RSRWBSTORE	Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE	Assignment of Excel workbooks as personal templates
RSRWORKBOOK	Where-used list for reports in workbooks

Regards,

Loed