Skip to Content

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

/wp-content/uploads/2013/08/sm30_265731.png

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 mytablemyfield1,

                 so_selop2 FOR mytablemyfield2.

PARAMETERS: p_param1 TYPE z_mytablemyfield3,

             p_param2 TYPE z_mytablemyfield4.

sel_screen.PNG

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 ‘VIEW_RANGETAB_TO_SELLIST’ and ‘VIEW_MAINTENANCE_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.

      selectionviewfield = &1.

      selectionvalue = &2.

      selectionand_or = ‘AND’.

      selectionoperator = ‘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 sysubrc = 1.

    MESSAGE ID symsgid TYPE symsgty NUMBER symsgno

               WITH symsgv1 symsgv2 symsgv3 symsgv4.

  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.

tab_maint.PNG

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

18 Comments
You must be Logged on to comment or reply to a post.