Add a Selection Screen to a Table Maintenance Dialog

Originally posted at https://blogs.sap.com/2013/08/22/add-a-selection-screen-to-a-table-maintenance-dialog/.

When end users will maintain a z-table with 100+ rows, it helps to be able to restrict the selection by any number of selection criteria. This document attempts to define a “best practice” method for calling a table maintenance dialog from a selection screen.

Current Table Maintenance

The standard way to show a table maintenance dialog is via SM30, Call View Maintenance –

– or a custom parameter transaction that calls SM30 for a specific table, with parameters VIEWNAME and UPDATE = ‘X’.

Neither of these provide an initial selection screen. Entries can be restricted by checking the “Enter conditions” radiobutton, but users are more familiar with selection screens than with the dialog box that pops up. Therefore it is good UI to use a selection screen instead of the “Enter conditions” radiobutton.

Example Selection Screen Definition

In this example, an executable report has been created with selection screen.

REPORT  z_maintain_mytable.

DATA mytable    TYPE z_mytable.
DATA selections TYPE TABLE OF vimsellist.
DATA selection  TYPE vimsellist.

SELECT-OPTIONS: so_selop1 FOR mytable–myfield1,
                 so_selop2 FOR mytable–myfield2.

PARAMETERS: p_param1 TYPE z_mytable–myfield3,
            p_param2 TYPE z_mytable–myfield4.

Calling Function Modules

When the user clicks execute, the program needs to read their selections and call the table maintenance dialog. The following code shows how this is easily done by using function modules ‘VIEWRANGETABTOSELLIST’ and ‘VIEWMAINTENANCE_CALL’.

START-OF-SELECTION.

  DEFINE addsel.
    CALL FUNCTION ‘VIEW_RANGETAB_TO_SELLIST’
      EXPORTING
        fieldname          = &1
        append_conjunction = ‘AND’
      TABLES
        sellist            = selections
        rangetab           = &2[].
  END-OF-DEFINITION.

  DEFINE addparam.
    IF &2 IS NOT INITIAL.
      CLEAR selection.
      selection–viewfield = &1.
      selection–value = &2.
      selection–and_or = ‘AND’.
      selection–operator = ‘EQ’.
      APPEND selection TO selections.
    ENDIF.
  END-OF-DEFINITION.

  add_sel ‘MYFIELD1’ so_selop1.
  add_sel ‘MYFIELD2’ so_selop2.
  add_par ‘MYFIELD3′ p_param1.
  add_par ‘MYFIELD4′ p_param2.

  CALL FUNCTION ‘VIEW_MAINTENANCE_CALL’
    EXPORTING
      action                = ‘U’ “for Update
      view_name             = ‘Z_MYTABLE’
      complex_selconds_used = ‘X’
    TABLES
      dba_sellist           = selections
    EXCEPTIONS
      OTHERS                = 1.

  IF sy–subrc = 1.
    MESSAGE ID sy–msgid TYPE sy–msgty NUMBER sy–msgno
               WITH sy–msgv1 sy–msgv2 sy–msgv3 sy–msgv4.
  ENDIF.

Horray! That is all. In only 46 lines (plus two for every select-option or parameter), this will bring the user to from the selection-screen to the table maintenance screen.

This is a collaborative document. If there are better ways of achieving this functionality don’t hesitate to chime in and contribute!