Please enable JavaScript.

Coggle requires JavaScript to display documents.

ALV Reports (15.1 Standard ALV Reports Using the Reuse Library (15.1.1…

- - - - data from various database tables can be consolidated into a single internal table and passed to the ALV function module as report output.
    - - The function module help documentation in Function Builder (Transaction SE37) for each function module contains detailed information about each parameter.
      - REPORT ZDEMO_SIMPLE_REPORT. DATA it_sflight TYPE STANDARD TABLE OF sflight. PARAMETERS p_carrid TYPE s_carr_id. SELECT * FROM sflight INTO TABLE it_sflight WHERE carrid EQ p_carrid. CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING I_STRUCTURE_NAME = 'SFLIGHT' TABLES t_outtab = it_sflight EXCEPTIONS PROGRAM_ERROR = 1 OTHERS = 2 IF sy-subrc <> 0. * Implement suitable error handling here ENDIF.
        
        pass the structure name from ABAP Data Dictionary to the I_STRUCTURE_NAME formal parameter of the REUSE_ALV_LIST_DISPLAY function module, which uses this structure name to create the output layout
        
        The data that should be displayed in the output is selected into the internal table IT_SFLIGHT and passed to the T_OUTTAB formal parameter.
      - The grid display ALV is similar to the list display ALV for all practical purposes, but the grid display is part of the Control Framework.
        
        The Control Framework uses JavaBeans or ActiveX controls in the presentation layer and provides certain additional features, such as grid title, TOP-OF-PAGE, removing vertical and horizontal lines, making the ALV editable, and so on.
        
        CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING I_STRUCTURE_NAME = 'SFLIGHT' I_GRID_TITLE = text-001 TABLES t_outtab = it_sflight EXCEPTIONS PROGRAM_ERROR = 1 OTHERS = 2.
        
        print only certain fields of a table or fields from different tables in the output
        
        create a field catalog and pass it to the function module using the IT_FIELDCAT formal parameter
        
        The field catalog should be an internal table in which information about each output field is maintained.
        
        This internal table should be of type SLIS_T_FELDCAT_ALV, which belongs to the type group SLIS.
        
        At a minimum, you shold fill the COL_POS, TABNAME, FIELDNAME, and SELTEXT (long, medium, or short) components
        
        4 more items...
        
        create a structure in ABAP Data Dictionary consisting of the output fields and pass it to the I_STRUCTURE_NAME formal parameter
        
        The layout can be handled by passing a structure of type SLIS_LAYOUT_ALV to the IS_LAYOUT formal parameter.
        
        control the output layout, such as making the fields editable
        
        FORM show_output. DATA layout TYPE SLIS_LAYOUT_ALV. layout-edit = 'X'. CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING I_GRID_TITLE = 'ALF Grid Display' IS_LAYOUT = layout IT_FIELDCAT = it_fieldcat TABLES t_outtab = it_sflight EXCEPTIONS PROGRAM_ERROR = 1 OTHERS = 2
  - - - REUSE_ALV_BLOCK_LIST_INIT
        
        to initialize the block list and set the SAP GUI status
      - REUSE_ALV_BLOCK_LIST_APPEND
        
        to append the simple list in block mode
      - REUSE_ALV_BLOCK_LIST_DISPLAY
        
        to display the block list
  - - - This function module requires you to pass the header and item tables along with the key information of the tables.
        
        The key information is used to identify the related records in the header and item tables.
- - - - When you pass your custom SAP GUI status to ALV, it will completely replace the default ALV SAP GUI status.
      - If you want to use the standard features provided by the default ALV SAP GUI status and supplement it with your custom buttons, then we recommend copying the standard ALV SAP GUI status and modifying it.
        
        The SAPLSLVC_FULLSCREEN ALV function group contains the STANDARD_FULLSCREEN SAP GUI STATUS, which can be copied to your program and modified.
    - - The subroutine name should be maintained in the program with one formal parameter of type SLIS_T_EXTAB.
  - - - FORM user_command USING r_ucomm LIKE sy-ucomm rs_selffield TYPE slis_selffield. CASE r_ucomm. WHEN 'PDF'. * write appropriate logic. WHEN '&IC1'. * write appropriate logic. ENDCASE. ENDFORM.
        
        The standard function code '&IC1' is passed to the R_UCOMM formal parameter if the user double-clicks the row.
        
        The rs_selffield-fieldname and rs_selffield-value fields will contain the column name in which the user double-clicked the displayed output and the value in the cell, respectively.
  - - - Within this subroutine, the REUSE_ALV_COMMENTARY_WRITE function module is calle to print TOP-OF-PAGE.
- - - - initiate the ALV grid object that's referenced to the CL_GUI_ALV_GRID class
- - - - output table
        
        Prepare an internal table with the output data that should be displayed as an ALV output and pass it to the ALV function module.
        
        The ALV function module reads this output table to display it as an ALV output.
      - field catelog
        
        Prepare another internal table to define specifications for how the output data supplied to the ALV function module should be displayed. These specifications about the output data are called the field catalog.
        
        The field catalog consists of different specifications for the output fields, such as column name, length, data format, and so on.
        
        An ABAP Data Dictionary structure can also be passed to ALV instead of an internal table to describe the structure of the output data.
  - - - The REUSE_ALV_LIST_DISPLAY function module is used to display a simple report as list output.
    - - The REUSE_ALV_GRID_DISPLAY function module is used to display a simple report as a two-dimensional grid output.
    - - show multiple report outputs on a single screen
      - The function modules used for block displays are REUSE_ALV_BLOCK_LIST_INIT, REUSE_ALV_BLOCK_LIST_APPEND, and REUSE_ALV_BLOCK_LIST_DISPLAY
    - - This display is useful hen you want to show header and line items in the output, such as a sales order header and its item details.
      - The REUSE_ALV_HIERSEQ_LIST_DISPLAY function module is used for this purpose, which allows you to pass the header and item tables.
        
        The header and item tables should have a common key.

REPORT ZDEMO_BLOCK_REPORT.
DATA: it_sflight TYPE STANDARD TABLE OF sflight,
      it_spfli TYPE STANDARD TABLE OF spfli,
      it_fcat_sflight TYPE SLIS_T_FIELDCAT_ALV,
      it_fcat_spfli TYPE SLIS_T_FIELDCAT_ALV,
      it_events TYPE SLIS_T_EVENT.

PARAMETERS p_carrid TYPE s_carr_id.
START OF SELECTION.
PERFORM get_data.
END-OF-SELECTION.
PERFORM field_catalog.
PERFORM show_output.

FORM get_data.
SELECT * FROM sflight INTO TABLE it_sflight WHERE carrid EQ p_carrid.
SELECT * FROM spfli INTO TABLE it_spfli WHERE carrid EQ p_carrid.
ENDFORM.

FORM field_catalog.
CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
  EXPORTING
    I_STRUCTURE_NAME = 'SPFLI'
  CHANGING
    ct_fieldcat = it_fcat_spfli
  EXCEPTIONS
    INCONSISTENT_INTERFACE = 1
    PROGRAM_ERROR = 2
    OTHERS = 3
.
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.

CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
  EXPORTING
    I_STRUCTURE_NAME = 'SFLIGHT'
  CHANGING
    ct_fieldcat = it_fcat_sflight
  EXCEPTIONS
    INCONSISTENT_INTERFACE = 1
    PROGRAM_ERROR = 2
    OTHERS = 3
.
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.
ENDFORM

FORM show_output.
  DATA layout TYPE SLIS_LAYOUT_ALV.
  layout-zebra = 'X'.
  CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT'
    EXPORTING
       i_callback_program = 'ZDEMO_BLOCK_REPORT'
   CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'
     EXPORTING
       is_layout = layout
       it_fieldcat = it_fcat_spfli
       i_tabname = 'IT_SPFLI'
       it_events = it_events
     TABLES
       t_outtab = it_spfli
     EXCEPTIONS
       PROGRAM_ERROR = 1
       MAXIMUM_OF_APPENDS_REACHED = 2
       OTHERS = 3
.
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.

CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND'
  EXPORTING
    is_layout = layout
    it_fieldcat = it_fcat_sflight
    i_tabname = 'IT_SFLIGHT'
    it_events = it_events
  TABLES
    t_outtab = it_sflight
  EXCEPTIONS
    PROGRAM_ERROR = 1
    MAXIMUM_OF_APPENDS_REACHED = 2
    OTHERS = 3
.
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.

CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY'
  EXCEPTIONS
    PROGRAM_ERROR = 1
    OTHERS = 2
.
IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.
ENDFORM.