BEX queries... Backend table that holds BEX query definition

[Former Member]

Hello,

Wondering if anyone knows where the SQL is housed for BEX queries.

Basically, I want to determine all the queries that filter per a company code and assume hitting the SQL definition table would be a fast way to know all queries that use it..

Thanks!

[Former Member]

Bill,

But using

Using RSRT by specifying the query and click execute and debug>select database>display sql query.

It will display the query in open-sql statement.

Nt sure though how to know where a particular sql statement is used in different queries

-Doodle

[Former Member]

Thanks but I want to scour the table that holds ALL of the query definitions.

[Former Member]

Don't believe there is any sort of static sql table that holds the sql of a defined query. The queries are built on the fly using authorixations, variants, variables, filters, restrictions, etc.

You can use ST04 to look at SDQL stmts that have run in the recent past and are in the SQL stmt cache.

If you want to see how the query is built you could turn on the SQL trace (using ST05) and launch a query or start one thru RSRT. You find perhaps doxens of queries being run that pull pieces together to generate the end query the user wants to run.