SAP ABAP-ALV增强，ALV实现合并单元格效果

最新推荐文章于 2024-07-19 09:56:37 发布

ggreekn

最新推荐文章于 2024-07-19 09:56:37 发布

阅读量2.9k

点赞数 5

分类专栏： ABAP小工具文章标签： sap abap

原文链接：https://tricktresor.de/blog/zellen-verbinden/

版权

ABAP小工具专栏收录该内容

13 篇文章 6 订阅

订阅专栏

本文介绍了如何在ABAP中通过增强标准CL_GUI_ALV_GRID类来实现ALV表格的单元格合并。创建了一个新的类ZCL_GUI_ALV_GRID_MERGE，包含多个方法如Z_SET_MERGE_HORIZ和Z_SET_MERGE_VERT，用于水平和垂直合并单元格，并提供了范例程序展示具体用法。此外，还展示了如何设置单元格样式和固定行列。

摘要由CSDN通过智能技术生成

前言

前几天碰到一个需求，ALV展示的时候需要实现合并单元格的效果，在网上找到了国外大佬关于增强CL_GUI_ALV_GRID的例子，可以满足我的需求

源地址：https://tricktresor.de/blog/zellen-verbinden/

一、效果

在这里插入图片描述

二、代码实现

1.增强CL_GUI_ALV_GRID

新建类ZCL_GUI_ALV_GRID_MERGE，继承超类CL_GUI_ALV_GRID
在这里插入图片描述

各方法输入输出参数：

类名: ZCL_GUI_ALV_GRID_MERGE
描述: 增强ALV

**************************************************************************
*   Class attributes.                                                    *
**************************************************************************
Instantiation: Public
Message class:
State: Implemented
Final Indicator: X
R/3 Release: 740

**************************************************************************
*   Public section of class.                                             *
**************************************************************************
class ZCL_GUI_ALV_GRID_MERGE definition
  public
  inheriting from CL_GUI_ALV_GRID
  final
  create public .

public section.

  methods Z_SET_MERGE_HORIZ
    importing
      ROW type I
    changing
      TAB_COL_MERGE type LVC_T_CO01 .
  methods Z_SET_MERGE_VERT
    importing
      ROW type I
    changing
      TAB_COL_MERGE type LVC_T_CO01 .
  methods Z_DISPLAY .
  methods Z_SET_CELL_STYLE
    importing
      ROW type I optional
      COL type I optional
      STYLE type LVC_STYLE
      STYLE2 type LVC_STYLE optional .
  methods Z_SET_FIXED_COL_ROW
    importing
      ROW type I
      COL type I .
  methods Z_INIT_CELL_STYLES .

**************************************************************************
*   Private section of class.                                            *
**************************************************************************
private section.

**************************************************************************
*   Protected section of class.                                          *
**************************************************************************
protected section.

**************************************************************************
*   Types section of class.                                              *
**************************************************************************
*"* dummy include to reduce generation dependencies between
*"* class ZCL_GUI_ALV_GRID_MERGE and it's users.
*"* touched if any type reference has been changed

新增方法统一为public
在这里插入图片描述

Z_SET_MERGE_HORIZ

METHOD Z_SET_MERGE_HORIZ.

* ROW - Zeile deren Spalten zusammengef�hrt werden sollen
* tab_col_merge - Spalten, die zusammengef�hrt werden sollen
  FIELD-SYMBOLS <fs_cols> TYPE lvc_s_co01.
  FIELD-SYMBOLS <fs_data> TYPE lvc_s_data.
  DATA outputlen TYPE I.

  SORT tab_col_merge.
* Die Spalten, die zusammengef�hrt werden sollen
  LOOP AT tab_col_merge ASSIGNING <fs_cols>.
* ein paar Pr�fungen
    IF <fs_cols>-col_id    LE 0.                CONTINUE. ENDIF.
    IF <fs_cols>-outputlen LE <fs_cols>-col_id. CONTINUE. ENDIF.
    outputlen = <fs_cols>-outputlen - <fs_cols>-col_id.
    LOOP AT mt_data ASSIGNING <fs_data>
    WHERE row_pos = row  AND
    ( col_pos BETWEEN <fs_cols>-col_id AND
    <fs_cols>-outputlen ).
* Setze wie weit soll gemerged werden Von Spalte in L�nge
* und zwar wird bei der 1 Spalte angefangen
      IF <fs_data>-col_pos = <fs_cols>-col_id.
        <fs_data>-mergehoriz = outputlen.
* bei allen anderen, die zusammangeh�ren
* muss der Wert raus, da er aus der 1. Spalte kommt
* und das mergekennzeichen muss auch weg !
      ELSE.
        CLEAR <fs_data>-mergehoriz.
        CLEAR <fs_data>-VALUE.
      ENDIF.
    ENDLOOP.

  ENDLOOP.

ENDMETHOD.

Z_SET_MERGE_VERT

METHOD Z_SET_MERGE_VERT.

* ROW - Zeile deren Spalten zusammengef�hrt werden sollen
* tab_col_merge - Spalten, die zusammengef�hrt werden sollen
  FIELD-SYMBOLS <fs_cols> TYPE lvc_s_co01.
  FIELD-SYMBOLS <fs_data> TYPE lvc_s_data.
  DATA outputlen TYPE I.

  SORT tab_col_merge.
* Die Spalten, die zusammengef�hrt werden sollen
  LOOP AT tab_col_merge ASSIGNING <fs_cols>.
* ein paar Pr�fungen
    IF <fs_cols>-col_id    LE 0.                CONTINUE. ENDIF.
    IF <fs_cols>-outputlen LE <fs_cols>-col_id. CONTINUE. ENDIF.
    outputlen = <fs_cols>-outputlen - <fs_cols>-col_id.
    LOOP AT mt_data ASSIGNING <fs_data>
    WHERE row_pos = row  AND
    ( col_pos BETWEEN <fs_cols>-col_id AND
    <fs_cols>-outputlen ).
* Setze wie weit soll gemerged werden Von Spalte in L�nge
* und zwar wird bei der 1 Spalte angefangen
      IF <fs_data>-col_pos = <fs_cols>-col_id.
        <fs_data>-mergevert = outputlen.
* bei allen anderen, die zusammangeh�ren
* muss der Wert raus, da er aus der 1. Spalte kommt
* und das mergekennzeichen muss auch weg !
      ELSE.
        CLEAR <fs_data>-mergevert.
        CLEAR <fs_data>-VALUE.
      ENDIF.
    ENDLOOP.

  ENDLOOP.

ENDMETHOD.

Z_DISPLAY

METHOD Z_DISPLAY.

  DATA lv_stable TYPE lvc_s_stbl.
  DATA lv_soft   TYPE C.

**** Prepare refresh
*  lv_stable-row = 'X'.
*  lv_stable-col = 'X'.
*  lv_soft       = 'X'.
*
**** Refresh table because Z_SET_CELL_STYLE adds style-values
**** Refresh initializes mt_data
*  CALL METHOD refresh_table_display
*    EXPORTING
*      is_stable      = lv_stable
*      i_soft_refresh = lv_soft
*    EXCEPTIONS
*      OTHERS         = 1.

* Jetzt noch  �bertragen der ge�nderten Daten
  CALL METHOD me->set_data_table
  CHANGING
    data_table = mt_data[].

  CALL METHOD set_auto_redraw
  EXPORTING
    enable = 1.

ENDMETHOD.

Z_SET_CELL_STYLE

METHOD Z_SET_CELL_STYLE.

  FIELD-SYMBOLS <fs_data> TYPE lvc_s_data.
  IF row IS INITIAL.
    IF col IS INITIAL.
* Beides leer -> nichts zu tun.
      EXIT.
    ELSE.
* Nur Spalte setze komplette Spalte
      LOOP AT mt_data ASSIGNING <fs_data>
      WHERE col_pos = col.
        <fs_data>-style  = <fs_data>-style + style.
        <fs_data>-style2 = <fs_data>-style2 + style2.
      ENDLOOP.
    ENDIF.
  ELSE.
    IF col IS INITIAL.
* Nur Zeile eingegeben -> komplette Zeile setzen
      LOOP AT mt_data ASSIGNING <fs_data>
      WHERE row_pos = row.
        <fs_data>-style  = <fs_data>-style + style.
        <fs_data>-style2 = <fs_data>-style2 + style2.
      ENDLOOP.
    ELSE.
      READ TABLE mt_data ASSIGNING <fs_data>
      WITH KEY row_pos = row
      col_pos = col.
      IF sy-subrc EQ 0.
        <fs_data>-style  = <fs_data>-style + style.
        <fs_data>-style2 = <fs_data>-style2 + style2.
      ELSE.
        EXIT.
      ENDIF.
    ENDIF.
  ENDIF.

ENDMETHOD.

Z_SET_FIXED_COL_ROW

METHOD Z_SET_FIXED_COL_ROW.

  me->set_fixed_cols( col ).
  me->set_fixed_rows( row ).

ENDMETHOD.

Z_INIT_CELL_STYLES

METHOD Z_INIT_CELL_STYLES.
  FIELD-SYMBOLS <fs_data> TYPE lvc_s_data.
* Nur Spalte setze komplette Spalte
  LOOP AT mt_data ASSIGNING <fs_data>.
    <fs_data>-style = 0.
  ENDLOOP.
ENDMETHOD.

2.范例程序

*&---------------------------------------------------------------------*
*& Report  ZTEST_MERGE_CELL
*&         Description:
*&---------------------------------------------------------------------*
*&         Author:
*&         Date:
*&---------------------------------------------------------------------*

REPORT ZTEST_MERGE_CELL.
*&---------------------------------------------------------------------*
*& (c) Edwin Leippi Software-Entwicklung                               *
*& Email : info@leippi.de                                              *
*& Datum : 01.03.2008                                                  *
*&                                                                     *
*& Der Autor �bernimmt keine Haftung f�r Sch�den,                      *
*& die durch den Einsatz dieses Programmes entstehen k�nnen            *
*&---------------------------------------------------------------------*
*& http://www.tricktresor.de
*&---------------------------------------------------------------------*



* *** Allgemeines  ****************************************************
INCLUDE <cl_alv_control>.
INCLUDE <icon>.
DATA retc    TYPE sy-subrc.                  .
DATA ok_code TYPE sy-ucomm.
DATA it_grp  TYPE lvc_t_sgrp.
DATA it_fil  TYPE lvc_t_filt.
DATA wa_fil  TYPE lvc_s_filt.

* **** ALV_GRID    ****************************************************
TYPES: BEGIN OF t_check_styles,
  field01(20),
  field02(20),
  field03(20),
  field04(20),
  field05(20),
  field06(20),
  field07(20),
  field08(20),
  field09(20),
  field10(20),
  field11(20),
  field12(20).
TYPES END OF t_check_styles.

DATA it_styles TYPE  t_check_styles OCCURS 0.
DATA wa_styles TYPE t_check_styles.
FIELD-SYMBOLS <fs_styles>        TYPE t_check_styles.
DATA :          lt_fieldcatalog  TYPE lvc_t_fcat.
DATA :          ls_fieldcatalog  TYPE lvc_t_fcat.
DATA :          wa_cat           TYPE lvc_s_fcat.
DATA : fieldname(40).
DATA : fieldnr(2) TYPE n.

FIELD-SYMBOLS  <fs_cat> TYPE lvc_s_fcat.

DATA  lt_iinfo TYPE lvc_t_info.
DATA  wa_iinfo TYPE lvc_s_info.
DATA  lt_idata TYPE lvc_t_data.
DATA  wa_idata TYPE lvc_s_data.

DATA it_col_merge        TYPE lvc_t_co01.
DATA wa_col_merge        TYPE lvc_s_co01.
DATA: g_container        TYPE scrfname VALUE 'CU_CON'.
DATA: g_custom_container TYPE REF TO cl_gui_custom_container.
DATA  g_alv_grid         TYPE REF TO zcl_gui_alv_grid_merge.
CLASS cl_gui_cfw DEFINITION LOAD.

DATA: x_save,                     "for Parameter I_SAVE
      gs_variant TYPE disvariant. "for parameter IS_VARIANT
DATA gs_layout TYPE lvc_s_layo.   " Layout
DATA wa_style  TYPE lvc_s_styl.


* **** ALV_GRID    ****************************************************
START-OF-SELECTION.
CALL SCREEN 0200.

END-OF-SELECTION.




*&---------------------------------------------------------------------*
*&      Module  STATUS_0100  OUTPUT
*&---------------------------------------------------------------------*
MODULE status_0200 OUTPUT.

** Status und Titel setzen
  SET PF-STATUS '0200'.
  SET TITLEBAR '001'.

** Objekte instanzieren und zuordnen: Grid
  IF g_custom_container IS INITIAL.

    CREATE OBJECT g_custom_container
    EXPORTING
      container_name = g_container.

    CREATE OBJECT g_alv_grid
    EXPORTING
      i_parent = g_custom_container.

    gs_layout-stylefname = 'CELL'.
    gs_layout-no_headers = 'X'.
    gs_layout-cwidth_opt = ' '.
    gs_layout-no_toolbar = 'X'.

** Feldkatalog erzeugen
    REFRESH lt_fieldcatalog.

    CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'
    EXPORTING
      i_internal_tabname     = 'IT_STYLES'
    CHANGING
      ct_fieldcat            = lt_fieldcatalog
    EXCEPTIONS
      inconsistent_interface = 1
      program_error          = 2
      OTHERS                 = 3.

    REFRESH lt_fieldcatalog.
    REFRESH lt_iinfo.

    DO 12 TIMES.
      CLEAR wa_cat.
      fieldnr = sy-INDEX.
      wa_cat-col_pos = sy-INDEX.
      CONCATENATE 'FIELD' fieldnr INTO fieldname.
      wa_cat-fieldname = fieldname.
      wa_cat-tabname   = '1'.
      wa_cat-datatype  = 'CHAR'.
      wa_cat-inttype   = 'C'.
      wa_cat-intlen    = 20.
      IF sy-INDEX > 1.
        wa_cat-outputlen    = 6.
      ELSE.
        wa_cat-outputlen    = 20.
      ENDIF.
      wa_cat-reptext   = fieldname.
      wa_cat-scrtext_l = fieldname.
      wa_cat-scrtext_m = fieldname.
      wa_cat-scrtext_s = fieldname.
      wa_cat-scrtext_l = fieldname.
      APPEND wa_cat TO lt_fieldcatalog.
    ENDDO.

* 1 Zeile
    CLEAR wa_styles.
    wa_styles-field01 = 'TRICKTRESOR'.
    wa_styles-field03 = 'F'.
    wa_styles-field04 = 'P'.
    wa_styles-field09 = 'M'.
    wa_styles-field10 = 'K'.
    APPEND wa_styles TO it_styles.
* 2 Zeile
    CLEAR wa_styles.
    wa_styles-field03 = 'HQ'.
    wa_styles-field04 = 'HC'.
    wa_styles-field08 = 'HW'.
    wa_styles-field09 = 'HC'.
    wa_styles-field10 = 'HC'.
    wa_styles-field12 = 'HW'.
    APPEND wa_styles TO it_styles.
* 3-Zeile
    CLEAR wa_styles.
    wa_styles-field01 = 'Bezeichnung'.
    wa_styles-field02 = 'Radius'.
    wa_styles-field03 = 'WPX 12'.
    wa_styles-field04 = 'WAP 25'.
    wa_styles-field05 = 'WAP 35'.
    wa_styles-field06 = 'WTP 35'.
    wa_styles-field07 = 'WXP 45'.
    wa_styles-field08 = 'WPM'.
    wa_styles-field09 = 'WXM 35'.
    wa_styles-field10 = 'WAK 15'.
    wa_styles-field11 = 'WAK 25'.
    wa_styles-field12 = 'WKM'.
    APPEND wa_styles TO it_styles.

* 4..Zeile
    CLEAR wa_styles.
    wa_styles-field01 = 'SPMW 060304 T - A 27'.
    wa_styles-field02 = '0.54'.
    wa_styles-field03 = icon_led_green.
    wa_styles-field04 = icon_led_yellow.
    wa_styles-field05 = icon_led_red.
    wa_styles-field08 = icon_led_yellow.
    APPEND wa_styles TO it_styles.

    CLEAR wa_styles.
    wa_styles-field01 = 'SPMW 060304 - A 57'.
    wa_styles-field02 = '0.43'.
    wa_styles-field03 = icon_led_yellow.
    wa_styles-field05 = icon_led_red.
    wa_styles-field08 = icon_led_yellow.
    wa_styles-field10 = icon_led_yellow.
    wa_styles-field11 = icon_led_red.
    wa_styles-field12 = icon_led_yellow.
    APPEND wa_styles TO it_styles.

    CLEAR wa_styles.
    wa_styles-field01 = 'SPMW 060304 - D 51'.
    wa_styles-field02 = '0.76'.
    wa_styles-field04 = icon_led_yellow.
    wa_styles-field05 = icon_led_red.
    wa_styles-field06 = icon_led_red.
    wa_styles-field07 = icon_led_red.
    APPEND wa_styles TO it_styles.

    CLEAR wa_styles.
    wa_styles-field01 = 'SPMW 060304 - F 55'.
    wa_styles-field02 = '0.44'.
    wa_styles-field03 = icon_led_red.
    wa_styles-field05 = icon_led_green.
    wa_styles-field06 = icon_led_yellow.
    wa_styles-field07 = icon_led_red.
    wa_styles-field09 = icon_led_yellow.
    wa_styles-field10 = icon_led_green.
    wa_styles-field11 = icon_led_yellow.
    wa_styles-field12 = icon_led_yellow.
    APPEND wa_styles TO it_styles.

*
    CALL METHOD g_alv_grid->set_table_for_first_display
    EXPORTING
      is_variant      = gs_variant
      i_save          = x_save
      is_layout       = gs_layout
    CHANGING
      it_fieldcatalog = lt_fieldcatalog
      it_outtab       = it_styles.

    REFRESH it_col_merge.

*** DEMO vertikal verbinden
    wa_col_merge-col_id    = 1.
    wa_col_merge-outputlen = 2.
    APPEND wa_col_merge TO it_col_merge.

    CALL METHOD g_alv_grid->z_set_merge_vert
    EXPORTING
      row           = 1
    CHANGING
      tab_col_merge = it_col_merge.
    wa_style-style     = alv_style_font_bold
    + alv_style_align_center_center
    + alv_style_color_key.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      row   = 1
      col   = 1
      style = wa_style-style.

*** VERTIKAL verbinden
    CLEAR it_col_merge.

    wa_col_merge-col_id    = 4.
    wa_col_merge-outputlen = 8.
    APPEND wa_col_merge TO it_col_merge.

    wa_col_merge-col_id    = 10.
    wa_col_merge-outputlen = 12.
    APPEND wa_col_merge TO it_col_merge.

    CALL METHOD g_alv_grid->z_set_merge_horiz
    EXPORTING
      row           = 1
    CHANGING
      tab_col_merge = it_col_merge.

    wa_style-style     = alv_style_font_bold.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      row   = 1
      col   = 3
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      row   = 1
      col   = 4
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      row   = 1
      col   = 9
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      row   = 1
      col   = 10
      style = wa_style-style.

    REFRESH it_col_merge.

    wa_col_merge-col_id    = 4.
    wa_col_merge-outputlen = 7.
    APPEND wa_col_merge TO it_col_merge.

    wa_col_merge-col_id    = 10.
    wa_col_merge-outputlen = 2.
    APPEND wa_col_merge TO it_col_merge.


    CALL METHOD g_alv_grid->z_set_merge_horiz
    EXPORTING
      row           = 2
    CHANGING
      tab_col_merge = it_col_merge.

    wa_style-style     = alv_style_color_group +
    alv_style_align_center_center.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 3
      style = wa_style-style.

    wa_style-style     = alv_style_color_heading +
    alv_style_align_center_center.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 4
      style = wa_style-style.


    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 5
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 6
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 7
      style = wa_style-style.
    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 8
      style = wa_style-style.

    wa_style-style     = alv_style_color_total +
    alv_style_align_center_center.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 9
      style = wa_style-style.


    wa_style-style     = alv_style_color_negative +
    alv_style_align_center_center.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 10
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 11
      style = wa_style-style.


    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 12
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 13
      style = wa_style-style.

    wa_style-style     = alv_style_color_positive +
    alv_style_align_center_center.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 14
      style = wa_style-style.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 15
      style = wa_style-style.

    wa_style-style     = alv_style_color_int_background +
    alv_style_align_center_center.

    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      col   = 16
      style = wa_style-style.

    wa_style-style     = alv_style_color_positive +
    alv_style_align_center_center +
    alv_style_font_italic.


    CALL METHOD g_alv_grid->z_set_cell_style
    EXPORTING
      row   = 4
      col   = 2
      style = wa_style-style.

    g_alv_grid->z_set_fixed_col_row(
    EXPORTING col = 3
      row = 3 ).

    g_alv_grid->z_display( ).

  ENDIF.
ENDMODULE.                    "status_0100 OUTPUT
*&---------------------------------------------------------------------*
*&      Module  USER_COMMAND_0100  INPUT
*&---------------------------------------------------------------------*
MODULE user_command_0200 INPUT.
*   to react on oi_custom_events:
  cl_gui_cfw=>dispatch( ).

  CASE ok_code.
  WHEN 'BACK'.
    SET SCREEN 0. LEAVE SCREEN.
  ENDCASE.


ENDMODULE.                 " USER_COMMAND_0100  INPUT