Table for queries

[Former Member]

Hello all,

I have a list of queries and require a table which would fetch the corresponding inforpovider names .

Regards,

Sunitha

[Former Member]

Hi,

Go to the Table RSRREPDIR. Make sure you select the fields Infocube and Query.

Enter you list of queries. Click on execute. It will display the list of Queries with the Infocube names.

YOu can also check other details like - author, Query Generation Time, Data last changed by, Query Generation Time,

etc... in the same table.

Hope it helps.

[MartinMaruskin]

RSRREPDIR is your table

[Former Member]

Hi ,

I am not sure about this one , but can you check this table rszdeltir .

Regards,

Ashutosh Singh

[rajkumar_kandula]

Hi Sunitha,

Check the below tables if they can help you.

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

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

Reagards,

Raj