Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Tables used in all my reports

I've got about 120 reports that are using Tables. views, or stored procedures(SQL Server).

I need to make a list of all tables that these reports are using. Is there an easier way to get this info then opening each report up in design view and listing them down?

replied

Hi Mike,

Opening the reports then going into Show SQL Query and copying the From clause from the query and pasting into your documentation would work. Again you do have to open each report.

If you're bold, you could create a small app in VB that will open the report for you and retrieve the tables, then you could do with them whatever you want.

Good luck,

Brian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question