Query and workbooks

[Former Member]

What tables can give me the details of the queries in a workbook? Thanks

[Former Member]

hi

This is stored in different tables, the table RSRWORKBOOK contains the list of queries assigned to a workbook. You will have to use the 25 char UID of the workbook or query. The table RSRWBINDEX contains the information on who created the workbook, when etc..

[Former Member]

Hello,

Metadata repositary will help you know the workbooks on a query!!

also check out tables RSRWORKBOOK and RSRWBINDEX.

also check out table AGR_HIER for roles and workbooks.

check also SE37 > RSCR_WORKBOOK_PROPERTIES.

sorry as dont have the system right now...

thanks,

[Former Member]

Nitin,

Would you like to have a look on following AHP Replies?

Regards,

Hari