SAP Notes Impact Analysis

This workflow analyzes SAP Notes that have been downloaded to your SAP system using the SAP Note Assistant (transaction SNOTE). For example, for all notes that have been downloaded and applied using the Note Assistant, there may be some interest in knowing that there are objects in the support packs that may have an impact on the applied notes.

The results are used to generate an Excel report which has the following columns:

Column Description
Note The SAP Note number.
Version The version of the SAP Note.
Pgmid The program ID in the associated support pack.
Object Type The type of the associated support pack object.
Object The name of the associated support pack object.

Support Pack

 Customize the Object Change Impact Analysis template so the input is a table specifying these objects.
Note Description The description for the SAP Note.

Optional: The results are also stored in an External Data Source named SAP Note Objects and formatted as input for Impact Analysis.

If a support pack has not been applied to the Source SAP system, it must be disassembled before it can be analyzed using the SAP Notes Impact Analysis workflow. This can be done by running transaction SAINT and selecting ‘Disassemble OCS Package’ from the ‘Utilities’ menu. Alternatively, it may be disassembled using the Package Disassembler App.

Creating RFC Destinations

Before running the SAP Notes Impact Analysis workflow, you will need to create an RFC Destination for the system containing the downloaded SAP Notes.

Preparing the Workflow

To prepare the SAP Notes Impact Analysis workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:

To specify the system containing the downloaded SAP Notes:

  1. Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Enter one or more transport names from the Source system, or paste in a selection of transport names from an Excel spreadsheet, then click ‘Save’.

To specify which transports to analyze:

  1. Select the Transport List parameter and choose ‘Edit Table’ from its context menu to display the Table Editor dialog.

  2. Enter one or more transport names from the Source system, or paste in a selection of transport names from an Excel spreadsheet, then click ‘Save’.

If it is more convenient to specify a range of Transport IDs rather than a large list, you can do this by modifying the workflow as follows:

  1. Select the Transport Selection Table Schema parameter and choose ‘Edit Table’ from its context menu to display the Table Editor dialog.

  2. The transport selections table has the following columns:

Column Description
SELNAME This column should be set to SPPK.
KIND This column should be set to S
SIGN If this column is set to ‘I’ the transport specification will be included in the analysis. If the column is set to ‘E’, the transport specification will be excluded. The ‘E’ option should only be used if the table also has a row which uses the ‘I’ option.
OPTION The comparison operator to use: One of EQ, GT, GE, LT, LE, BT or CP. See the Select List Parameters help topic for details.
LOW The name of the ‘low’ transport name in the specification.
HIGH If the BT (Between) operator is used, this column refers to the ‘high’ comparison value.

  1. Modify the table so that it contains specifications for the transports to be analyzed, then click 'Save'. Transports that have been disassembled but not imported should be specified individually in the table using the EQ operator. Transports that have been imported may be specified using the BT operator with a range of values.

  2. Delete the Transport List parameter and the components that lead up to the Get Transport Objects action (the Convert Data and Execute SQL actions, and the Transport Table and Transport Selections datasets).

  3. Select the Get Transport Objects action. In the Property Editor, set the action's 'Source' property to be the Transport Selection Table Schema parameter.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the SAP Notes Impact Analysis workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select the Report URL dataset and choose ‘View Details’ from the context menu to access the generated report.

Excel Report

The SAP Notes Impact Analysis workflow generates an Excel report, which includes the following spreadsheets:

SAPNoteImpact

This spreadsheet lists the SAP Notes associated with each impacted object. The note ID, version and description of each SAP Note is shown.