Skip to Content

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

All queries and USED InfoProviders (query and underlying infoproviders)

Hello,

How can I automatically generate a list of all queries (that run on multiproviders) and the underlying InfoProviders (i.e. contained in the MultiProvider) that are actually used by each query?

For each single query I know how to get the answer to the question: goto RSRT (Query Monitor), choose query and press Execute + Debug. Next, check the box ´_MultiProvider Explain_´ and run the query. Input the required variables and a report will show.

This report includes lines on the underlying InfoProviders of the MultiProvider.

When an underlying InfoProvider is used, it says:

MultiProvider MCO_DMOD1: InfoProvider ZIM_FA_1 ***

list of elements that are queried... **

When an underlying InfoProvider is NOT used by the query, it says:

MultiProvider MCO_DMOD1: InfoProvider ZPS_WBS3 ***

Access to ZPS_WBS3 was excluded

So now I have the InfoProviders that are actually used by the query.

I need this information for ±1100 queries, and therefore, I need a way to get this information automatically.

Please help! Answers are greatly appreciated in terms of points!

Thanks in advance!

Regards, Robin

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