Printing and Print Preview in sap

Procedure

Print

To print the current list, choose .

In full-screen mode, this pushbutton is in the application toolbar. Alternatively, choose List ® Print.

Print Preview

In the print preview, the ALV Classic is displayed, which is used for printing.

To display a print preview of the current list, choose ® Print preview.

In full-screen mode, choose . Alternatively, choose List ® Print Preview.

Defining Drilldown Totals Levels in sap

IF you have defined subtotals in your list, you can hide entries and subtotals for an entire totals or subtotal level. See Calculating and Deleting Subtotals.

Procedure

To do this, your list must contain several subtotals.

To hide all entries and subtotals for a totals or subtotal level, proceed as follows:

1. Choose ® Drilldown totals level.
2. On the Define Drilldown Totals Level screen, choose the subtotal to remain displayed on the screen. The number of asterisks corresponds to the number of small squares in the list. See
Calculating and Deleting Subtotals.
3. Choose a relevant line.
4. Choose Apply.

Result

The totals and subtotal levels displayed correspond to the selection you made on the Define Drilldown Totals Level screen. The icon indicates subtotals between these entries are hidden. As a level underneath the second subtotal level is displayed, the subtotals on the second level and the totals line is displayed using the icon.

Displaying and Deleting Subtotals in sap

This concept also applies to the calculation of subtotals for averages, minimums, and maximums. The procedure is the same as for subtotals.

Prerequisite

Totals can only be calculated through Key Figures; subtotals can only be calculated through Characteristics.

You have calculated a total for at least one column. Once a total is displayed, the icons and menu options for displaying subtotals are displayed.

Use

The following example shows the use of totals and subtotals. In this example, a total was calculated for the Occupied column.

Then a subtotal is calculated for the No. column (flight number). The total is broken down into several subtotals. A subtotal is the total number of Occupied seats for all rows with the same subtotal criterion (here flight number: No. column). Therefore, the rows between two subtotals have the same value for the subtotal criterion, the identical flight number (No.).

Procedure

Creating Subtotals for One or More Columns

1. 
   
Select one or more columns.
2. Choose ® Subtotals.

Alternatively:

1. 
   
Select one or more columns.
2. Right click one of the column headers you selected.
3. Choose Subtotals.

Procedure without column selection

If you choose the subtotals function without having selected a column, you must select the columns for which you want to display subtotals in the Define Sorting / Subtotals dialog box. Proceed as follows:

1. Select the relevant entry or entries in Available columns.
2. To add the selected entries to the Sort criteria / Subtotals, choose .

Alternatively:

1. Select the relevant entry or entries in Available columns.
2. Click the selected entry or entries again and hold the mouse button. The cursor appears with a small rectangle.
3. Drag the entries to Sort criteria / Subtotals and drop them there.

To Find terms, choose .

To define a subtotal for a column or columns, click the checkbox under the subtotal symbol. An indicator is set.

For information about how to change the sort type and sequence, see Sorting in Ascending and Descending Order.

To apply your settings, choose .

Result

In the following example, a total was calculated for the Occupancy column and a subtotal for the Airline and Flight no. columns.

On this screen, you see the subtotals levels as well as the non-totals rows. The first subtotal level totals the occupied seats (Occupancy) for the rows with identical flight number (Flight no.), the first subtotal criterion. A small square is displayed next to the first level subtotals.

The second subtotal level adds the first level subtotals that reference the same airline (Airline); this is the second subtotal criterion. Two small squares are displayed next to the second level subtotals. Arrows are used to identify which subtotals belong to which subtotal criteria.

The third level is the totals level, identified by three small squares. This indicates that the total is the total of the top level subtotals.

Displaying and hiding entries and subtotals

To hide or display entries underneath the total or subtotal or to just display the subtotals, use one of the following procedures:

• Select the squares of the relevant subtotal row.
• Choose the icon in the relevant subtotal row.

The entries underneath this total or subtotal are hidden. The icon in the subtotal row indicates that the entries underneath a total or subtotal are hidden.

For information about how to hide all the entries and subtotal for a total or subtotal level, see

Defining Drilldown Totals Levels

.

Deleting Subtotals

To delete a subtotal, choose ® Subtotals, without selecting a column. If you selected a column here, you would define a new subtotal for this column.

The Define Sorting / Subtotals dialog box appears.

To delete the subtotal, deselect the relevant checkbox underneath the subtotal icon.

For information about how to change or delete a defined sort, see Sorting in Ascending and Descending Order.

To apply your settings, choose .

Alternative procedure in full-screen mode

In full-screen mode you can call the functions using the menus, in addition to the procedures described above.

1. 
   
Select one or more columns.
2. Choose Edit ® Subtotals.

To delete subtotals, choose Edit ® Subtotals, without selecting

Calculating and Deleting Maximums and Minimums in sap

Prerequisites

You can calculate a maximum and minimum for one or more columns. Maximums and minimums can only be calculated for Key Figures.

If a maximum and minimum is calculated using heterogeneous units, such as kilograms and liters or several currencies, a maximum and minimum is calculated for each unit.

Procedure

Calculating Maximum / Minimum

1. 
   
Select one or more columns (these must fulfill the prerequisite described above).
2. Choose ® Maximum/Minimum.

Result

Maximums and minimums are usually displayed with a yellow background in a separate line underneath the entries. If a maximum and minimum is calculated using heterogeneous units, such as kilograms and liters or several currencies, a maximum and minimum is calculated for each unit (a line with maximum / minimum is displayed for each unit).

Depending on the list, the maximum / minimum may be displayed above the lines.

See:

Calculating and Deleting Subtotals

Deleting Maximum/Minimum

To delete a maximum or minimum, proceed as follows:

1. 
   
Select one or more columns for which a maximum or minimum was calculated.
2. Choose ® Maximum/Minimum.

Alternative procedure in full screen mode

In full screen mode, you can also activate the function using the menus.

To calculate a maximum/minimum, proceed as follows:

1. 
   
Select one or more columns.
2. Choose Edit ® Calculate ® Maximum/Minimum.

To delete a maximum / minimum, proceed as follows:

Select one or more columns for which a maximum or minimum was calculated.

Choose Edit ® Calculate ® Maximum/Minimu

Calculating and Deleting Averages in sap

Prerequisites

You can calculate averages for several columns. (note: only applies to Key Figures).

If the average is calculated using heterogeneous units, such as kilograms and liters or several currencies, an average is calculated for each unit.

Procedure

Calculating average

1. 
   
Select one or more columns.
2. Choose ® Average.

Result

Averages are usually displayed with a yellow background in a separate line underneath the entries. If an average is calculated using heterogeneous units, such as kilograms and liters or several currencies, an average is calculated for each unit (a line with an average is displayed for each unit).

Depending on the list, the average may be displayed above the lines.

See:

Calculating and Deleting Subtotals

Deleting Averages

To delete an average, proceed as follows:

1. 
   
Select one or more columns.
2. Choose ® Average.

Alternative procedure in full screen mode

In full screen mode, you can also activate the function using the menus.

To calculate an average, proceed as follows:

1. 
   
Select one or more columns.
2. Choose Edit ® Calculate ® Average.

To delete an average, proceed as follows:

1. 
   
Select one or more columns for which an average was calculated.

2. Choose Edit ® Calculate ® Average.

Displaying and Deleting Totals

Prerequisite

You can display totals for one or more columns; this is only possible for Key Figures:

If you total on incompatible units, such as quantities in kilograms and liters or multiple currencies, a total appears for each unit.

Procedure

Displaying Totals

1. 
   
Select one or more columns.
2. Choose ® Total.

Alternatively:

1. 
   
Select one or more columns.
2. Right click one of the selected columns.
3. Choose Total.

Result

The total is usually displayed with a yellow background in an additional row underneath the entries. If you total on incompatible units, such as quantities in kilograms and liters or multiple currencies, a total appears for each unit.

If a total was calculated for a column, a small S is displayed in the column header. For an explanation of the small symbol in front of the total, see Calculating and Deleting Subtotals.

Depending on the list, the totals lines may appear above the entries.

Deleting Totals

To delete totals, proceed as follows:

1. 
   
Select one or more columns for which a total was calculated.
2. Choose ® Total.

Alternatively:

1. 
   
Select one or more columns for which a total was calculated.
2. Right click one of the selected column headers.
3. Choose Total.

Alternative Procedure in Full-Screen Mode

If you are working in full-screen mode, you can also use the menus to execute the function:

To calculate a total, proceed as follows:

1. 
   
Select one or more columns.
2. Choose Edit ® Calculate ® Total.

To delete a total, proceed as follows.

1. 
   
Select one or more columns for which a total was calculated.
2. Choose Edit ® Calculate ® Total.

Setting and Deleting Filters in sap

Use

You can choose to display only those rows that meet certain criteria in one or more columns.

Procedure

Setting Filters

• To set a filter:

1. 
   
Select one or more columns.
2. Choose .

Alternatively:

1. 
   
Select one or more columns.

1. Right-click a column header.
2. Choose Set filter.

The Set Values for Filter Criteria screen appears.



If you selected a cell using the right mouse button and set a filter, the Set Values for Filter Criteria screen appears with the contents of the cell you selected as the value of the relevant filter criteria. After confirming this screen, the column is filtered according to this value.

3. To specify the values or ranges displayed in your list, enter the From/To values for each column selected.

Only one filter is active at one time in a list. This filter consists of one or more filter criteria. To filter several columns in a list, set a filter with multiple filter criteria.

6. To apply your settings, choose .

Finding Terms in sap

Procedure

To look for terms in a list, proceed as follows:

1. 
   
Select the relevant column or columns.
2. Choose .

Alternatively,

1. Use the right mouse button to select the column.
2. Choose Find.

On the following screen, proceed as follows:

1. Enter the term under Search term.
2. Under Search order, indicate whether to search By lines or By columns.
3. To confirm your entries, choose .
4. The first entry found is highlighted.

You can repeat the search as often as you want. Every time you choose , the system searches the selected area starting at the last entry found.

5. To exit the screen, choose .

Alternative Procedure in Full-Screen Mode

In full-screen mode, you can execute the functions using menus as well as the procedure described above.

1. 
   
Select the relevant column or columns.
2. Choose Edit ® Find.

Sorting in Ascending or Descending Order in sap

Procedure

To sort one or more columns in a list, proceed as follows:

1. 
   
Select one or more columns.
2. Choose Sort in ascending order or Sort in descending order .

Alternatively:

1. 
   
Select one or more entries.
2. Select a column header with the right mouse button.
3. Choose Sort in ascending order or Sort in descending order.

Result

If a column is sorted, a small red triangle in the column header indicates the sort order (up arrow for sort in ascending order; down arrow for sort in descending order).

Procedure Without Column Selection

If you have not selected a column, and you choose either of the two above-mentioned icons, the Define Sort Order dialog box appears. In this dialog box, you specify the columns you want the system to sort. Proceed as follows:

1. Select the relevant entries in the Available columns.
2. To add the selected entries to the, choose .

Alternatively:

1. Select the corresponding entries in the Available columns.
2. Select the entry or entries again, holding the mouse button. The cursor appears with a small rectangle.
3. Drag the entries to Sort criteria and drop them there.

To Search for Terms, choose .

In Sort criteria, you select the relevant radio button ( or ) to sort in ascending or descending order, respectively.

To change the sort order, proceed as follows:

1. 
   
Select one or more entries.
2. Select the entry or entries again, holding the mouse button. The cursor appears with a small rectangle.
3. Drag the entries to the desired position and drop them there.

The entry is added in front of the line marking.

Alternatively:

1. 
   
Select one or more entries.
2. To:

• Move one entry up, choose
• Move one entry down, choose
• Move an entry to the first position in the sort order, choose
• To move an entry to the last position in the sort order, choose .

To remove the entries from the Sort criteria, choose .

To apply your settings, choose .

Result

If a column is sorted, this is indicated by a small red arrow in the column header (up arrow for sort in ascending order or down arrow for sort in descending order.

Deleting sort

To delete a sort, choose or , without selecting a column. The Define Sort Order window appears. Move the relevant column names from the Sort criteria to the Available columns (see above).

To apply the settings, choose .

Alternative Procedure in Full-Screen Mode

In addition to the procedures described, in full-screen mode you can execute the sort function from the menus:

1. 
   
Select one or more columns.
2. Choose Edit ® Sort in ascending order or Edit ® Sort in descending order.

To delete the sort, choose Edit ® Sort in ascending order or Edit ® Sort in descending order without selecting a column (see above).