Monitoring and Results Display

NOTE If you jump to the monitoring report immediately after starting the analysis, the worklist might not have been established yet. In this case, you will receive the error message Invalid ID or table workload not prepared yet. Try again after a while.

Proceed as follows to view and monitor the results of the comparison:

  1. Start transaction /N/SNP/CW_TAB_MONITOR.
  • The Show table comparison report opens.
  1. Select a run ID.
  2. Optional: Select tables.
  3. Optional: Enable the table status you want to display.
  4. NOTE All options are enabled by default.
  5. Optional: Enable the Monitor option to directly display the analysis result. Enable the Report option to save the overview data of the analysis as an HTML file or as a JSON file..
  1. Click Execute.
  • If you select the Monitor option, the window Results: <run ID> opens. The list displays the current worklist and the status of the analysis.

Functions in the toolbar:

ButtonFunction
/ Sort in ascending/descending orderSort table in ascending or descending order
Set filterDefine filter criteria
Export

Spreadsheet: Save as a Microsoft Excel file (various Excel versions possible)

Word processing: Save as a Microsoft Word file

Local file: Export to various formats (e.g. TXT file, Rich Text Format, HTML format)

Send: Send as an e-mail

SAPoffice: Save in SAPoffice

ABC analysis: Perform an ABC analysis on a selected key figure column

HTML download: Save as an HTML file

RefreshRefresh the list during and after the analysis
EqualDisplay equal table contents at the current time (see Status column)
Missing tables

Display tables that are missing on at least one system and do not show any differences on the other systems (see the Status column).

In the Detailed comparison window, you can use this button to show or hide systems that do not contain the selected table.

MissingDisplay missing table contents at the current time (see Status column)
UnequalDisplay unequal table contents at the current time (see Status column)
Error

Display occurred errors at the current time (see Status column)

NOTE Errors also include tables that contain more table rows than originally selected (default value: 100,000 entries). You can recognize these entries by the overflow_error entry in the error message column. In the event of an overflow_error, you can start a post-analysis of the table with an unlimited maximum number of data records in a live comparison.
PendingDisplay outstanding checks at the current time (see Status column).
Download as Excel

You can download the results as a Microsoft Excel file. Use one or more quick filters to restrict the list to conflicts that you want download. Alternatively, you can select all entries with Ctrl+A. In the Detailed comparison window, you can also download the results according to the set filter.

NOTE A result file showing the corresponding conflicts is created for each table. If you select all entries to download them, this can take some time.
Compare with...Compare the present analysis result with a previous result.
Download reportDownload the result as an HTML file that contains the statistical values of the analysis and detailed data on the tables. You can also select the report in step 5 as an option.
DashboardOpens the Customizing Analysis management report and displays the results of the analysis in a dashboard. This is used to prepare a workshop on the customizing analysis.

Contexts for the Customizing Analysis

To view an analysis from different perspectives, you can select different contexts. The following subchapters describe which additional information about the respective tables is displayed after you activate a context.

You can activate the following contexts in the overview: 

  • IMG node for table: Activate
  • Objects from Transformation Cockpit scenario: Activate
  • Source/target and aliases: Activate
NOTE

If the context is enabled, no comparisons with other Customizing runs can be made in the results display.

IMG node for table: Activate

In the results display, you can display IMG node information for the relevant tables.

Proceed as follows to show the IMG node information:

  1. In the menu bar, click Context > IMG node for table: Activate.
  • You are asked whether you want to activate the context.
  1. Click Yes.
  • The column IMG node for system <System name> extends the table of the results display for each system.
  • The fields of the new columns show in brackets the number of IMG nodes and their names that are relevant for the table in the respective system.
  1. Click a field of the IMG nodes.
  • You switch to the view IMG node for table <Table name> on <System name>, which displays the desired section of the IMG tree.
  • NOTE

    The IMG tree is restricted to IMG nodes that are relevant for the table in question. The information displayed in the IMG tree is system-specific.

  1. Click Expand/collapse in the menu bar to expand the IMG tree for a better overview.
  2. Double-click the IMG node or select Jump to IMG tree from the menu bar in order to jump to the corresponding system.
  3. NOTE

    The jump requires a dialog connection to be entered in the SNP Cockpit for the RFC connection used. To do this, you need the login details.

  4. Enter the correct login details.
  • Once you have successfully logged in, the IMG tree opens up to the IMG node you selected in step 3.
  • The description of the IMG node is displayed. You can also jump to the stored transaction in order to maintain the customizing.
  1. Switch back to the results display. In the menu bar, click Context > Source/target from TC scenario: Deactivate to disable the function again.

Displaying Transformation Objects

In the results display, you can display the corresponding transformation objects from an Transformation Cockpit scenario.

Proceed as follows to display the transformation objects:

  1. In the menu bar, click Context > Obj. from TC scenario: Activate.
  • You are asked whether you want to activate the context.
  1. Click Yes.
  • The Scenario ID window opens.
  1. Select a scenario.
  2. Click Apply.
  3. The results display table is supplemented by the Transformation objects column.
  4. The transformation objects are displayed.
  • If the transformation objects in the results display are shown, you can jump directly to the Transformation Cockpit component.
  1. To do so, click an entry in the Transformation objects column.
  • A window opens.
  1. Click the desired transformation object.
  2. The status message Dialog will be executed in new mode is displayed.
  • The selected scenario is opened in a new session.

Displaying System Roles

In the results display, you can assign system roles to the systems used in order to distinguish between missing data records in source systems and missing data records in target systems. Here, you can use a Transformation Cockpit scenario as a template.

Proceed as follows to display the system roles:

  1. In the menu bar, click Context > Source/target and aliases: Activate.
  • You are asked whether you want to activate the context.
  1. Click Yes.
  • You are asked whether you want to use a Transformation Cockpit scenario to automatically prefill the system roles and aliases.
  1. Click Yes.
  • A selection of the available Transformation Cockpit scenarios opens.
  1. Optional: Select the scenario from which you want to import the system roles.
  • The window Assign system roles and aliases opens.
  1. In the window, define a system role (source or target) and a unique system alias for each system.
  2. NOTE

    If you have previously used a scenario for automatic filling, then all systems for which there is information in the specified scenario are filled with this information. You can overwrite this information at a later date.

  3. Click Apply.
  4. In the No. of Processes field, specify how many processes you want to use to calculate the group status.
  5. NOTE

    If you have selected the option Source/target and aliases: Activated, the window Results: (<Analysis name>) displays a new column each for Missing on target and Missing on source. The two columns indicate the number of groups with the status in question. The quick filter for the status Missing is replaced by two new quick filters for the statuses Missing on target and Missing on source.

  6. Double-click a table name.
  • The detailed comparison opens.
  • The results display table is supplemented by the columns Type, Alias, Missing on source and Missing on target.
  • The system roles are displayed.
  1. In the results display in the menu bar, click Context > Source/target from TC scenario: Deactivate to disable this function again.
  2. NOTE

    If you have selected the option Source/target from TC scenario: Activate, the program displays an additional column for sorting according to Missing on target and Missing on source below the detailed information. The Missing on source column has the value X if the affected group has a missing entry on at least one source system. The Missing on target column has the value X if the affected group has a missing entry on at least one target system.