Show TOC Start of Content Area

Function documentation Open SQL Data Browser  Locate the document in its SAP Library structure

Use

The Open SQL Data Browser is a tool for viewing the content of database tables residing in the system database schema.

Prerequisites

You are in the Problem Management Database Open SQL Data Browser  function.

Features

Using the Open SQL Data Browser, you can select all data from the table of interest. You can change the set and sequence of the columns that are displayed. To restrict the amount of data, you can set selection criteria for single table columns and thus restrict the selection.

Activities

In the Open SQL Data Browser function you can sort and filter data within the resulting table data:

      To sort tables by individual columns in ascending or descending order, click the column header.

      To filter tables, choose This graphic is explained in the accompanying text. A blank line appears in the table. Enter the appropriate filter string in the line and choose Enter. To disable the filter, choose This graphic is explained in the accompanying text. The filter is enabled by default.

Note

By default, the selection is restricted to a maximum number of 200 hits. If you want to change the maximum number of hits, choose the Open Settings Dialog button and navigate to the General tab.

End of Content Area