A report column is defined by its name, offset and length. Per default, all columns are of data type string. To identify a report’s columns, the report needs to be executed. Columns can then be identified based on the output.
Tip: At this stage, use a selection or variant that returns only a few records. This can be adapted later on.
Some Classical ABAP reports are developed in a way so that output columns are delimited by the pipe symbol ‘|’. In this case the Report component can automatically identify the columns. Automatic column detection also works for most ALV reports.
For reports where the output is not separated by the pipe symbol, the columns must be identified manually.
Define Columns automatically #
Automatically detect columns
By clicking [Automatically detect columns] the report is executed based on the selected variant or selections. Column name, width and offset are displayed in the Columns section if they can be identified automatically.
Dynamic column width and offset
You can use this setting when report columns can be detected automatically, see Automatically Detect Columns. If Dynamic column width and offset is active, the column length and offset is adjusted dynamically at report runtime. This can be required for reports that have varying column widths depending on the report’s selection criteria.
Define Columns manually #
When automatic column detection is not possible, the report’s column names, widths and offsets must be set manually.
Report columns can be manually defined as follows:
- Make sure no columns are defined yet. Go to the Columns section and delete all columns by clicking on the trash can icon.
- Click [Load Preview]. The report is executed based on the selected report variant or selections. The report output is displayed in the Load Preview section.
- Press and hold down the left mouse button in the Load Preview section.
- Move the mouse pointer to the right while still holding down the left mouse button.
- Let go of the mouse button. The report column is highlighted with a green background. An entry is added to the Columns section.
- To change the column name, offset and width, click in the respective fields in the Columns section and enter a new value.
- Repeat steps 3 to 6 until all columns are defined.
Note: Once a column is set and highlighted with a green background, its width and offset can’t be changed via the graphics editor. Change it using the Columns section.
Skip rows from top
Enter the number of rows you want to skip at the beginning of the report. Some reports display meta information in the header section of the report, before the actual report body. This setting allows skipping the meta information.
Skip rows from bottom
Similar to skip rows from top. Enter the number of rows you want to skip in the footer section of the report.
Report rows per data row
Use this setting for ABAP reports, that return two or more “physical” rows to display a single “semantic” data row. This concatenates the physical rows into a single data row.
Example: Report RIEQUI20
Use this setting in combination with Report rows per data row. Defines the length of each physical row.