Standard ALV Functionalities
One of the advantages presented by ALV reports is the inclusion of numerous standard functionalities. These functionalities come built-in and don't require explicit coding; they are ready for users to utilize seamlessly with ALV reports.
Upon executing an ALV report, users can access standard functionalities from both the transaction menu and the transaction toolbar. Here, we'll explore some of the crucial functionalities:
- Details: Selecting a record and clicking the details icon opens a dialog displaying the contents of the selected record.
- Ascending Order: Clicking the ascending sort icon on an ALV column sorts the records in ascending order based on that field.
- Descending Order: Clicking the descending sort icon on an ALV column sorts the records in descending order based on that field.
- Set Filters: Clicking the set filters icon on an ALV column allows users to filter records based on that field.
- Print Preview: Clicking the preview icon displays the ALV report in ALV List format.
- Microsoft Excel(Spreadsheet): Clicking the Microsoft Excel icon opens the report in Microsoft Excel.
- Word Processing: Clicking the text processing icon displays a dialog where users can choose to create a document, consider colors, and launch Microsoft Word.
- Local File: Clicking the local file icon prompts a window to save the report in various formats, including conversation, spreadsheet, RTF, HTML, or clipboard.
- Mail Recipient: Clicking the mail recipient icon displays a screen to compose an email, add recipients, attach files, and send the email.
- Graphic Function: Clicking the graphical function icon displays a graph if applicable to the information.
- Change Layout: Clicking the modify layout icon allows users to adjust various layout aspects. For instance, within the Select Columns tab, unwanted columns or fields can be removed.
Excluding ALV Functionalities
To restrict certain standard functionalities of the ALV report for security, follow these steps:
- Declare the internal table it_exclusions, type slis_t_extab, and the structure wa_exclusions, type slis_extab.
DATA: it_exclusions TYPE slis_t_extab,
wa_exclusions TYPE slis_extab.
- Inside the subroutine execute_alv, declare the new subroutine exclude_functionalities.
PERFORM exclude_functionalities.
- In this subroutine, add a record to the it_exclusions table for each functionality to be excluded.
*---------------------------------------------------------------------*
* Form: EXCLUDE_FUNCTIONALITIES
* Description: Excludes specific functionalities from the ALV report.
*---------------------------------------------------------------------*
FORM exclude_functionalities.
REFRESH it_exclusions.
CLEAR wa_exclusions.
wa_exclusions-fcode = '%SL'.
APPEND wa_exclusions TO it_exclusions.
ENDFORM.
Note: To determine the code for each functionality, position the cursor over the functionality and press F1. The corresponding code, in this case, was %SL.
- In the function module, add the exclusion internal table as an input parameter.
IF p_grid = 'X'.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
i_callback_program = v_repid
it_fieldcat = it_catalog[]
it_excluding = it_exclusions
is_layout = wa_layout
TABLES
t_outtab = it_users.
ELSEIF p_list = 'X'.
CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'
EXPORTING
i_callback_program = v_repid
it_fieldcat = it_catalog[]
it_excluding = it_exclusions
is_layout = wa_layout
TABLES
t_outtab = it_users.
ENDIF.