Results

The Execution phase of the Customizing Data stage allows you to view the changes that have been made to the Customizing Data.

Once the Execution programs have run from the Operation section it is time to view the results, go to the ‘Results’ drawer and select the ‘Customizing Data’ and click the ‘Execution’ tab.

The results are broken down by the following categories, this phase only includes the root tables identified by Consolidator.

Tables rekeyed automatically – The table can be rekeyed automatically without any involvement from the user
Tables that cannot be rekeyed automatically – The table has a limit of keys that can be added, for example, tables that only have a key of client (MANDT) so only one entry per client is allowed
Tables to be rekeyed manually – The table has been identified as being required to be rekeyed manually
Tables requiring review – The table can be rekeyed automatically, however, it should be reviewed to ensure the integrity of the system
Non root tables – The non root tables
Excluded tables – Tables that were excluded during the Analysis phase

The buttons on this screen operate by clicking the right hand down arrow details on what each button does are as below.

The ‘Update’ button allows the user to run the programs for this phase individually, however, it is recommended the user does not use this and completes this through the operation drawer as this adds greater clarity.

The ‘Workflow’ button allows the user to open and close this phase.

The ‘Overview’ button allows the user to view the reports for this phase, see the Reporting section for more details.

The tab holds information on all the tables and what happened through the execution, explanations for what each column represents are provided below the screenshot.

Status – This contains the status of the execution, all of the options are seen in the screenshot above with explanations below

• Not Executed – this has not been executed, if no data needs to be executed this status is correct
• Executed – this has been executed
• Failed – there has been a failure and this needs to be looked into
• No Modification – the translation failed
  

Tables – This contains the number of tables

Rows – This contains the number of rows of data

Key Conflict – This contains the number of rows with a conflicting key

Identical – This counts the number of identical rows between the two systems

Different Rows – Rows where the key conflicts, but the data is different

Non Ex. – Lines not existing in the target system

Trans. – The number of translations

Modif. – The number of modifications that have been made in the controller system

On a table row all of the numbers in the columns apart from ‘Table’ the data can be clicked and reviewed.

Example of results retrieved.

Note that the standard SAP display does not display large numbers of entries, to see all entries, select ‘Object’ then ‘Display Entire List’ as below.

In the same manner the modified rows can be clicked and reviewed.

Example of results retrieved.

There are also a number of options seen by using a right mouse click on a table.

The ‘Display’ option allows the user to display the table structures in each system or to compare the structures.

The ‘Show Content’ option allows the user to view the entries in each system or compare data.

Compare data option as below:

The ‘Translation’ option allows the user to view the data that has been translated and the impact.

The translation impact.

The ‘Set status’ option allows the user to set the status for this table, the details for each option are as below:

• Executed – this has been executed
• Failed – there has been a failure and this needs to be looked into
• No Modification – the translation failed
• Reset to initial – resets the value to the original one
  

When you have reviewed the translations and are certain you are ready to close the phase use the option on the ‘Workflow’ button and select close phase. Continue to the next phase Transfer Phase