Show TOC

Data TabLocate this document in the navigation structure

Use

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

Note

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 with the same type as the table line or the 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 group box WHERE Condition to select a particular part of the data in the internal table. Describe the conditions as you do on the Conditions tab.

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

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 sort sequence. To change it at a later time, use the black arrows above the control. Use the radio buttons to choose whether to sort the field in ascending or in descending order.

Caution

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 Already Sorted.

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).