ALV报表列显示求和（do_sum）

1.背景

在ALV报表开发的时候，主要是通过wa_fieldcat-do_sum = 'X’来显示各例的统计。

2.代码如下

REPORT ZJGLTEST.
TYPE-POOLS: slis.  " SLIS contains all the ALV data types
*&---------------------------------------------------------------------*
*& Data Declaration
*&---------------------------------------------------------------------*
DATA: item TYPE TABLE OF FAGLFLEXT.
DATA: it_fieldcat  TYPE slis_t_fieldcat_alv,
      wa_fieldcat  TYPE slis_fieldcat_alv.
      wa_fieldcat-do_sum     = 'X'.
*&---------------------------------------------------------------------*
*& START-OF-SELECTION
*&---------------------------------------------------------------------*
START-OF-SELECTION.

*Fetch data from the database
  SELECT * FROM FAGLFLEXT INTO TABLE  item.

*Build field catalog


  wa_fieldcat-fieldname  = 'TSL01'.    " Fieldname in the data table
  wa_fieldcat-seltext_m  = 'January'.   " Column description in the output
  APPEND wa_fieldcat TO it_fieldcat.

  wa_fieldcat-fieldname  = 'TSL02'.
  wa_fieldcat-seltext_m  = 'Febuary'.
  APPEND wa_fieldcat TO it_fieldcat.

   wa_fieldcat-fieldname  = 'TSL03'.
  wa_fieldcat-seltext_m  = 'MARCH'.
  APPEND wa_fieldcat TO it_fieldcat.


  wa_fieldcat-fieldname  = 'TSL04'.
  wa_fieldcat-seltext_m  = 'April'.
  APPEND wa_fieldcat TO it_fieldcat.


wa_fieldcat-fieldname  = 'TSL05'.
  wa_fieldcat-seltext_m  = 'May'.
  APPEND wa_fieldcat TO it_fieldcat.


wa_fieldcat-fieldname  = 'TSL06'.
  wa_fieldcat-seltext_m  = 'June'.
APPEND wa_fieldcat TO it_fieldcat.

wa_fieldcat-fieldname  = 'TSL07'.
  wa_fieldcat-seltext_m  = 'July'.
  APPEND wa_fieldcat TO it_fieldcat.

 wa_fieldcat-fieldname  = 'TSL08'.
  wa_fieldcat-seltext_m  = 'Augest'.
  APPEND wa_fieldcat TO it_fieldcat.


 wa_fieldcat-fieldname  = 'TSL09'.
  wa_fieldcat-seltext_m  = 'September'.
  APPEND wa_fieldcat TO it_fieldcat.



  wa_fieldcat-fieldname  = 'TSL10'.
  wa_fieldcat-seltext_m  = 'Ocutomber'.
  APPEND wa_fieldcat TO it_fieldcat.


 wa_fieldcat-fieldname  = 'TSL11'.
  wa_fieldcat-seltext_m  = 'November'.
  APPEND wa_fieldcat TO it_fieldcat.



 wa_fieldcat-fieldname  = 'TSL12'.
  wa_fieldcat-seltext_m  = 'December'.
  APPEND wa_fieldcat TO it_fieldcat.




*Pass data and field catalog to ALV function module to display ALV list
  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
    EXPORTING
      it_fieldcat   = it_fieldcat
    TABLES
      t_outtab      = item
    EXCEPTIONS
      program_error = 1
      OTHERS        = 2.

效果展示如下：

3总结

1.实际是通过append来添加；
2.本程序的重点是通过wa_fieldcat-do_sum = ‘X’ 来在ALV报表上展示和(do_sum实际上就是slis_fieldcat_alv中的一个参数.)；
3.没有通过宏来展示；