How to find all the reports which are based on a particular table from the database

[SAPSupport]

Requirement to find all the reports which are based on a particular table from the database. Please confirm if this is possible to get the list? If yes how we can get it.

Note that many of the reports use custom SQL and have more than 300 reports in the system. It is very time consuming activity to find tables from each query. In single report also sometimes there are more than 5 queries.

SAP Product version :BI 4.2 SP8 P6

Database: Oracle 12C

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Referred Blog

https://answers.sap.com/questions/13646909/table-use-in-bo-reports.html

https://answers.sap.com/questions/9420146/how-to-identify-the-reports-referencing-to-particu.html