SAP 如何在ALV中显示成EXCEL的格式

1、想要展示像Excel一样，应该选用这个FUNCTION. 

REUSE_ALV_GRID_DISPLAY

REUSE_ALV_GRID_DISPLAY_LVC

2、这个是调用FUNCTION的例子。

 gs_layout-colwidth_optimize = 'X'.

  gs_layout-zebra = 'X'.

  gs_layout-min_linesize = 10.

  DATA: gv_title TYPE lvc_title,

        gv_nums  TYPE n LENGTH 7.

  gv_nums = lines( gt_bseg001 ).

  SHIFT gv_nums LEFT DELETING LEADING '0'.

  CONCATENATE '查询到' gv_nums '条凭证行' INTO gv_title.

 CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

    EXPORTING

      i_callback_program      = sy-repid

      is_layout               = gs_layout

      i_grid_title            = gv_title

      it_fieldcat             = gt_fldcat[]

      i_save                  = 'X'

    TABLES

      t_outtab                = gt_bseg001[]

    EXCEPTIONS

      program_error           = 1

      OTHERS                  = 2.

3、另一个FUNCTION调用示范

 CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY_LVC'

  EXPORTING

    i_callback_program                  = sy-repid

*    i_callback_user_command            = 'USER_COMMAND'

*    i_grid_settings                    = gs_grid

    is_layout_lvc                       = gs_layo

    it_fieldcat_lvc                     = pt_fcat[]

     it_events                          = gt_event[]

*     it_event_exit                     = gt_event_exit[]

  TABLES

    t_outtab                            = pt_tab

*   EXCEPTIONS

*     PROGRAM_ERROR                     = 1

*     OTHERS                            = 2