When "Build single row at a time" option is checked, Process Runner DB will make a call to SAP for each record in record set instead of sending all the records to “where clause” for SAP in a single call.
Steps to use Build single row at a time:
1.Enter the select statement and check “Build single row at a time” checkbox and click OK button.
2.Consider that record set of select statement contain 100 records which are mapped in the where condition as follow.
3.Now execute the process file. For each record in the select statement record set a call to SAP with above where condition is made and records are retrieved from SAP.
Next: