Creation of Simple SAP ALV Report

An ALV report is created using the standard function modules provided by SAP

1. An ALV report can be created using the following steps.
2. Include SLIS type pool – SLIS type pool contains all the data types required by ALV function modules.
3. Data retrieval – Code the logic to fetch the data from database table into an Internal Table.
4. Build Field Catalog – Add the columns into an internal that you want to display in the ALV output list.
5. Pass the data table and field catalog table to ALV function module

Sample Program - 

TYPE-POOLS: slis.  " SLIS contains all the ALV data types

*&---------------------------------------------------------------------*

*& Data Declaration

*&---------------------------------------------------------------------*

DATA: it_sbook1     TYPE TABLE OF sbook.

DATA: it_fieldcat1  TYPE slis_t_fieldcat_alv,

      wa_fieldcat1  TYPE slis_fieldcat_alv.

*&---------------------------------------------------------------------*

*& START-OF-SELECTION

*&---------------------------------------------------------------------*

START-OF-SELECTION.

*Fetch data from the database

  SELECT * FROM sbook INTO TABLE it_sbook1.

*Build field catalog

  wa_fieldcat1-fieldname  = 'CARRID'.    " Fieldname in the data table

  wa_fieldcat1-seltext_m  = 'Airline'.   " Column description in the output

  APPEND wa_fieldcat1 TO it_fieldcat1.

  wa_fieldcat1-fieldname  = 'CONNID'.

  wa_fieldcat1-seltext_m  = 'Con. No.'.

  APPEND wa_fieldcat1 TO it_fieldcat1.

  wa_fieldcat1-fieldname  = 'FLDATE'.

  wa_fieldcat1-seltext_m  = 'Date'.

  APPEND wa_fieldcat1TO it_fieldcat1.

  wa_fieldcat1-fieldname  = 'BOOKID'.

  wa_fieldcat1-seltext_m  = 'Book. ID'.

  APPEND wa_fieldcat1TO it_fieldcat1.

  wa_fieldcat1-fieldname  = 'PASSNAME'.

  wa_fieldcat1-seltext_m  = 'Passenger Name'.

  APPEND wa_fieldcat1TO it_fieldcat1.

*Pass data and field catalog to ALV function module to display ALV list

  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

    EXPORTING

      it_fieldcat   = it_fieldcat1

    TABLES

      t_outtab      = it_sbook1

    EXCEPTIONS

      program_error = 1

      OTHERS        = 2.