Fixing Columns in sap

Use

If you want to ensure that certain columns are always displayed even if the user scrolls down, you must fix the columns.

Procedure

To fix one or more columns, proceed as follows:

1. Click the right mouse button on the header of the column that is the column furthest to the right of the columns you want to fix.
2. Choose Fix to column.

To undo a column fix, proceed as follows:

1. Click the right mouse button on a column header.
2. Choose Remove fix.

Alternative procedure in full screen mode

In full screen mode, you have the option of activating the function using the menus:

1. Select the header of the column that is the column furthest to the right of the columns you want to fix.
2. Choose Settings ® Column ® Fix to column.

To undo a column fix, proceed as follows:

1. Click the right mouse button on a column header.
2. Choose Settings ® Column ® Remove fix.

Optimizing Column Width in sap

Procedure

To optimize column width – that is, to tailor column width to the column entries, proceed as follows:

1. Right-click the selected column.
2. Choose Optimize width.

Alternatively:

Double-click the separator between two column headings. The system optimizes the width of the left-hand column.

Alternative Procedure in Full-Screen Mode

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

1. 
   
Select a column.
2. Choose Settings ® Columns ® Optimal width.

Changing Column Width in sap

Procedure

To change the width of a column in the list, pass the cursor over the separator between two column headings. If the cursor changes (to a double line superimposed on a two-sided arrow), you can change the width of the column directly to the left by dragging the separator to the desired position.

Displaying and Hiding Columns in sap

Hiding a column

To hide one or more columns, proceed as follows:

1. 
   
Select one or more columns.
2. Click one of the selected column headers.
3. Choose Hide.

Alternatively:

1. To select columns to hide, choose ® Change layout.
2. The
Change Layout dialog box appears.

Displaying a column

To show one or more columns, proceed as follows:

1. 
   
Select one column.
2. Right click the column header.
3. Choose Show.

Alternatively:

1. To select columns to show, choose ® Change layout.
2. The
Change Layout dialog box appears.

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 select the columns you want to show or hide, choose Settings ® Layout ® Change.

Swapping Columns

Procedure

To swap columns in a list, proceed as follows:

1. 
   
Select one or more columns.
2. Click the column header again and hold the button. The cursor is now surrounded by a small rectangle.
3. Keep the mouse button pressed, and drag the column to the desired position.
4. The system inserts the column to the left of the red separator.

Alternatively, you can define column position explicitly for each column in your list. See Changing Layout.

Selecting and Deselecting Columns

Procedure

You select a column by single-clicking the column header.

To select more than one column:

• Adjacent columns:

Select a column, choose Shift or Control, and select the desired columns,

or

Choose Shift, and select the first and the last of the desired columns,

or

Select a column, keep the mouse button pressed, and pass over the desired columns.

• Columns that are not adjacent:

Select a column, choose Control, and select the desired columns.

To deselect individual columns, press and hold the Ctrl button and click the relevant column header.

Result

Selected columns have an orange background.

Selecting and Deselecting Cells in sap

Prerequisites

You can select cells if pushbuttons are displayed on the left side of your list. The use of the ALV Grid Control then determines whether you can select one or several cells.

Procedure

To select an individual cell, click the relevant entry.

To select several cells, choose Shift, and choose the relevant cells.

• Cells lying next to or above or below each other:

Select the cell, choose Shift or Control and then choose the other cells, or:

Choose Shift and choose the first and last cell, or:

Choose a cell, press the mouse button and drag the mouse over the cells you want to select.

• Cells not lying next to or above or below each other:

Select the cell, choose Control and select the desired cells.

To deselect individual cells, choose Control and click the relevant cell.

Result

The selected cells have an orange background. The location of the cursor is indicated with a yellow background.

Selecting and Deselecting Rows in sap

Use

Depending on where the ALV grid control is used, there are various methods for selecting and deselecting cells and rows:

• If no pushbuttons are displayed on the left edge of the list:

• You can only select one row at a time.
• You can select multiple rows.

• If pushbuttons are displayed on the left edge of the list:
• You can select several rows or individual cells.
• You can select several rows as well as several cells or individual cells.

Procedure

• If no pushbuttons are displayed on the left edge of the list, you select a row by clicking an entry in the row.
• If pushbuttons are displayed on the left edge of the list, you select a row by clicking the pushbutton on the relevant row.

In this case, you select the relevant cell by selecting the entry in the row.

In both cases:

To select several rows, press the Shift button and choose the cells as described above.

• Adjacent rows:

Select a row, choose Shift or Control, and select the desired rows,

or

Choose Shift, and select the first and the last of the desired rows,

or

Select a row, keep the mouse button pressed, and pass over the desired rows.

• Rows that are not adjacent:

Select a row, choose Control, and select the desired rows.

• All rows:

You can only select all rows at once if pushbuttons are displayed on the left side of your list. To select all rows, choose .

To deselect individual rows, press the Ctrl button and click the relevant row.

Result

The selected cells have an orange background. The position of your cursor is indicated with a yellow background.

Navigating in the List in sap

Procedure

• In lists where the system cannot display all columns at once, you can scroll horizontally through the columns.

The key columns are turquoise. By default, the key columns are fixed (that is, these columns are always displayed, regardless of the position of the horizontal scrollbar) at the far left of the list.

In lists where the system cannot display all rows at once, you can scroll vertically through the rows.

Direct List Control Settings in sap

Use

In the ALV Grid Control, you can use the mouse to set the list display settings, without having to choose functions through the toolbar, context menu, or menu paths (in full screen mode).

Features

Navigating in the List

Selecting and Deselecting Lines

Selecting and Deselecting Cells

Selecting and Deselecting Columns

Swapping Columns

Hiding and Displaying Columns

Changing Column Width

Optimizing Column Width

Fixing Columns