Show TOC

 Creating Maintenance ViewsLocate this document in the navigation structure

Procedure
  1. Enter an explanatory short text in the Short text field.

    You can find the view at a later time using this short text, for example.

  2. In column Tables on the Table/Join conditions tab page, enter the primary table of the view.
    Note

    You can include in the maintenance view only those tables that are linked with the primary table (indirectly) with a foreign key.

  3. If required, include more tables in the view.

    In a maintenance view you can insert only tables that are linked to one another with foreign keys.

    1. In column Tables on the Table/Join conditions tab page, select the primary table and choose Relationships.

      All existing foreign key relationships of the primary table are displayed.

    2. Select the required foreign key and choose Copy.

      The secondary table used in such a foreign key is included in the view. The system displays the join conditions derived from the foreign keys. For more information, see Foreign Key Relationship and Join Condition .

    You can also (optionally) insert tables that are linked by foreign key with one of the secondary tables that was already inserted. To do this, proceed as follows:

    1. In column Tables on the Table/Join conditions tab page, select the secondary table and choose Relationships.

      All existing foreign key relationships of the secondary table are displayed.

    2. Select the required foreign key by selecting the corresponding indicator and choosing Copy.

      The system displays the join conditions derived from the foreign keys.

      Note

      For maintenance and help views, there are certain restrictions on the foreign keys with which the tables can be included in the view (see Restrictions for Maintenance and Help Views ). The system displays the foreign keys that violate these conditions at the end of the list under the header Relationships with unsuitable cardinality.

  4. On the View fields tab page, select the fields that you want to copy to the view.
    1. Choose Table fields.

      All the tables contained in the view are displayed in a dialog box.

    2. Select a table.

      The fields of the table are now displayed in a dialog box.

    3. To copy fields, select them with the indicator in the first column and choose Copy.
      Caution

      All key fields of the primary table must be included in a maintenance view.

      All key fields of secondary tables that are not involved in the foreign key (that is, which are not linked via a join condition to a key field already included in the view) must be included in the view.

      This ensures that the records inserted with a maintenance view can be written correctly in the tables contained in the view.

  5. On the Selection conditions tab page, you can (optionally) formulate restrictions for the data records that can be displayed with the view. For more information, see Maintaining Selection Conditions for Views .

    The selection conditions define the data records that can be selected with the view.

  6. On the Maintenance status tab page, define the maintenance status of the view.

    The maintenance status defines how you can access the view data with the standard maintenance transaction (transaction code SM30).

  7. Choose  with the quick info text Save.

    You are asked to assign the view a package. You can change this package later by choosing Goto → Object Directory Entry

  8. Choose  with the quick info text Activate.

    At activation, a log is written. It can be displayed with Utilities → Activation log. If errors or warnings occur when the view is activated, the system automatically displays the activation log.

  9. Go to (optionally) Environment → Tab. maint. generator (transaction code SE54)

    From the view definition, you can generate maintenance modules and maintenance interfaces that distribute the data entered with the view to the base tables of the view. For more information, see Creating a Maintenance Dialog .

Additional Options

  • Recording documentation:

    You can create information about using the view by choosing Goto → Documentation. This documentation is output when you print the view, for example.

  • Changing the data element of a view field:

    Select the indicator in column Mod (modification) for the view field. The Data element field is now ready for input. You can enter a data element that refers to the same domain as the data element of the assigned table field here. Cancel the Mod flag if you want to use the data element of the assigned table field again.

  • Enter the delivery class of the view:

    On the Maintenance status tab page, select the delivery class of the maintenance view. If you assign the delivery class G or E to the view, you must also maintain a customer namespace (key block) for the view entries. To maintain the customer namespace, choose Customer Namespace Definition.

  • Entering the maintenance attributes of the view field:

    On the View fields tab page you can define the Maintenance Attributes of the view field in column P.

  • Check functions:

    By choosing Utilities → Runtime object → Check you can determine whether the definition of the view in the ABAP Dictionary maintenance screen is identical to the definitions in the runtime object of the view. By choosing Utilities → Runtime object → Display you can display the runtime object of the view.

See also:

Maintenance Views

BC - Generate Table Maintenance Dialog