![\"SAP\"](\"http:\/\/oprsteny.cz\/wp-content\/uploads\/SAP.jpg\")
In this example I’ll show how to add a column which will hold a user defined icon\u00a0to the ALV grid. The core is:<\/p>\nIn this example I’ll show how to add a column which will hold a user defined icon\u00a0to the ALV grid. The core is:<\/p>\n
gt_data<\/code> (this will hold the icon information)<\/span><\/li>\n- Modify the field catalog
gt_fieldcat<\/code> so it’s updated with info about our new field and set this new field as icon<\/li>\n- Read and prepare data for output (read data from DB and update the icon field based on your criteria)<\/li>\n
- Display or refresh our ALV grid (
g_grid->set_table_for_first_display<\/code>) using the modified field catalog<\/li>\n<\/ol>\n1. Data definition<\/h1>\n
Here we create the output table with field ICON – this will be used to store the icon name.<\/p>\n
TYPES: BEGIN OF ty_data.\r\n INCLUDE STRUCTURE sflight.\r\nTYPES: icon(4) TYPE c, \" field to hold the icon\r\n END OF ty_data.\r\n\r\nDATA: gt_data TYPE TABLE OF ty_data,\r\n g_grid TYPE REF TO cl_gui_alv_grid,\r\n gs_layout TYPE lvc_s_layo,\r\n gt_fieldcat TYPE lvc_t_fcat.<\/pre>\n2. Field catalog<\/h1>\n
Now we prepare field catalog for data structure we’re going to use and update it with the new ICON field<\/p>\n
FORM get_fieldcat .\r\n FIELD-SYMBOLS: <fs_fcat> TYPE lvc_s_fcat.\r\n\r\n CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'\r\n EXPORTING\r\n i_structure_name = 'SFLIGHT'\r\n CHANGING\r\n ct_fieldcat = gt_fieldcat\r\n EXCEPTIONS\r\n inconsistent_interface = 1\r\n program_error = 2\r\n OTHERS = 3.\r\n CHECK sy-subrc = 0.\r\n\r\n APPEND INITIAL LINE TO gt_fieldcat ASSIGNING <fs_fcat>.\r\n <fs_fcat>-fieldname = 'ICON'.\r\n <fs_fcat>-icon = 'X'.\r\n <fs_fcat>-outputlen = 3.\r\nENDFORM.<\/pre>\n3. Read data<\/h1>\n
In our example we would like to add “warning” icon when some of the travel classes is full (see the line <fs_data>-icon = '@AH@'.<\/code>)<\/p>\nFORM read_data.\r\n DATA:\r\n l_color TYPE c.\r\n\r\n FIELD-SYMBOLS:\r\n <fs_data> TYPE ty_data.\r\n\r\n SELECT * INTO CORRESPONDING FIELDS OF TABLE gt_data\r\n FROM sflight\r\n UP TO c_max_rows ROWS.\r\n\r\n LOOP AT gt_data ASSIGNING <fs_data>.\r\n IF <fs_data>-seatsocc = <fs_data>-seatsmax OR\r\n <fs_data>-seatsocc_b = <fs_data>-seatsmax_b OR\r\n <fs_data>-seatsocc_f = <fs_data>-seatsmax_f.\r\n \" Some class is full\r\n <fs_data>-icon = '@AH@'. \" Warning Icon\r\n ENDIF.\r\n ENDLOOP.\r\nENDFORM.<\/pre>\nTogether with field catalog we modified the ALV grid layout to display lines in “zebra” style<\/p>\n
FORM get_layout .\r\n gs_layout-zebra = 'X'.\r\nENDFORM.<\/pre>\n4. Display data<\/h1>\n
Now we display our data with new field containing a warning icon in case some of the travel classes is full<\/p>\n
FORM display_grid.\r\n PERFORM get_layout.\r\n PERFORM get_fieldcat.\r\n\r\n CREATE OBJECT g_grid\r\n EXPORTING\r\n i_parent = cl_gui_container=>default_screen.\r\n\r\n CALL METHOD g_grid->set_table_for_first_display\r\n EXPORTING\r\n i_structure_name = 'SFLIGHT'\r\n is_layout = gs_layout\r\n CHANGING\r\n it_outtab = gt_data\r\n it_fieldcatalog = gt_fieldcat\r\n EXCEPTIONS\r\n invalid_parameter_combination = 1\r\n program_error = 2\r\n too_many_lines = 3\r\n OTHERS = 4.\r\n IF sy-subrc <> 0.\r\n MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno\r\n WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.\r\n ENDIF.\r\nENDFORM.<\/pre>\n
![\"ALV](\"http:\/\/oprsteny.cz\/wp-content\/uploads\/ALV_DEMO_03_output.png\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"