Boosting the Sales Order Management Process with an Automation

Objectives

After completing this lesson, you will be able to:
  • Explain how bots are executed
  • Review the Automation Editor
  • Prepare the Excel file with sales order details
  • Create and edit the automation
  • Map the right order using a loop with conditions
  • Finalize, test, simplify, release, and deploy the automation

Introduction: Boosting Business Processes with Automation

Watch this video to learn about automations.

Why use automations?

Automations can speed up your process and reduce potential errors related to manually transferring data. Now that you have mastered the basics of setting up your process, it’s time to simplify your trigger form by reducing the number of input fields. You will use robotic process automation (RPA) to extract data from an Excel file that contains the details of the sales order. You will then learn how to map the inputs and outputs of the different artifacts according to the changes of the process. Lastly, you will use the Desktop Agent to run your process.

The two modes of Bots: unattended mode and attended mode.

The task automation can run in two ways:

  • Unattended mode: Bots work autonomously with human supervision only – there is no human intervention in the part of the process RPA is running.
  • Attended mode: The attended mode in which bots will work with humans to assist them, to help the bot.

The Automation Editor

Parts of Automation Editor

Four main areas of the Automation Editor.

The Automation Editor of SAP Build Process Automation is composed of four main parts:

  • Toolbar: Can do simple actions such as undo, redo, delete a step, save your automation, or even test it.
  • Workflow: Shows you the list of steps inside your automation.
  • Right-Side Panel: Adds steps to your automation. You can add activities, data, or different controls to your workflow.
  • Console: Access the design and test console to see different errors, warnings, and info about your automation while designing or testing it. You can also access the variables of the automation.

Prepare the Excel File With Sales Order Details

Business Scenario

SAP Build Process Automation has native integration to several Microsoft Office products, including Outlook and Excel SDK. In this exercise, you will learn how to use Excel files in your automations.

To design your automation, you will need an Excel file filled with the sales orders data. You can create it yourself using the sample below.

Note

In this exercise, you will create an Excel file containing Sales Order data. You can create it manually (refer to task 1) or download the prepared file (refer to task 2).

Task 1: Prepare the Excel File with Sales Order Details

Steps

  1. Create an Excel file.

    Use the following cell formats:

    ColumnFormat
    Order NumberText
    Order AmountNumber
    Order DateDate
    Shipping CountryText
    Expected Delivery DateDate
    Order StatusText

    Note

    Ensure that you use the correct format of the cells in the columns listed above.

    1. Open MS Excel.

    2. Create an Excel file with the columns you find in the table above.

    3. Save the file under a name of your choice.

  2. Add data to the columns.

    Enter the following data:

    Order NumberOrder AmountOrder DateShipping CountryExpected Delivery DateOrder Status
    PO7991410418.221/21/2022United States of America1/29/2022In Time
    PO7918150935.131/22/2022United Kingdom1/27/2022Urgent
    PO7375313977.821/23/2022United Kingdom2/20/2022In Time
    PO7311755055.41/24/2022United Kingdom3/30/2022In Time
    PO6858429358.41/25/2022United Kingdom2/20/2022In Time
    PO636843739.821/26/2022United Kingdom3/25/2022In Time
    PO6189483574.121/27/2022Germany2/5/2022In Time
    PO3115273993.561/28/2022Germany3/10/2022In Time
    PO2686220887.561/29/2022Germany3/5/2022In Time
    PO8282436955.641/30/2022United States of America3/30/2022In Time

Task 2: Download the Excel File

Steps

  1. Click here to download the Excel file.

  2. The file will get downloaded to your PC.

Creation and Edition of an Automation

In preparation for the next exercise, watch the following video about creating an automation.

Create and Edit the Automation

Business Scenario

Now that your Excel file is ready, let’s create the automation. Open the process in Process Builder and add a new automation between the Trigger Form and the Approval Form. You will create the automation, edit the automation details, and map the Excel file variables with the sales order data. Then, you will use a loop to confirm that the result of the inputs looks correct.

Follow this interactive tutorial to learn how to create and edit the automation.

Task Flow

In this exercise, you will perform the following steps:

  1. Add a New Automation to the process.
  2. Set the Environment Variables of the project.
  3. Add Excel activities.
  4. Perform Excel Data Mapping.
  5. Close the Excel instance.
  6. Add input and output parameters.
  7. Create a variable.

Exercise Options

To start the exercise, choose Start Exercise in the figure below.

A pop-up opens. You have the following options:

  • Choosing Start: The simulation starts. Follow the simulation to learn how to create and edit the automation.
  • Choosing Open PDF Document: A PDF opens. Based on the steps described in this document, you can perform the exercise in your own system landscape.
ExerciseStart Exercise

Result

You have now created and edited the automation.

Mapping the Order Using a Loop with Conditions

Watch the video to learn how to map the order using a loop with conditions.

Map the Order Using a Loop with Conditions

Business Scenario

Excel Data Mapping allows you to transform column-based data from an Excel sheet into datatype that can be used in your automation. The data from the Excel sheet stays the same but the structure becomes a data type structure, making it possible to use throughout your project.

To check if you have correctly mapped the sales order data, you need to loop through the orders and check if you can find yours using the condition, and see if the order number that you received from the trigger is equal to the currentMember of the authors.

Task Flow

In the task of this exercise, you will perform the following steps:

  1. Add a New Automation to the process.
  2. Add a control activity.
  3. Set the variable.
  4. Stop the loop.

Exercise Options

To start the exercise, choose Start Exercise in the following figure.

A popup opens. You have the following options:

  • Choosing Start: The simulation starts. Follow the simulation to learn how to map the order using a loop with conditions.
  • Choosing Open PDF Document: A PDF opens.
ExerciseStart Exercise

Finalize, Test, and Simplify the Automation

Business Scenario

At the end of your automation creation process, there are some last steps to fulfill. First, you have to create output parameters and connect them with the endpoint of the automation. If everything has been set up, you can run a test. After successful testing, to simplify the start form, you can delete all redundant information. Release your process project that finally can be deployed.

Exercise Options

To start the exercise, choose Start Exercise in the figure below.

A pop-up opens. You have the following options:

  • Choosing Start: the simulation starts. Follow the simulation to learn how to finalize, test, and simplify the automation.
  • Choosing Open PDF Document: a PDF opens. Based on the steps described in this document, you can perform the exercise in your own system landscape.
ExerciseStart Exercise

Result

You have now finalized, tested, and simplified the automation.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn