Show TOC Start of Content Area

Function documentation Functions in the View Menu  Locate the document in its SAP Library structure

Use

The following information provides an overview of the functions provided in the menu bar for the Query Designer in the View menu.

Features

You can choose from the following functions in the View menu:

Menu: View

Menu Option

Description

Predefined

Using the View Predefined Standard View menu option, you can return to the standard view. If you prefer to use the view that you are familiar with from the Query Designer in SAP BW 3.x, choose View Predefined SAP BW 3.x View.

Toolbars

You use this function to show and hide the View, Standard, and Exit toolbars.

Technical Names

You use this function to show or hide the technical names of the query components (InfoObjects, structures, variables, and so on).

Properties

You use this function to show the Properties screen area. The content of the Properties screen area automatically adjusts itself. Depending on the object that you select, the properties appear as context-sensitive.

Tasks

You use this function to show the Tasks screen area. In this area, the most important tasks for the selected object with which you are currently working are listed; the tasks are listed context-sensitively. This provides an overview of the functions and options available to you while you are working in the query.

InfoProvider

You use this function to show the InfoProvider screen area. The content of the InfoProvider upon which the query is based is displayed in this area; from here you can include objects in the query by using drag and drop.

Filter

You use this function to show the Filter screen area. You specify the filter values of the query in this area. For more information, see Filters.

Rows/Columns

You use this function to show the Rows/Columns screen area. In this area, you specify the free characteristics for navigating in the query and the contents of the rows and columns. You can view the structure of the query in a preview.

Cells

You use this function to show the Cells screen area. If the query already contains cells, this area automatically appears as a tab page.

You can define formulas and selection conditions explicitly for cells in queries with two structures. In this way, you can override cell values created implicitly from the intersection of the structure components. This function allows you to design more detailed queries.

This function is only available for queries with two structures. The menu option is deactivated for queries with just one structure.

See Defining Exception Cells.

Exceptions

You use this function to show the Exceptions screen area. If the query already contains exceptions, this area automatically appears as a tab page.

You can define exceptions for a query. Exceptions are deviations in key figure values that you define. They are displayed in color in the query view. This allows you to see at a glance whether results deviate from the expected results.

See Exception Reporting.

Conditions

You use this function to show the Conditions screen area. If the query already contains conditions, this area automatically appears as a tab page.

You can define conditions for a query. You can specify threshold value conditions for the key figure values for every characteristic. For example, you can specify all sales figures above or below a certain threshold value. In the query, the selected characteristics are displayed with the restricted key figures.

See Conditions

Messages

You use this function to show the Messages screen area. System messages, check messages, warnings, and other information are displayed in this area. From the context menu of the message, you can navigate to the actual error, or display information about the error.

Where-Used List

You use this function to show the Where-Used List screen area.

When you choose Query Where-Used List the Query Designer displays in the Where-Used List area the objects (workbook, Web template, report or broadcast setting) in which this query is used.

When you choose Where-Used List in the context menu for reusable objects, the system displays in this area where these objects are used.

Documents

You use this function to show the Documents screen area. When you select the Explain Error Message function, the system message texts are displayed here.

 

 

 

End of Content Area