Show TOC

 Functions for Editing Views in the DatabaseLocate this document in the navigation structure

Use

Basic Functions

The database utility provides the Create database view, Delete database viewand Activate and adjust databasefunctions for editing database views . To execute one of these functions, go to the Utility for Database Viewsscreen, choose a processing type and press the corresponding button.

  • Create database view:
    Caution

    The runtime object must already exist.

    When you define a database view in the ABAP Dictionary, the system creates it physically in the database.

  • Delete database view:

    The database view is deleted from the database, but the runtime object remains.

  • Activate and adjust database:

    The view is deleted from the database. The revised version of the view is activated and the system creates the new version in the database.

Additional Functions

The database utility also offers a number of check functions for database views:

  • Check consistency:

    You can compare the view definition in the database with the runtime object of the view by choosing Extras → Database object → Check. You can compare the runtime object of the view with the information given in the ABAP Dictionary maintenance screen by choosing Extras → Runtime object → Check. Both definitions are displayed. The differences found are highlighted. In both cases you can choose either a delta (only differences) or full (all information) display of the check results.

  • Display the view definition in the database:

    To list the definition of the view in the database, choose Extras → Database object → Display.

  • Display the Runtime Object:

    To list the information in the runtime object for the view, choose Extras → Runtime object → Display. To display more information about interpreting the displayed data, choose  with the quick info text Information.

See also:

Views