Defining Rows (SAP Library

Defining Rows

Rows in a report are defined in a similar way to columns. However, you cannot enter predefined key figures in rows. You define row elements using basic key figures in combination with the characteristics selected for the library that the report uses. You can also use formulas.

Procedure

Position the cursor on the row you want to define, and choose Edit ® Elements ® Insert element, or double-click the element. For information on the terminology of elements, see Terminology.

Define the row.

If no other rows exist in the section, a dialog box appears on which you can select the combination of basic key figure and associated characteristics to be displayed in the row being defined.

In the upper area of the dialog box, select the basic key figure that you want to use in the report.

From the list of available characteristics on the right-hand side of the dialog box, choose the characteristics you want to use. Use the arrow to move these to the left-hand side of the screen. The characteristics displayed are those of the library assigned to your report. The order in which the characteristics appear in the selection list is determined by the Position field in the library definition.

On the left-hand side of the dialog box, enter the values for the selected characteristic(s):

You can enter individual values, intervals of values, or groups for the chosen characteristic(s).

If you want to define all possible values for the chosen characteristic(s), enter an asterisk (*).

If you want to specify an initial value for the chosen characteristic(s), enter a pound sign (#).

If you want to enter a variable instead of a characteristic value, select . Enter the name of the variable and choose Confirm. You can only enter variables that already exist in your system. For more information, see Variables.

If you want to enter a characteristic value in the form of a set, select . Enter the name of the set and choose Confirm. You can only enter sets that already exist in the system. For more information, see Sets in Report Rows.

For performance reasons, you should use sets whenever possible.

If rows have been defined in the section, you can also insert a formula. From the dialog box, choose Formula. A formula builder is displayed with which you can define a formula using other report rows and the previously defined cells. The row is calculated using the formula.

You can define formulas that refer to elements in different row blocks. However, you can only define formulas within one report section.

Choose and enter short, medium, and long texts for the row.
Choose Check and then Confirm.
To define additional rows, carry out steps 1 to 5 again.

You can copy report rows. Select a row and position the cursor where you want to insert it. Choose Edit ® Selected area ® Copy. You can then modify the copied row as desired.

You may find it useful to use sets to define entire blocks of rows. For more information, see the SAP Library under Creating Sets and Sets in Report Rows.

Editing Rows

Under Edit ® Rows there are a number of special functions for editing report rows. Get row model inserts a predefined row structure in your report rows. For more information, see Defining Row and Column Models. Insert blank line inserts a blank line in the current row (where the cursor is positioned).

Edit ® Rows ® Hide hides the row on which the cursor is positioned. The hidden row retains its contents and can still be used in formulas. You can edit hidden rows with Hidden rows ® Change. You can also delete and display the hidden rows (Delete and Show functions).

Edit ® Rows ® Explode expands the hierarchical levels of the group/value interval defined for the row characteristic. For more information, see Exploding Report Rows.