Show TOC

Excluding Tables/Views from ComparisonLocate this document in the navigation structure

Prerequisites

You need the authorization s_tabu_cli to edit and activate the exclusion table.

You are in the initial screen of the Customizing Cross-System Viewer or the Individual Comparison.

Context

You make comparisons with the Customizing Cross-System Viewer or individually. These comparisons contain tables, views or table/view fields which you want to exclude from future comparisons. If you exclude a field, view or table from a comparison, this applies to all clients in your system.

Caution

You can only put customizing objects of type table, table with text table (S) and view (V) in the exclusion table. If you want to exclude view clusters or objects of type L from comparisons, you must resolve them into their subobjects (tables, views) and put those in the exclusion table.

Procedure


  1. Choose Start of the navigation path Extras Next navigation step Maintain Exclusion Table End of the navigation path in the menu.

    The system displays the exclusion table.

  2. Switch to the change mode by choosing Display/Change.

  3. Choose the New Entries button.

    The system puts ready for entry rows in the table.

  4. Enter the name of the view or table under View Name.

  5. Specify under Type whether you want to exclude a view, a table, or a table with text table from the comparison.

  6. If you only want to exclude one field from the view or table from the comparison, enter the field name. You cannot exclude key fields from the comparison, because a comparison can only be based on keys.

  7. Specify an exclusion type:

    • Do not compare View/Table: The view or table is no longer included in the following comparisons.

    • Compare View at Table Level: A view is resolved into its underlying tables, and these tables are compared completely in the following comparisons (that is, fields in the table which are not in the view are included. The selection conditions defined in the view are not applied).

    • Do not compare View/Table Field: The view or table field that you have specified in the Field Name column is not included in the following comparisons.

  8. Save your entries.

  9. Activate the exclusion table.

Results

The views, tables and fields entered in the exclusion table are not included in the following comparisons. Tables and views which are excluded from a comparison are flagged as excluded in the result of a comparison; fields which are excluded from a comparison do not appear in the result of a comparison.

You can now:

  • delete entries from the exclusion table

  • deactivate the exclusion table if you do not want to use it any more, and reactivate it as required.