Home > Articles > Home & Office Computing

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Reviewing the Options on Each of the Five Basic Screens

The following sections serve as a reference of what options are available on each of the five basic screens of the SAP Query tool.

The Title, Format Screen

The Title, Format screen, shown in Figure 3.9, is where you insert the basic data about your report, including its title and the format in which you want it displayed. The Title, Format screen stores the basic report processing options for your report. For organizational purposes, it is a good idea to enter the name of the user who created the report in the Notes section of this screen. The following sections describe the options available on this screen.

Figure 3.9

Figure 3.9 The Title, Format screen.

List Format

By default, on execution, a report is displayed in the SAP List Viewer (refer to Figure 3.8). The options listed in the List Format section apply only if you change the output format to appear in a text file or ABAP list. List Format options available on the Title, Format screen allow you to designate the line and column width of your report.

You use the Lines field to specify the number of lines to be output on one page for a list generated by the query. The default is blank, which outputs a continuous list on a single page. You can use the Lines field to enter the number of lines to be output on a single page. If you do not want page breaks, you should leave this field empty. The Columns field stores the number of columns per line. This field determines the maximum number of characters that can be displayed on one line of the list created by the query. Lines exceeding this length are broken. The maximum number permitted is 255. The number entered in the Columns field should be the closet estimation possible, because it helps determine the printed layout of the report. For example, if you set all reports to be the maximum of 255 so that all your columns fit on a single line, your printed report may contain very small text to accommodate all 255 columns. Again, these settings are required only if the output format is a text file or an ABAP list. (See the section "Output Format" on the next page.)

Special Attributes

The Special Attributes section allows you to specify whether the report should run with a variant. (Variants are introduced in Chapter 6, "Using Reporting Selection Screens: Advanced Skills.") You use the Change Lock check box to indicate whether you want other users to be able to make changes to your query. By default, this check box is unmarked, indicating that any other user in your query group who has the appropriate authorizations can make changes to your report. To prevent this, select this check box for each new query you create.

Table Format

You use the options listed in the Table Format section only if you change the output format to appear in a table. (See the section "Output Format.") You use the Columns field in the Table Format box to indicate the maximum number of characters for the width of a table view control if you select your data to be viewed as a table. You can use table view controls to display the data of single-line basic lists, statistics, and rankings in a special format. This specification affects only the visible width, and the table control may contain more data columns than are visible in a single R/3 window.

Print List

The Print List box includes the With Standard Title check box, which you use to indicate whether you want your output to include the standard title that you specified at top of the screen, in the Title field. By default, this box is selected. You use the No. of Characters Left Margin box to specify how many characters to save room for at the left side of the page in the printed report, in case you want to have room for binding or punched holes.

Output Format

Upon report execution, your report is displayed in the SAP List Viewer format (refer to Figure 3.8). The Output Format options allow you to have a report's data output in different formats. The default setting is SAP List Viewer, which is a screen that appears very similar to a Microsoft Excel worksheet and is the standard for all reports in SAP version 4.6C and higher. The options available in this box are described in Table 3.1.

Specifying an output option on the Title, Format screen of the SAP Query tool ensures that when the report is executed, it will be displayed in the selected format. When you select an option on the Title, Format screen, it is set as a default parameter for the selection screen of that report only.

Table 3.1. SAP Query Tool Title, Format Screen Output Format Options



SAP List Viewer

When you select this option, your list will not be displayed onscreen in the normal form when the query is processed. Instead, the first sublist is transferred to the SAP List Viewer directly, as shown in Figure 3.8. You must be able to transfer this first sublist (it must be either a single-line basic list, a statistic, or a ranked list). This is the default selection.


When you select this option, the report will appear in SAP as a basic list, without any formatting or fancy Microsoft Excel–looking features. This was the format of all standard SAP Query tool reports in versions earlier than SAP 4.6C.


This function allows you to display the information from your list by using SAP Business Graphics. In contrast to the other functions described in this table, the Graphic function can only handle an extract from one column of your sublist, and the column must contain numeric values. In addition, your SAP system has to have Business Graphics enabled.

ABC Analysis

You can use the ABC Analysis function for any single-line basic list, all statistics, and any ranked list that contains at least one numeric field.

Executive Information System EIS

This function provides a link to the Executive Information System (EIS). It transfers the data in your query to the EIS database via an interface so that you can perform further analyses. When you activate this function, you specify various options for storing the data in a dialog box.

File Store

When you select this option, the list is not displayed onscreen when you execute the query, but the first sublist is passed directly to the download interface and stored as a file. The first sublist must be a single-line basic list, a statistic, or a ranked list. When you select the field, a parameter is predefined on the selection screen.

Display as Table

When you select this option, your report output is displayed in an SAP Table Control object that looks similar to the SAP List Viewer but offers less functionality. The first sublist must be a one-line basic list, a statistic, or ranked list. When you select this option, a parameter is predefined on the selection screen.

Word Processing

When you select this option, the word processing functions can be called from the list display and from the table display. You can use this option to create Microsoft Word form letters.


When you select this option, the spreadsheet functions can be called from the list display and from the table display. You can use this option to create Microsoft Excel spreadsheets.

Private File

When you select this option, the list is not displayed onscreen when you execute the query, but the sublist is passed directly to a function module. This is an SAP enhancement and must be implemented by the customer.

The Select Field Group Screen

In the Select Field Group screen, shown in Figure 3.10, a list of all the available field groups is populated during the creation of the InfoSet. (See Chapter 2 for more information.) This example has only three field groups; however, some logical databases contain hundreds. You place a check mark next to any field group that contains fields you want to include in your SAP query.

Figure 3.10

Figure 3.10 All the field groups listed at the top right of your InfoSet screen during configuration of the InfoSet are listed on this screen.

The Select Field Screen

In the Select Field screen, shown in Figure 3.11, a list of all the available field groups populated during the creation of the InfoSet is expanded to display all the fields contained within them. You place a check mark next to any field you want to include in your SAP query.

Figure 3.11

Figure 3.11 All the fields listed in the field groups at the top right of your InfoSet screen during configuration are listed here. This screen is also used for advanced functions covered later in this book.

The Selections Screen

In the Selections screen, shown in Figure 3.12, a list of all the previously selected fields appears. You place a check mark next to any field that you want to include on the Selections screen that appears upon report execution. This gives you the option to specify particular data.

Figure 3.12

Figure 3.12 Having fields available on your report's selection screen gives you the ability to specify your report output by varying your input prior to report execution.

For example, in Figure 3.12, I selected that I wanted the Airfare, Maximum Capacity, and Weight of Luggage fields to appear on my report's Selections screen. This means that when I execute my report and see the Selections screen, those three fields will be listed there, under the heading Program Selections. Having them there allows me to run the report based on specific airfares, maximum capacity, or weight of luggage. (For example, I could run a report that contains a list of flights between $50 and $200.)

The Basic List Line Structure Screen

By default, only the first few selected fields of your report appear on the Basic List Line Structure screen, shown in Figure 3.13. They are all there, but with the default view, they are not all visible. You can use the Page Up and Page Down buttons on the right side of the screen to navigate between them, or you can select the Without Explanation button (at the bottom left of the screen) to view more fields on a single screen. The Basic List Line Structure screen lists all the fields you want to include in your output. You can have fields listed here for sorting purposes but not included in the output by simply leaving the Line and Sequence fields blank.

Figure 3.13

Figure 3.13 This is the screen where you dictate how you want your report to appear, including sequence and sorting specifications.

The following sections describe the various options available in the Basic List Line Structure screen.

Basic List with Box

The Basic List with Box check box, which appears at the top of the screen, is used for basic ABAP lists. If you select for your report output to be an ABAP list, selecting this check box causes the basic list to display with lines separating the columns. It is used as a formatting preference only. The box is designed so that it encloses only the filled part of the basic list.

Columns Separated by |

The Columns Separated by | check box is available only if the Basic List with Box check box is selected. If you select for your report output to be an ABAP list, selecting this check box causes a vertical bar to be inserted after each field on a line except the last. An underscore is output before and after each control-level text (if sorting and subtotaling are used) and is inserted before and after each total. In addition, the individual columns in the standard header are separated by vertical bars. As with the previous option, this one is used as a formatting preference only.

Compressed Display

If you select the Compressed Display check box, the basic list is displayed in compressed format, provided that compressed display is possible.


The Line column is where you specify the line number on which you want your output to appear. Specifying Line 1 for all fields will make them all appear as columns next to each other in the form of a standard report. Indicating multiple line numbers usually works only if you set your report output to be anything other than the SAP List Viewer or the table display. Multiple-line indicators are used most often for creating mailing labels or addressing envelopes, where the data output is on three or four sequential lines.


You use the Sequence column to identify the order in which you want your data to appear in the line. For example, if all of your fields are on Line 1, you can specify that you want the Booking Number field to appear first, followed by the Airline Carrier ID, and so on. It is a best business practice to list your sequence of fields in increments, as shown in Figure 3.13. That way, if you need to modify the report output, add a field, or delete a field, you do not need to renumber the entire sequence in the report. A popular way to do this is to use increments of 5, as shown in Figure 3.13.


When you have set up the way you want your fields displayed with the Line and Sequence settings, you can specify the sort order for the fields by using the Sort column. You can assign sequence numbers between 1 and 10 to sort on up to 10 different fields.


Check boxes for the Total column appear only for numeric fields that can be totaled. You can place a check mark for each numeric field for which you want to output the total at the end of the basic list and, if sort criteria exist, subtotals at the end of each control level. Chapter 7, "Creating Advanced Reports with the SAP Query Tool," talks more about control levels and subtotaling.


You can select check boxes in the Counter column for each field you want to count. The total is then displayed at the end of the list.

  • + Share This
  • 🔖 Save To Your Account

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020