Skip to Content
author's profile photo
Former Member

Colors in ALV Report

Hello friends,

I want to use check that if material no is 'x' then that roe should be dispaly in red color in ALV report.

I m not using SLIS typepools here.

Sujjest me idea

Regards,

rohan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 07:04 AM

    Hi

    The below links will give you enough information for adding colors in ALV.

    http://help.sap.com/saphelp_erp2004/helpdata/en/fa/efb529f8a611d2b48d006094192fe3/frameset.htm

    http://help.sap.com/saphelp_erp2004/helpdata/en/fa/efb529f8a611d2b48d006094192fe3/frameset.htm

    Plz go thru these links for sample pgm

    http://www.sap-img.com/abap/line-color-in-alv-example.htm

    http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_color.htm

    REPORT ZOBJK1 .

    *****************************************************************

    • Use of colours in ALV grid (cell, line and column) *

    *****************************************************************

    • Table

    tables : mara.

    • Type

    types : begin of ty_mara,

    matnr like mara-matnr,

    matkl like mara-matkl,

    counter(4) type n,

    free_text(15) type c,

    color_line(4) type c, " Line color

    color_cell type lvc_t_scol, " Cell color

    end of ty_mara.

    • Structures

    data : wa_mara type ty_mara,

    wa_fieldcat type lvc_s_fcat,

    is_layout type lvc_s_layo,

    wa_color type lvc_s_scol.

    • Internal table

    data : it_mara type standard table of ty_mara,

    it_fieldcat type standard table of lvc_s_fcat,

    it_color type table of lvc_s_scol.

    • Variables

    data : okcode like sy-ucomm,

    w_alv_grid type ref to cl_gui_alv_grid,

    w_docking_container type ref to cl_gui_docking_container.

    parameters : p_column as checkbox,

    p_line as checkbox,

    p_cell as checkbox.

    at selection-screen output.

    perform get_data.

    perform fill_catalog.

    if w_docking_container is initial.

    perform create_objects.

    endif.

    &----


    *& Form create_objects

    &----


    form create_objects.

    create object w_docking_container

    exporting

    ratio = 40

    exceptions

    cntl_error = 1

    cntl_system_error = 2

    create_error = 3

    lifetime_error = 4

    lifetime_dynpro_dynpro_link = 5

    others = 6.

    create object w_alv_grid

    exporting

    i_parent = w_docking_container.

    • Field that identify color line in internal table

    move 'COLOR_LINE' to is_layout-info_fname.

    • Field that identify cell color in inetrnal table

    move 'COLOR_CELL' to is_layout-ctab_fname.

    call method w_alv_grid->set_table_for_first_display

    exporting

    is_layout = is_layout

    changing

    it_outtab = it_mara

    it_fieldcatalog = it_fieldcat

    exceptions

    invalid_parameter_combination = 1

    program_error = 2

    too_many_lines = 3

    others = 4.

    endform.

    &----


    *& Form get_data

    &----


    form get_data.

    select * from mara up to 5 rows.

    clear : wa_mara-color_line, wa_mara-color_cell.

    move-corresponding mara to wa_mara.

    add 1 to wa_mara-counter.

    move 'Blabla' to wa_mara-free_text.

    if wa_mara-counter = '0002'

    and p_line = 'X'.

    • Color line

    move 'C410' to wa_mara-color_line.

    elseif wa_mara-counter = '0004'

    and p_cell = 'X'.

    • Color cell

    move 'FREE_TEXT' to wa_color-fname.

    move '6' to wa_color-color-col.

    move '1' to wa_color-color-int.

    move '1' to wa_color-color-inv.

    append wa_color to it_color.

    wa_mara-color_cell[] = it_color[].

    endif.

    append wa_mara to it_mara.

    endselect.

    endform.

    &----


    *& Form fill_catalog

    &----


    form fill_catalog.

    *****************************************************************

    • Colour code : *

    • Colour is a 4-char field where : *

    • - 1st char = C (color property) *

    • - 2nd char = color code (from 0 to 7) *

    • 0 = background color *

    • 1 = blue *

    • 2 = gray *

    • 3 = yellow *

    • 4 = blue/gray *

    • 5 = green *

    • 6 = red *

    • 7 = orange *

    • - 3rd char = intensified (0=off, 1=on) *

    • - 4th char = inverse display (0=off, 1=on) *

    • *

    • Colour overwriting priority : *

    • 1. Line *

    • 2. Cell *

    • 3. Column *

    *****************************************************************

    data : w_position type i value '1'.

    clear wa_fieldcat.

    move w_position to wa_fieldcat-col_pos.

    move 'MATNR' to wa_fieldcat-fieldname.

    move 'MARA' to wa_fieldcat-ref_table.

    move 'MATNR' to wa_fieldcat-ref_field.

    append wa_fieldcat to it_fieldcat.

    add 1 to w_position.

    clear wa_fieldcat.

    move w_position to wa_fieldcat-col_pos.

    move 'MATKL' to wa_fieldcat-fieldname.

    move 'MARA' to wa_fieldcat-ref_table.

    move 'MATKL' to wa_fieldcat-ref_field.

    • Color column

    if p_column = 'X'.

    move 'C610' to wa_fieldcat-emphasize.

    endif.

    append wa_fieldcat to it_fieldcat.

    add 1 to w_position.

    clear wa_fieldcat.

    move w_position to wa_fieldcat-col_pos.

    move 'COUNTER' to wa_fieldcat-fieldname.

    move 'N' to wa_fieldcat-inttype.

    move '4' to wa_fieldcat-intlen.

    move 'Counter' to wa_fieldcat-coltext.

    append wa_fieldcat to it_fieldcat.

    add 1 to w_position.

    clear wa_fieldcat.

    move w_position to wa_fieldcat-col_pos.

    move 'FREE_TEXT' to wa_fieldcat-fieldname.

    move 'C' to wa_fieldcat-inttype.

    move '20' to wa_fieldcat-intlen.

    move 'Text' to wa_fieldcat-coltext.

    append wa_fieldcat to it_fieldcat.

    endform

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 07:12 AM

    Hi

    <b>Coloring Individual Cells</b>

    The procedure is similar to coloring an entire row. However, since an individual cell can be addressed with two parameters we will need something more. What is meant by “more” is a table type structure to be included into the structure of the list data table. It seems strange, because including it will make our list data structure deep. But anyhow ALV Grid control handles this.

    The structure that should be included must be of type “LVC_T_SCOL”. If you want to color the entire row, this inner table should contain only one row with field “fname” is set to space, some color value at field “col”, “0” or “1” at fields “int” (intensified) and “inv” (inverse).

    If you want to color individual cells, then for each cell column, append a line to this inner table which also contains the column name at field “fname”. It is obvious that you can color an entire column by filling this inner table with a row for that column for each row in the list data table.

    Again key field coloring will override your settings. That’s why, we have another field in this inner table called “nokeycol”. For each field represented in the inner table, set this field to ‘X’ to prevent overriding of key color settings.

    In this procedure, again we must tell the control the name of the inner table containing color data. The field “CTAB_FNAME” of the layout structure is used for this purpose.

    Adding inner table that will contain cell color data

    *--- Internal table holding list data

    DATA BEGIN OF gt_list OCCURS 0 .

    INCLUDE STRUCTURE SFLIGHT .

    DATA rowcolor(4) TYPE c .

    DATA cellcolors TYPE lvc_t_scol .

    DATA END OF gt_list .

    DATA ls_cellcolor TYPE lvc_s_scol .

    ...

    READ TABLE gt_list INDEX 5 .

    ls_cellcolor-fname = 'SEATSOCC' .

    ls_cellcolor-color-col = '7' .

    ls_cellcolor-color-int = '1' .

    APPEND ls_cellcolor TO gt_list-cellcolors .

    MODIFY gt_list INDEX 5 .

    Regards

    Preeti

    <i>

    Reward if useful</i>

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 09:22 PM

    Hello Rohan

    Assuming that you are using OO-based ALV lists (or at least function REUSE_ALV_GRID_DISPLAY_LVC) then you should not miss the excellent tutorial:

    An" target="_blank">www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e8a1d690-0201-0010-b7ad-d9719a415907">An Easy Reference For ALV Grid Control

    Regards

    Uwe

    Add comment
    10|10000 characters needed characters exceeded