topic changing colour based on value in Application Development and Automation Discussions

changing colour based on value

former_member768291 — Wed, 01 Sep 2021 06:51:47 GMT

I have an OO ALV, in that the quantity and netprice field is editable and there is some color based on some conditions.

Now, I have requirement to change the color of the cells after editing the value , based on conditions.

Thanks in advance.

Re: changing colour based on value

former_member751591 — Wed, 01 Sep 2021 06:54:15 GMT

Welcome to the SAP Community! We wanted to give you the opportunity to take the tutorial to get started in SAP Community, as it provides tips for preparing questions that draw responses from our members.

Additionally, by adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile using Profile Tutorial

Thank you!

Re: changing colour based on value

FredericGirod — Wed, 01 Sep 2021 07:02:15 GMT

This is your requierment, not a technical question. So what is your question ?

Re: changing colour based on value

VXLozano — Wed, 01 Sep 2021 08:48:47 GMT

Did you even tried to search for help before posting this question? I have a fish memory for some things, like the one you are asking for, and I'm able to fast find the way to do it without having to post the question again and again.

As you can edit, I assume you are using the "deprecated" CL_GUI_ALV_something... check for program samples, or just search this place for

CL_GUI_ALV_something cell color

Re: changing colour based on value

Sandra_Rossi — Wed, 01 Sep 2021 09:26:39 GMT

The term "OO ALV" is confusing, are you talking about CL_GUI_ALV_GRID or about "OM ALV" (Object Model ALV A.K.A. CL_SALV_* classes)?

The question has been asked so many times how to set a color in a cell. If you tried one of the many solutions, could you precise what your issue is?

Re: changing colour based on value

former_member768291 — Thu, 02 Sep 2021 09:05:29 GMT

Yea, I am using CL_GUI_ALV_GRID

I have a requirement like i have to change the color of a cell after edit based on some condition

for example suppose if the after edit the Net price is more than 1000 so the colour of the cell will be red.

I want to know how to add colours to the cells after editing the value .

Re: changing colour based on value

Sandra_Rossi — Thu, 02 Sep 2021 11:44:01 GMT

So you know how to set the color of a given cell, but you want to know how to change it after you press a button in the toolbar, right?

So, during the processing of the function code, based on condition, you change the color in the field catalog, you transfer it to the frontend (SET_FRONTEND_FIELDCATALOG) and you refresh the ALV (REFRESH).

EDIT after raymond.giuseppi comment: sorry, I am full wrong here. You just need to update the color in the ALV internal table and call REFRESH_TABLE_DISPLAY.

Re: changing colour based on value

RaymondGiuseppi — Fri, 03 Sep 2021 10:54:18 GMT

Perform some search, you could add a column in your table, type lvc_t_scol, so for each record you can add in this itab a record per column with a color attribute

In first display of the table, pass the color column name to the IS_LAYOUT-CTAB_NAME field
As sandra.rossi wrote, once you update the displayed internal table, refresh the display with the CL_GUI_ALV_GRID->REFRESH_TABLE_DISPLAY method.

Re: changing colour based on value

former_member768291 — Fri, 03 Sep 2021 17:22:36 GMT

METHOD HANDLE_DATA_CHANGED.

    loop at er_data_changed->mt_MOD_cells into is_cells.
      check is_cells-fieldname eq 'NETPR'.
CALL METHOD rg1->get_frontend_layout
  IMPORTING
    es_layout = IS_LAYO1.
      CASE IS_CELLS-FIELDNAME.
        WHEN 'NETPR'.
      REPLACE ALL OCCURRENCES OF ',' IN IS_CELLS-VALUE WITH '.'.
          MESSAGE IS_CELLS-VALUE TYPE 'I'.
         IF IS_CELLS-VALUE >= 100000 AND IS_CELLS-VALUE <= 200000.
           MESSAGE 'HIGH' TYPE 'I'.
        ls_color-fname     = 'NETPR'.
        ls_color-color-col = 3.
        ls_color-color-int = 0.
        ls_color-color-inv = 0.
        APPEND ls_color TO <fs>-color.
      ELSE .
        MESSAGE 'LOW' TYPE 'I'.
        ls_color-fname     = 'NETPR'.
        ls_color-color-col = 4.
        ls_color-color-int = 0.
        ls_color-color-inv = 0.
        APPEND ls_color TO <fs>-color.
      ENDIF.
      ENDCASE.
ENDLOOP.
    is_layo1-ctab_fname = 'COLOR1'.

    CALL METHOD rg1->set_frontend_layout
  EXPORTING
    is_layout = is_layo1.

    CALL METHOD rg1->refresh_table_display
     EXPORTING
*       is_stable      =
       i_soft_refresh = 'X'
*     EXCEPTIONS
*       finished       = 1
*       others         = 2
           .
   IF sy-subrc <> 0.
*    Implement suitable error handling here
   ENDIF.
      ENDMETHOD.

Re: changing colour based on value

former_member768291 — Fri, 03 Sep 2021 17:27:16 GMT

Can anyone tell me what I am doing wrong ?

when I am pressing enter after editing the value no colors are coming even the old colors are also vanished.

Re: changing colour based on value

Sandra_Rossi — Fri, 03 Sep 2021 19:12:14 GMT

I am concerned about <FS>. Is it the line of the ALV internal table, of which you want to update the color in one of the cells? If yes, then its color column seems to be named COLOR, but you indicate the name COLOR1 in the layout.

Moreover, you need to call SET_FRONTEND_LAYOUT once for all, before SET_TABLE_FOR_FIRST_DISPLAY, you don't need to call it while you handle user events.