Show TOC

Setting Result-Set SizeLocate this document in the navigation structure

Prerequisites

You have already opened the Data Preview for the required table.

Context

The Data Preview tool allows you to set the size of a result-set to retrieve records from ABAP Data Dictionary tables, Views, external Views, and ABAP DDL Sources. The result-set size determines the number of records that the Data Preview tool can retrieve. The default value is 100 and the maximum value is 5000.

Note

Using the value in the Max rows field, you can restrict the number of records for display in the Data Preview. The number you set is the number of records displayed, even if the filter criteria has fetched more records. The Number of Entries button displays the total number of records that match the filter criteria. If you have not applied any filter, the button displays the total number of records in the database.

Procedure

  1. In the top-right of the Data Preview tool, enter or select a value in the Max rows field.

    The default value is 100.

  2. Press Enteror press (Refresh).

    The Data Preview tool fetches the number of records according to the value entered in the Max rowsfield.