
What are the different ways to automate SAP operations?
What to automate?
1. Uploading data from Spread Sheets, or CSV Files
2. Responding to an Email
3. Responding to a WhatsApp or SMS message
4. Using OneDrive, GoogleDrive
5. Consuming data from an external system into SAP and vice versa
Different tools
1. SAP's own tools
2. Third party tools
1. Batch Data Conversion
2. Script files generated from SAP in VBScript files
3. SAP Robotic Process Automation and Orchestrator
1. Generating VBScript files for consumption by SAP taking data from MS Excel.
a. By generating the VBScript files using VB Macros from Excel
b. By making program in any programming language generating VBScript files
Tools for non technical person like SAP Operators or users - UiPath - Community edition
Two profiles are available Studio and StudioX
Simple to make tasks by dragging and dropping different activities on to a canvas
Simple and visible Flow logic
Loops, If and Else conditions are giving power to decision making
In this example we will use Two Way Data Flow between Spread Sheet and SAP by using RPA
We will be using a Transaction code FB50, to generate General Journal Accounting Voucher
How to dowload UiPath Studio Community Edition?
How to install UiPath Studio Community Edition?
Create a simple Task so as to understand the flow of the activities
Learn about the tools (activity)
Input Dialog
Message Box
Flow of Activities
Run Project
Use Application / Browser
Call Transaction SAP Related Activities
Type Into
Keyboard Shortcuts
Click
Error Handling with SAP GUI
Filing System of UiPath Project
Activity
Read Statusbar
Introduction to the Flow of Activity
Making of a Flow Chart to reduce the logical flow error.
Using a Tool App.Diagram.Net a flow chart maker - online diagram making software
Activities
Use Excel File
How to Define Variables to store some information and to use later
For Each Excel Row
If Condition
Read Cell Value
Introduction to a data source file as MS Excel, having header and lines data to be consumed for data entry in SAP.
Flow of Activity required to automate data entry in General Journal Voucher
Showcase of a flowchart
Rebuild the project SAPSampleApp02 by extending the activities required.
There are various ways to automate desktop operations, by using varied methods of Robotic Process Automations. This course is to use one of the popular RPA tool UiPath Studio. The course provides a step by step to learn to make robots for automatic the operations of SAP, and extend the creativity to another horizon. The example taken from the real world scenario, where a large volume of accounting general journal documents were posted without human intervention.
What about those who are non technical person? The common users. Well there are various tools available to automate the Data Entry in SAP, automating the process which involves SAP and Other Applications like MS Excel, Emails, WhatsApp messages, OneDrive, Google Drive and so on.
So, one can email a statement of accounts to a registered email of a customer automatically upon receiving a request from the registered customer, by getting data from SAP Systems and then emailing the statement of accounts to the customer through Email Client or Gmail.
I will introduce in front of you, a popular Robotic Process Automation or RPA, the UiPath. There are two profile available, one is UiPath Studio and another is UiPath StudioX. The UiPath Studio is a community edition, thus it is available with zero price.