Restrictions with the InfoSet (Ad Hoc) Query Tool


The InfoSet (Ad Hoc) Query tool uses the SAP List Viewer as its default output. Unlike the SAP Query tool, where up to nine ranked lists and up to nine statistics per query are possible, with the InfoSet (Ad Hoc) Query tool, every query can output only one list, and you cannot distribute output fields over several lines. Recall from earlier chapters that advanced functions are available with the SAP Query tool, including the ability to create calculations (local fields) and insert graphics, icons, colors, custom headers and footers, and so on. These functions are not possible with the InfoSet (Ad Hoc) Query tool.

Because the InfoSet (Ad Hoc) Query tool can output only one list and cannot distribute output fields over several lines, you should not process an available query with the InfoSet (Ad Hoc) Query tool if it contains multiple lists, a basic list with line groups, or calculated fields.

If you use a query with one of these properties in the InfoSet (Ad Hoc) Query tool, the parts of the output are shown as follows:

  • Multiple lists Only the first list is displayed.

  • A basic list with line groups Only the first line of each is displayed.

  • Calculated fields Local fields are not displayed.

These properties are lost if you overwrite the query. However, they are not lost as long as you do not save the query, and you can continue to call and execute the query with all properties by using the SAP Query tool via transaction code SQ01 and clicking the SAP Query button.




SAP Query Reporting
SAP Query Reporting
ISBN: 0672329026
EAN: 2147483647
Year: 2006
Pages: 161

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net