How to retrieve Sql of a Derived table

[Former Member]

Hi Experts,

BO 3.1

We require to document the SQL behind the Derived tables in Our environment .

Each universe has 40 Plus derived tables  and we have 40 universe.

I can go through each universe List of derived universes and manually enter the sql for each table.

But that will require a Lot of effort . Is there a simpler way / workaround/ Macro / code which can be helpful 

[Former Member · Accepted solution]

I cannot vouch for how this works, but this tool purports to do what you want:

http://bukhantsov.org/2011/09/universe-documenter

Regards,

Mark

[Former Member · Accepted solution]

Thanks Mark,

I have Gone throgh this  earlier , but this an application  which needs to be installed and ran as Administratior on local Machine.

We as general user will not have right to Install this applcaition locally

[Former Member · Accepted solution]

There might be something in BOB's Downloads, but I've not needed anything myself recently so cannot confirm:

http://www.forumtopics.com/busobj/viewforum.php?f=25

Failing that, Tools -> List of Derived Tables -> Edit, cut and paste would keep you quiet for a couple of days!

[Former Member · Accepted solution]

I think, There is no specific tool or function  from SAP to do this.

You need to write macro and and run against your universe  might helps you.