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:
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. |
- ERP Systems Impact on Organizations
- The Second Wave ERP Market: An Australian Viewpoint
- Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
- The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
- A Hybrid Clustering Technique to Improve Patient Data Quality