This Tutorial explains and walks you through basic concepts behind Process Runner DB.
Process Runner DB can run almost any SAP R/3 transaction, Business API (BAPI) or Remote Function module (RFM) and load data from wide range of databases (Oracle, SQL Server, Access, MYSQL, DB2 and Sybase) to SAP without any ABAP programming or coding.
Process Runner DB can upload and download data from SAP to databases. For the purpose of this section, we will focus on how to use Process Runner DB with SAP Transaction and upload iTable data to SAP.
We will take a simple example of updating material master in SAP. This example will help you understand steps involved in loading data from iTable to SAP R/3 transaction using Process Runner DB.
One has to perform following steps while working with Process Runner DB:
a.Decide what need to be done. Decide which SAP transaction is most appropriate for given task.
b.Prepare an internal iTable (XML table). Get ready with the data to upload.
c.Show Process Runner DB how to do it once - Record a sample transaction.
d.Map iTable columns and cells to SAP fields
e.Test run
Once you understand the given example, you can run almost any SAP transaction using same method in Process Runner DB.
Also note that Process Runner DB can execute transaction in any SAP modules. You can use Process Runner DB not only to update or change data in SAP but also to create data, to print, to delete, or simply to check existence of data
Next: