Data Tab

Use

You use the Data tab to select data from internal tables for a table node or a loop node or a complex section.

If you mark the radio button in the left upper edge of the tab page, you deactivate the entire tab. In this case, you do not select any data and use the node in the same way as a template node (with the one difference that you create the table using line types).

Selecting Data

  1. If you want to use a loop to read and process the lines of the internal table one after the other, mark the checkbox in front of Internal Table.
  2. Enter the name of an internal table.
  3. Enter the assignment type ( INTO or ASSIGNING ) and a work area (structure of the table line type or field symbol). If you use a table with header line, as a work area you must again enter the name of the internal table.
  4. If desired, use the input fields Line and To to determine the part of the internal table you want to read.
  5. Use the WHERE Condition box to restrict the seletion to a part of the data from the internal table. Describe the conditions as you do on the Conditions tab.

At runtime the system selects the data according to your settings. After processing the loop, the output area contains the last entry selected (or the field symbol points to this entry).

Sort Criteria

You can use the second table control of the Data tab to sort the table output by fields of the internal table. The sequence in which you enter the field names into the table control determines the sorting sequence. To change it later, you can use the black arrows above the control. Use the radio buttons to specify whether to sort the field in ascending or in descending order.

For technical reasons SAP Smart Forms cannot see whether the internal table was sorted before (for example, in the application program). If it was, you must still enter the sorting sequence into the table control and mark A lready S orted.

A break in a sort level results from the sort process whenever the value of a sorted field changes from one line to the other. The blocks in which the value of the field remains constant are sort levels.

If you want to display output before or after a sort level changes, mark Event on Sort Begin or Event on Sort End. Then in the tree structure an event node appears for which you can create inferior nodes to display output at these events (for example, subtotals).