Question:
Hello!
I need a list of all queries in BW. I can get queries with technical names by searching with pattern * in BEx or transaction RSRT1, but the problem is that i can't copy or save this list to some external file.
Is there some way to do it?
Regards,
Mio
Answer:
Two tables you need to access: get the Query-ID and tech name from RSZCOMPDIR. Then use RSZCOMPDIR-COMPUID to read RSZELTTXT-ELTUID in order to get the descriptions
Answer:
Also check out this post: it contains code for an ABAP that lists out all Queries and Workbooks.
/forums/viewtopic.php?t=40063&highlight=rsrrepdir
And finaly also: RSA1 > Metadata repository