Setting ALV columns as key columns and making zero amount appear as blank

This recipe is comprised of two subrecipes:

We will see how the personnel number (PERNR) column may be set as key with blue colour. In addition, how a particular column Amount, where a zero amount is shown as 0.00, may be made to appear blank.

How to do it...

For making the above adjustments, proceed as follows:

1. Declare a column variable with reference to the class cl_salv_column_table.

2. Next, use the get_column method of the mycolumns object pointing to the columns of the ALV in order to get the reference to the column PERNR. We will then use the set_key method to set the PERNR column as the key column.

3. Similarly, the get_column method is called for the Amount column BET01. The set_zero method is called to convert the zeros to blanks while outputting the BET01 column. It is necessary that the value space (' ') is passed to the set_zero method.

   

4. The code fragment was added before the ALV display method but after the assignment...