AD HOC QUERY IN PRACTICE
Prerequisite Activities
Before users can create and run their own reports, an administrator must create a functional area and a user group. These are created using the ABAP query component and necessary to set up the appropriate working environment for end users. The R/3 System contains hundreds of thousands fields in logical databases and tables and a logical database is simply a special ABAP program that combines the contents of specific database tables. For example the logical database “PNP” contains all tables related to HR Master data.
Since a user cannot be presented with thousands of fields to choose from – even from one particular logical database, to create a report, functional areas are created. When creating a functional area, first a logical database is selected, such as PNP which contains all the relevant tables for a particular module or sub-module. When selecting PNP which is relevant to HR master data, the administrator needs to pick which infotypes should be included in that particular functional area from the total number of infotypes attached to the logical database. A functional area determines which fields of a logical database can be evaluated in queries.
A functional area also allows defining auxiliary fields. In many cases, the information that a logical database supplies is insufficient. For this reason long texts are normally stored in tables that are not part of the logical database. These long texts are, however, useful when evaluating queries, for example when you want to display the full text of an advertisement (within recruitment) rather than just its number. Both additional tables and additional fields can be added to a functional area. Any table can be added as additional tables, provided they are defined in the ABAP Dictionary and when adding a field, the ABAP code must be specified and the field assigned to a functional group.