This chapter shows how to create a Reporting Services dataset that is based on an SAP Query. Depending on if you are using the wizard or regular editor the screenshots may be a bit different.

The most important transaction codes for SAP Queries are SQ01/SQ02/SQ03.

To learn more about creating queries in SAP please go to help.sap.com.

Queries-001

The following sample is based on the query BC407_CONNEX located in user group BC407_LEARN. Both screenshots show the Selection Screen of the query and the query’s list output.

Queries-002

Queries-003

Searching Queries

Apply Variants

Entering Select Options

Settings