How to make 2 subcolumn of a particular column in ALV grid display

[Former Member]

Hi,

Please let me know how can I make 2 sub columns of a particular column in ALV grid display.

Example.

Please help me its urgent.....

Thanks in advance.

[Former Member]

Not possible.

http://scn.sap.com/thread/3190823

http://scn.sap.com/thread/3159254

[venkateswaran_k]

Hi

It is not possible ..

however, there is a workaraound.

You can colour/highlight those two columns in order to bring the effect of merging..

Regards,

Venkat

[Former Member]

Hi,

AFAIK you cannot achieve this with ALV grid. You can do this with ALV list or classical report only.

Kr,

Manu.

[Former Member]

Dear Manu,

Can you please let me know how we can do this using ALV list display.

Thanks in advance

[Former Member]

By maintaining your own TOP-OF-PAGE event.

Here is an old method I made for such a requirement:

METHOD show_dashboard_list.
    TYPE-POOLS: slis.
    DATA: lt_alv_fieldcat TYPE slis_t_fieldcat_alv,
          lt_evt TYPE slis_t_event,
          lt_excluding TYPE slis_t_extab,
          ls_alv_layout TYPE slis_layout_alv,
          ls_fieldcat TYPE  slis_fieldcat_alv,
          ls_evt TYPE slis_alv_event,
          l_repid TYPE syrepid.
*-- Set events
    CALL FUNCTION 'REUSE_ALV_EVENTS_GET'
      IMPORTING
        et_events = lt_evt.
    READ TABLE lt_evt INTO ls_evt
      WITH KEY name = slis_ev_top_of_page.
    ls_evt-form = slis_ev_top_of_page.
    MODIFY lt_evt FROM ls_evt INDEX sy-tabix.
*-- Build field catalog
    ls_fieldcat-tabname       = 'GT_DASH'.
    ls_fieldcat-fieldname     = 'DATUM'.
    ls_fieldcat-ref_tabname   = 'ZHR_REFOG_DASH'.
    ls_fieldcat-outputlen     = '10'.
    ls_fieldcat-col_pos       = 1.
    APPEND ls_fieldcat TO lt_alv_fieldcat.
    CLEAR ls_fieldcat.
    ls_fieldcat-tabname       = 'GT_DASH'.
    ls_fieldcat-fieldname     = 'CRSNT'.
    ls_fieldcat-ref_tabname   = 'ZHR_REFOG_DASH'.
    ls_fieldcat-outputlen     = '15'.
    ls_fieldcat-do_sum        = 'X'.
    ls_fieldcat-hotspot       = 'X'.
    ls_fieldcat-col_pos       = 2.
    APPEND ls_fieldcat TO lt_alv_fieldcat.
    CLEAR ls_fieldcat.
    ls_fieldcat-tabname       = 'GT_DASH'.
    ls_fieldcat-fieldname     = 'CRUPD'.
    ls_fieldcat-ref_tabname   = 'ZHR_REFOG_DASH'.
    ls_fieldcat-outputlen     = '15'.
    ls_fieldcat-do_sum        = 'X'.
    ls_fieldcat-hotspot       = 'X'.
    ls_fieldcat-col_pos       = 3.
    APPEND ls_fieldcat TO lt_alv_fieldcat.
    CLEAR ls_fieldcat.
    ls_fieldcat-tabname       = 'GT_DASH'.
    ls_fieldcat-fieldname     = 'CRREJ'.
    ls_fieldcat-ref_tabname   = 'ZHR_REFOG_DASH'.
    ls_fieldcat-outputlen     = '15'.
    ls_fieldcat-do_sum        = 'X'.
    ls_fieldcat-hotspot       = 'X'.
    ls_fieldcat-col_pos       = 4.
    APPEND ls_fieldcat TO lt_alv_fieldcat.
" ....
    ls_alv_layout-zebra = 'X'.
    l_repid = sy-repid.
    CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
      EXPORTING
        is_layout               = ls_alv_layout
        i_bypassing_buffer      = 'X'
        i_callback_program      = l_repid
        i_callback_user_command = 'HANDLE_UCOMM'
        it_fieldcat             = lt_alv_fieldcat
        it_excluding            = lt_excluding
        it_events               = lt_evt
      TABLES
        t_outtab                = gt_dash.
ENDMETHOD.

With this form for TOP-OF-PAGE:

*&---------------------------------------------------------------------*
*&      Form  top_of_page
*&---------------------------------------------------------------------*
FORM top_of_page .                                          "#EC CALLED
  CHECK sy-pfkey <> 'INLI_DET'.   "Do not display header in detail list
  ULINE AT 13(158) .
  FORMAT COLOR 7 .
  WRITE: /(12) '' COLOR OFF,
          13 sy-vline,
          32 'CREPER', 61 sy-vline,
          80 'MODPER', 109 sy-vline,
         128 'CLOPER', 157 sy-vline.
ENDFORM.                    "top_of_page

For this kind of result:

Cheers,

Manu.