SAP Forms

With SAP Job objects you can execute a number of SAP functions directly from within the Automation Engine. For this purpose, Automic delivers Forms, that is, predefined sets of commands that depict those functions. Via the user interface you build scripts for SAP jobs without having to worry about their exact format.

SAP Forms are available for version 12.0 as of December 2016 with the Automic.Web.Interface.SAP.Forms plug-in that you can download from Automic's Download Center (click here: Automic Download Center ).

This topic provides information on the following:

The Automation Engine Script Guide provides detailed descriptions on the syntax of the individual SAP script elements (commands) here: About SAP JCL.

Background/Purpose

Thanks to the integration with SAP systems, you can execute jobs in SAP directly from within the Automation Engine.

Your Automation Engine system is connected to SAP via the agent, which interprets and transforms the commands sent by the client so that SAP understands them. This means that the only prerequisites your system must meet to be able to create jobs via the Automic Web Interface and execute them in the SAP client are providing the necessary connection and login data, namely:

  1. The agent binaries are installed and its INI file is configured to connect to the Automation Engine.
  2. The SAP Agent is defined
  3. At least one Connection (CONN) object provides the necessary data for connecting the agent to the SAP application server (the user and his/her login data). See Connection Objects.
  4. A Login (LOGIN) object is defined that provides the necessary credentials for the job to be executed. See Login Object (LOGIN).

Please refer to the Technical Connection chapter for detailed information.

Once these prerequisites are met, you just have to build the scripts to be executed. You do so on the Process page of the SAP Job object definition.

Given the complexity of SAP functions, this can be really cumbersome. This is where the SAP Forms provided by the Automation Engine come into play. They are an additional, intuitive way to build scripts for SAP jobs using a graphical interface that provides ready-to-use commands.

Required Authorizations

To establish the connection to the SAP system, the SAP agent takes the SAP credentials (user name, password and client) from the Connection object for ABAP Basis. To be able to use the SAP Forms you need the following authorizations:

Synchronized Views - Script Editor/Form

Two views are available on the Process page of SAP jobs that you can toggle on/off using the buttons at the top of the page:

Both views are synchronized. Adding an SAP command via the Form view means that the corresponding code line is simultaneously written in the Script Editor; if you then populate the fields in the Form, these values are also written to the Script Editor.

Likewise, entering or editing script elements in the Script Editor results in the corresponding modifications in the SAP Form.

Instead of entering values in the fields of the SAP Forms you can use variable scripts. This also applies to the Script editor view, of course.

The synchronization of the values you specify for checkboxes and radio buttons is a special case. It is not possible to set their values in a script variable when using the script editor. If you do so, when you save the job, they will be overwritten by the values selected for those checkboxes/radio buttons in the Form view.

Example

You create a script that copies a report variant. Using the SAP Form view you simply add the Copy an Existing Variant command to the script designer and enter the values in the command fields:

Click to Expand

If you switch to the Script editor view, the script statement looks like this:

Click to Expand

Of course, entering or editing script elements in the script editor results in the corresponding modifications in the SAP Form as well.

Default Settings not Displayed in the Script Editor

Many command parameters have a default value. If you keep the default value when building your scripts, the Script Editor does not display these parameters.

For example, in the case of Copy an Existing Variant commands (R3_COPY_VARIANT), such as the one used in the previous example, the default for Protect Variant is No. This means that, by default, this checkbox is unselected. The Script Editor does not display this setting.

However, if you select it, that is, if you set a value other than the default, the Script Editor includes it. It looks like this:

Click to Expand

Combining SAP Commands With Non-SAP Statements

When building scripts for SAP jobs you may want to use not only SAP-specific commands but also the Automic scripting language, for example. You can enter these statements in the Script Editor.

If you do so and then switch to the Form view, non-SAP commands are grayed out to help you easily recognize them. For example, we add the following two lines to the statement depicted in the previous screenshot:

Click to Expand

Switch now to the Form view. This is how it looks like:

Click to Expand

Retrieving Values from the Target SAP System

With an active online connection to an SAP system it is possible to retrieve the values with which to populate the input fields, dropdown lists, etc. Click the button where available. For example:

Click to Expand

This opens a dialog that allows you to search for and retrieve data from the SAP client and insert it in your scripts. The contents and layout of the dialog depend on the nature of the data you need. It may display a list where you select a record and click Choose to insert it in the form field like this one:

Click to Expand

Or it may contain a pane on the right hand side, where you must filter the data, and a left hand side pane that displays the results of your filter criteria. For example:

Click to Expand

  1. Enter your search criteria on the right pane
  2. Click the Search button at the bottom of the pane.
  3. Select the appropriate record in the left pane.
  4. Click Choose at the bottom of this dialog.

    The selected record is inserted in the form field.

In both cases, information on the connection to the SAP system is displayed at the bottom of the dialog.

To Work with the SAP Form View

ClosedTo Add Commands to the Script

  1. Open the Process page of the SAP Job object.
  2. Click the button to toggle the Form view on.

    The Commands pane is displayed on the right hand side. This is where you build the SAP script using predefined commands.

  3. Click Add Command to open a dialog that displays all the available commands arranged in groups.
  4. Select the required one. You have two options:

    • Scroll through the list and expand the command group where the required one is located.
    • In the Search field at the top of the dialog start writing any word that is contained in the name of the command you need. The list below displays the commands that have the entered string in their names. For example:

      Click to Expand

  5. Click the Add Command button at the bottom of the dialog.

    The command is inserted on the pane and the corresponding input and selection fields are displayed on the main page.

  6. Populate the fields as required.

    With an active connection you can retrieve values from the SAP system. For this purpose, click where available. For some fields also a Preview button is available.

  7. Continue adding commands and entering values until you have finished building the script.
  8. Save your changes.

Switch to the Script Editor view; the commands and the values you have specified are also inserted here.

ClosedTo Duplicate Commands

  1. On the Commands pane, right-click on the command you want to duplicate.
  2. A context-menu is displayed. Select Duplicate.
  3. The new, duplicated command is inserted immediately below the original one. All settings and selections made in the original command are also available in the new one.
  4. Save your changes.

ClosedTo Remove Commands

On the Commands pane do one of the following:

ClosedTo Change the Order of the Commands/Script Elements in the Script

The Form view allows to rearrange the order of the commands, whether SAP-specific or not, by dragging and dropping them. The commands in the Script editor are rearranged accordingly.

  1. On the Commands pane, click on a command or on a non-SAP statement to select it.
  2. Hold the mouse button to drag and drop it to the position where you need it.

    For example, the screenshot below shows how the Create a New Variant command is being dragged from the bottom of the commands list to a position between the two non-SAP statements:

    Click to Expand

  3. Save your changes.

See also: