메뉴 건너뛰기

SAP 한국 커뮤니티



REPORT z_alv_list_block

노름마치 2007.11.05 12:48 조회 수 : 3214

REPORT z_alv_list_block.
*---------------------------------------------------------------------*
* Demo of FM ALV_BLOCK_LIST_APPEND                                    *
*---------------------------------------------------------------------*
* Author : Michel PIOUD                                               *
* Email : mpioud@yahoo.fr  HomePage : http://www.geocities.com/mpioud *
*---------------------------------------------------------------------*
TYPE-POOLS: slis.                      " ALV Global types


SELECTION-SCREEN :
  SKIP, BEGIN OF LINE,COMMENT 5(27) v_1 FOR FIELD p_max.    "#EC NEEDED
PARAMETERS p_max(2) TYPE n DEFAULT '02' OBLIGATORY.
SELECTION-SCREEN END OF LINE.


DATA:
* 1st Table
  BEGIN OF gt_kna1 OCCURS 0,           " Data displayed
    kunnr LIKE kna1-kunnr,             " Customer number
    ernam LIKE kna1-ernam,             " Name of Person who Created
    erdat LIKE kna1-erdat,             " Creation date
    name1 LIKE kna1-name1,             " Name 1
  END OF gt_kna1,


* 2nd Table
  BEGIN OF gt_mara OCCURS 0,
    ernam LIKE mara-ernam,             " Name of Person who Created
    matnr LIKE mara-matnr,             " Material number
    ersda LIKE mara-ersda,             " Creation date
    brgew LIKE mara-brgew,             " Gross weight
  END OF gt_mara,


* 3rd Table
  BEGIN OF gt_vbak OCCURS 0,
    vkorg LIKE vbak-vkorg,             " Sales organization
    kunnr LIKE vbak-kunnr,             " Sold-to party
    vbeln LIKE vbak-vbeln,             " Sales document
    netwr LIKE vbak-netwr,             " Net Value of the Sales Order
    waerk LIKE vbak-waerk,             " SD document currency
  END OF gt_vbak.


*---------------------------------------------------------------------*
INITIALIZATION.


  v_1 = 'Maximum of records to read'.


*---------------------------------------------------------------------*
START-OF-SELECTION.


* Read data
  SELECT * FROM kna1
             UP TO p_max ROWS
           INTO CORRESPONDING FIELDS OF TABLE gt_kna1.


  SELECT * FROM mara
             UP TO p_max ROWS
           INTO CORRESPONDING FIELDS OF TABLE gt_mara.


  SELECT * FROM vbak
             UP TO p_max ROWS
           INTO CORRESPONDING FIELDS OF TABLE gt_vbak.


  CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT'
       EXPORTING
            i_callback_program      = sy-cprog
            i_callback_user_command = 'USER_COMMAND'.


  PERFORM list_append TABLES gt_kna1
                       USING '1'
                             'GT_KNA1'.


  PERFORM list_append TABLES gt_mara
                       USING '2'
                             'GT_MARA'.


  PERFORM list_append TABLES gt_vbak
                      USING '3'
                            'GT_VBAK'.


  PERFORM f_list_display.


*---------------------------------------------------------------------*
*       FORM USER_COMMAND                                             *
*---------------------------------------------------------------------*
FORM user_command USING i_ucomm     LIKE sy-ucomm
                        is_selfield TYPE slis_selfield.     "#EC CALLED


  CASE i_ucomm.
    WHEN '&IC1'.                       " Pick
      CASE is_selfield-tabname.
        WHEN 'GT_MARA'.
        WHEN 'GT_KNA1'.
        WHEN 'GT_VBAK'.
          READ TABLE gt_vbak INDEX is_selfield-tabindex.
          IF sy-subrc EQ 0.
*           Sales order number
            SET PARAMETER ID 'AUN' FIELD gt_vbak-vbeln.
*           Display Sales Order
            CALL TRANSACTION 'VA03' AND SKIP FIRST SCREEN.
          ENDIF.
      ENDCASE.
  ENDCASE.


ENDFORM.                               " USER_COMMAND
*---------------------------------------------------------------------*
*       Form  list_append
*---------------------------------------------------------------------*
FORM list_append TABLES ut_table
                 USING  u_no      TYPE char1
                        u_tabname TYPE slis_tabname.


* Macro definition
  DEFINE m_fieldcat.
    ls_fieldcat-fieldname = &1.
    ls_fieldcat-ref_tabname = &2.
    append ls_fieldcat to lt_fieldcat.
  END-OF-DEFINITION.


  DEFINE m_sort.
    ls_sort-fieldname = &1.
    ls_sort-up        = 'X'.
    append ls_sort to lt_sort.
  END-OF-DEFINITION.


  DATA :
    ls_fieldcat TYPE slis_fieldcat_alv,
    lt_fieldcat TYPE slis_t_fieldcat_alv, " Field catalog
    ls_sort     TYPE slis_sortinfo_alv,
    lt_sort     TYPE slis_t_sortinfo_alv. " Sort table


  DATA:
    lt_events TYPE slis_t_event,
    ls_event  TYPE slis_alv_event,
    ls_layout TYPE slis_layout_alv.


  ls_layout-group_change_edit = 'X'.
  ls_layout-colwidth_optimize = 'X'.
  ls_layout-zebra             = 'X'.
  ls_layout-cell_merge        = 'X'.
  ls_layout-detail_popup      = 'X'.
  ls_layout-get_selinfos      = 'X'.
  ls_layout-max_linesize      = '200'.


  CASE u_no.
    WHEN '1'.
* Build field catalog and sort table
      m_fieldcat  'KUNNR' 'KNA1'.
      m_fieldcat  'ERNAM' 'KNA1'.
      m_fieldcat  'ERDAT' 'KNA1'.
      m_fieldcat  'NAME1' 'KNA1'.
      m_sort  'KUNNR'.
    WHEN '2'.


      m_fieldcat 'MATNR' 'MARA'.
      m_fieldcat 'ERNAM' 'MARA'.
      m_fieldcat 'ERSDA' 'MARA'.
      m_fieldcat 'BRGEW' 'MARA'.
      m_sort 'MATNR'.
    WHEN '3'.
      m_fieldcat 'VBELN' 'VBAK'.
      m_fieldcat 'VKORG' 'VBAK'.
      m_fieldcat 'KUNNR' 'VBAK'.
      m_fieldcat 'NETWR' 'VBAK'.
      m_fieldcat 'WAERK' 'VBAK'.
      m_sort 'VBELN'.
  ENDCASE.


  IF u_no CA '13'.
    MOVE        'TOP_OF_PAGE'        TO ls_event-name.
    CONCATENATE 'TOP_OF_PAGE' u_no INTO ls_event-form.
    APPEND ls_event TO lt_events.
  ELSE.
    MOVE        'TOP_OF_LIST'        TO ls_event-name.
    CONCATENATE 'TOP_OF_LIST' u_no INTO ls_event-form.
    APPEND ls_event TO lt_events.
  ENDIF.


  CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'
       EXPORTING
            it_fieldcat                = lt_fieldcat
            is_layout                  = ls_layout
            i_tabname                  = u_tabname
            it_events                  = lt_events
            it_sort                    = lt_sort
*           i_text                     =
       TABLES
            t_outtab                   = ut_table
       EXCEPTIONS
            program_error              = 1
            maximum_of_appends_reached = 2
            OTHERS                     = 3.
  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
           WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.


ENDFORM.                               " LIST_APPEND
*---------------------------------------------------------------------*
*       Form  f_list_display
*---------------------------------------------------------------------*
FORM f_list_display.


  DATA ls_print TYPE slis_print_alv.


  ls_print-no_print_selinfos  = 'X'.   " Display no selection infos
  ls_print-no_print_listinfos = 'X'.   " Display no listinfos
  ls_print-reserve_lines      = 2.     " Lines reserved for end of page


  CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY'
       EXPORTING
            i_interface_check = ' '
            is_print          = ls_print
       EXCEPTIONS
            program_error     = 1
            OTHERS            = 2.


  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
           WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.


ENDFORM.                               " F_LIST_DISPLAY
*---------------------------------------------------------------------*
*       FORM top_of_page1                                             *
*---------------------------------------------------------------------*
FORM top_of_page1.                                          "#EC CALLED


  PERFORM top_of_page.


ENDFORM.
*---------------------------------------------------------------------*
*       FORM top_of_page3                                             *
*---------------------------------------------------------------------*
FORM top_of_page3.                                          "#EC CALLED


  PERFORM top_of_page.


ENDFORM.
*---------------------------------------------------------------------*
*       FORM top_of_page                                              *
*---------------------------------------------------------------------*
FORM top_of_page.


  ULINE.
  WRITE : sy-uname, sy-title(56) CENTERED, sy-datum.
  ULINE.


ENDFORM.
*---------------------------------------------------------------------*
*       FORM top_of_list2                                             *
*---------------------------------------------------------------------*
FORM top_of_list2.                                          "#EC CALLED


  WRITE 'TOP OF LIST2'.


ENDFORM.
************** END OF PROGRAM Z_ALV_LIST_BLOCK ***********************


번호 제목 글쓴이 날짜 조회 수
107 Dynamic Select 소스 [5] 떡밥 2011.06.03 17773
106 스크린에서 버튼을 tree 처럼 만들기. [32] file Jenny 2011.08.11 17657
105 Mass Download [5] file 소주와 막걸리 2009.11.13 17363
104 셀(cell) 레벨의 ALV EDIT(편집) 가능 소스 [5] sapjoy 2008.09.25 17266
103 통화단위, krw, usd 일반 필드에 변환시 로직(소수점, 자리수) [4] sapjoy 2011.07.19 15563
102 REPORT z_alv_list_block_2 [1] 노름마치 2007.11.05 15184
101 4.6c 에서 Xml 파일을 읽어오는 로직 예제 입니다. [2] woong 2009.05.11 14808
100 금액을 한글로(수표)표기 [17] file STARFISH 2009.03.17 14646
99 인터널 테이블을 사용한 구구단 출력 두가지 입니다 - WRITE, ALV 이용 [1] kofnhuge 2012.10.10 14022
98 Text(Description) 빠르게 반영하기,,, 속도개선을 위주로 [5] file 노름마치 2010.12.07 13909
97 [onepaper] 참고자료 Archiving 세팅에 필요한 파일소스입니다. [7] file 원니컴 2011.03.22 13801
96 Syntax Checker [4] file 소주와 막걸리 2009.11.13 13765
95 ALV Row Color 지정하는 소스. [3] 나침반친구 2007.05.28 12864
94 금액을 영문으로 [4] file 쥬앙 2009.04.06 12366
93 Transport Trace [4] file 소주와 막걸리 2009.11.13 12143
92 멀 어떻게 해야 하는건질 몰라 질문 드립니다 [5] 쏠라맨 2012.10.12 11665
91 [Module pool] Container에 webpage 넣기. [2] 냥냥 2013.03.19 11198
90 nugg 프로그램을 sap 에 생성하기.. [3] file MadMax 2012.10.11 10829
89 Select-Options 의 Extension 에 제한을 주는 방법 [5] icarus 2007.11.15 10828
88 Split 의 사용 [1] 양키(이경환) 2014.02.05 10724