Adapting the ALV Grid Control using the Field Catalog
In the figure, the data table consists of fields (columns) of the SBOOK type and two others. You need to describe these types in the field catalog, along with the column that you want to be hidden.
Example – Adding and Changing Columns
The figure shows a semi-automatic field description. A part of the field description comes from the ABAP Dictionary structure (SBOOK) whereas another part is defined in the gt_field_cat field catalog.
Fill the field catalog (internal table) in the program and pass it on with the name of the ABAP Dictionary structure in the set_table_for_first_display method.
Ensure that the fields of the gt_bookings data table that cannot be read from the SBOOK table are also filled.
You must ensure consistency while constructing the field catalog semi automatically or manually. To perform this, press the SHIFT key and double-click with the right mouse button in an area of the ALV grid that contains no data (for example, the header).
Assignment of a Type to a Column Without Reference to a Dictionary Structure
You can use ROLLNAME to specify the data element that is used for the F1 help and the text for the column headers, selection screen, and quick information text if it is not already explicitly set.
If you have not filled the ref_field or the ref_table field, there is no adequate reference to the ABAP Dictionary. In this case, the fields allow you to format the relevant columns for output.
Formatting of Amounts for Units
Currency formatting has the following features:
- If you want to format the contents of a column according to the formatting options of a currency unit that is specified in another column of the data table, specify the name of the column in the cfieldname
- If you want to format all values of a column according to a particular currency, specify the relevant currency abbreviation in the currency
- If the currency field has a value, ignore the entries in the cfieldname
Quantity formatting has the following features:
- If you want to format the contents of a column according to the formatting options of a unit that is specified in another column of the data table, specify the name of this column in the qfieldname
- If you want to format all values of a column according to a particular unit, specify the relevant unit abbreviation in the quantity
- If the quantity field has a value, ignore the entries in the qfieldname
In the figure, the data table contains the price (the amount to be paid for a flight) and currency columns (currency for the contents of the price column).
Enter CURRENCY in the cfieldname field of the field catalog for the price column to ensure that contents in the price column are according to the currency specified in the currency column, for example, USD - two decimal places, JPY - no decimal places.
Output Properties of a Column
The features of different fields are as follows:
- The COL_POS field determines the output position of a field. It has the following features:
- To calculate the column position, count the hidden columns as well. However, exceptions do not count as a column.
- Without explicit positioning, fields that are manually added to the field catalog are positioned before the other fields of the data table.
- Exceptions are always displayed in the first column.
- The EMPHASIZE field has the following features:
- To highlight with a default color, enter X.
- You can also define the color yourself by passing a four-character code in accordance with the convention - C<col_constant> {0|1}{0|1}.