I need to put color into all the cells with values inside each column.
I want to show something like this.
Here is my code:
SORT gt_sehir_dilim_alv BY
saat1 DESCENDING
saat2 DESCENDING
saat3 DESCENDING
saat4 DESCENDING
saat5 DESCENDING
saat6 DESCENDING
saat7 DESCENDING.
LOOP AT gt_sehir_dilim_alv INTO gs_sehir_dilim_alv.
lv_index = sy-tabix.
IF lv_index EQ '1'.
wa_cellcolor-fname = 'SAAT1'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
wa_cellcolor-fname = 'SAAT2'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
wa_cellcolor-fname = 'SAAT3'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
wa_cellcolor-fname = 'SAAT4'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
wa_cellcolor-fname = 'SAAT5'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
wa_cellcolor-fname = 'SAAT6'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
wa_cellcolor-fname = 'SAAT7'.
wa_cellcolor-color-col = 1.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ENDIF.
ENDLOOP.
I have tried with this code too. But it's painting row based cells based on requirement:
LOOP AT gt_sehir_dilim_alv INTO gs_sehir_dilim_alv.
lv_index = sy-tabix.
SORT gt_sehir_dilim_alv BY saat1 saat2 saat3 saat4 saat5
saat6 saat7 ASCENDING.
*
* READ TABLE gt_sehir_dilim_alv INTO gs_sehir_dilim_alv INDEX 1.
IF gs_sehir_dilim_alv-saat1 NE 0
and gs_sehir_dilim_alv-saat2 NE 0
AND gs_sehir_dilim_alv-saat3 NE 0
AND gs_sehir_dilim_alv-saat4 NE 0
AND gs_sehir_dilim_alv-saat5 NE 0
AND gs_sehir_dilim_alv-saat6 NE 0
AND gs_sehir_dilim_alv-saat7 NE 0.
ELSEIF gs_sehir_dilim_alv-saat1 GT gs_sehir_dilim_alv-saat2
AND gs_sehir_dilim_alv-saat1 GT gs_sehir_dilim_alv-saat3
AND gs_sehir_dilim_alv-saat1 GT gs_sehir_dilim_alv-saat4
AND gs_sehir_dilim_alv-saat1 GT gs_sehir_dilim_alv-saat5
AND gs_sehir_dilim_alv-saat1 GT gs_sehir_dilim_alv-saat6
AND gs_sehir_dilim_alv-saat1 GT gs_sehir_dilim_alv-saat7.
"7.40 kodu - wa_fcat kullanmadan edit atabiliyoruz.
APPEND VALUE #( fname = 'SAAT1'
color-col = 6
color-int = '1'
color-inv = '0' ) TO
gs_sehir_dilim_alv-cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ELSEIF gs_sehir_dilim_alv-saat2 GT gs_sehir_dilim_alv-saat1
AND gs_sehir_dilim_alv-saat2 GT gs_sehir_dilim_alv-saat3
AND gs_sehir_dilim_alv-saat2 GT gs_sehir_dilim_alv-saat4
AND gs_sehir_dilim_alv-saat2 GT gs_sehir_dilim_alv-saat5
AND gs_sehir_dilim_alv-saat2 GT gs_sehir_dilim_alv-saat6
AND gs_sehir_dilim_alv-saat2 GT gs_sehir_dilim_alv-saat7.
wa_cellcolor-fname = 'SAAT2'.
wa_cellcolor-color-col = 6.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
ELSEIF gs_sehir_dilim_alv-saat3 GT gs_sehir_dilim_alv-saat1
AND gs_sehir_dilim_alv-saat3 GT gs_sehir_dilim_alv-saat2
AND gs_sehir_dilim_alv-saat3 GT gs_sehir_dilim_alv-saat4
AND gs_sehir_dilim_alv-saat3 GT gs_sehir_dilim_alv-saat5
AND gs_sehir_dilim_alv-saat3 GT gs_sehir_dilim_alv-saat6
AND gs_sehir_dilim_alv-saat3 GT gs_sehir_dilim_alv-saat7.
wa_cellcolor-fname = 'SAAT3'.
wa_cellcolor-color-col = 6.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ELSEIF gs_sehir_dilim_alv-saat4 GT gs_sehir_dilim_alv-saat1
AND gs_sehir_dilim_alv-saat4 GT gs_sehir_dilim_alv-saat2
AND gs_sehir_dilim_alv-saat4 GT gs_sehir_dilim_alv-saat3
AND gs_sehir_dilim_alv-saat4 GT gs_sehir_dilim_alv-saat5
AND gs_sehir_dilim_alv-saat4 GT gs_sehir_dilim_alv-saat6
AND gs_sehir_dilim_alv-saat4 GT gs_sehir_dilim_alv-saat7
.
wa_cellcolor-fname = 'SAAT4'.
wa_cellcolor-color-col = 6.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ELSEIF gs_sehir_dilim_alv-saat5 GT gs_sehir_dilim_alv-saat1
AND gs_sehir_dilim_alv-saat5 GT gs_sehir_dilim_alv-saat2
AND gs_sehir_dilim_alv-saat5 GT gs_sehir_dilim_alv-saat3
AND gs_sehir_dilim_alv-saat5 GT gs_sehir_dilim_alv-saat4
AND gs_sehir_dilim_alv-saat5 GT gs_sehir_dilim_alv-saat6
AND gs_sehir_dilim_alv-saat5 GT gs_sehir_dilim_alv-saat7.
wa_cellcolor-fname = 'SAAT5'.
wa_cellcolor-color-col = 6.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ELSEIF gs_sehir_dilim_alv-saat6 GT gs_sehir_dilim_alv-saat1
AND gs_sehir_dilim_alv-saat6 GT gs_sehir_dilim_alv-saat2
AND gs_sehir_dilim_alv-saat6 GT gs_sehir_dilim_alv-saat3
AND gs_sehir_dilim_alv-saat6 GT gs_sehir_dilim_alv-saat4
AND gs_sehir_dilim_alv-saat6 GT gs_sehir_dilim_alv-saat5
AND gs_sehir_dilim_alv-saat6 GT gs_sehir_dilim_alv-saat7.
wa_cellcolor-fname = 'SAAT6'.
wa_cellcolor-color-col = 6.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ELSEIF gs_sehir_dilim_alv-saat7 GT gs_sehir_dilim_alv-saat1
AND gs_sehir_dilim_alv-saat7 GT gs_sehir_dilim_alv-saat2
AND gs_sehir_dilim_alv-saat7 GT gs_sehir_dilim_alv-saat3
AND gs_sehir_dilim_alv-saat7 GT gs_sehir_dilim_alv-saat4
AND gs_sehir_dilim_alv-saat7 GT gs_sehir_dilim_alv-saat5
AND gs_sehir_dilim_alv-saat7 GT gs_sehir_dilim_alv-saat6.
wa_cellcolor-fname = 'SAAT7'.
wa_cellcolor-color-col = 6.
wa_cellcolor-color-int = '1'.
wa_cellcolor-color-inv = '0'.
APPEND wa_cellcolor TO gs_sehir_dilim_alv-cellcolor.
CLEAR: wa_cellcolor.
MODIFY gt_sehir_dilim_alv FROM gs_sehir_dilim_alv
TRANSPORTING cellcolor.
ENDIF.
ENDLOOP.
layout-ctab_fname = 'CELLCOLOR'.
), look at demo program BCALV_TEST_GRID (your code seems okay, setting colors is not difficult). – Sandra Rossi