Create and Run OData File

This topic describes how to retrieve, create, or update data in SAP using an OData service and place that data in Excel using Process Runner.

Note: This feature is available as an initial release. Process Runner supports creating an OData process file, running an OData process file with start and end row, and saving an OData process file to a local device. Advanced features are not supported in this release and will be incorporated in future releases.

Prerequisites

• Before you begin, ensure that an SAP system configured for OData is available in the Connector for SAP window. For more information, see Add non-SAP GUI System.
• Ensure that the SAP OData service is activated and the required authorizations are configured. For more information, see SAP OData Authorization Requirements.

Create an OData Process File

1. Select File > New Process, or select New Process on the Home tab. The New Process window appears.
2. Select OData(OD) from the left side.
3. Select Start Recording. The Connector for SAP window appears with the SAP systems configured for OData.

   Note: If you have not yet added an OData-enabled SAP system to the connector, select Add Server and configure the connection before proceeding. For more information, see Add non-SAP GUI System.

4. Select the SAP system and then select Logon.
5. In the New Process window, enter or select the name of the OData service in the OData Service field. For example, ZAPI_SALES_ORDER_SRV.
6. In the Entity Set field, select the entity set from the drop-down list. For example, A_SalesOrder. An entity set is a collection of records of the same type exposed by the OData service, such as sales orders, customers, or materials.
7. In the Operation field, select the operation to perform based on selected entity set. The following operations are available:
   • GET (Read): Retrieves data from SAP into Excel.
   • POST (Create): Creates new records in SAP using data from Excel.
   • PATCH (Update): Updates existing records in SAP using data from Excel.
8. Select Load Schema. Process Runner connects to the SAP OData service and retrieves the schema. A field selection list appears, showing all available fields for the selected entity set, including any navigation properties.
9. Select the check boxes next to the fields you want to retrieve. Use Select All or Unselect All to manage your selection. Mandatory fields are selected by default and cannot be cleared.
10. Select OK. Process Runner builds the OData interface and opens the process file as a new file with the Mapper tab open.

Save the Process File

1. Select File > Save As.
2. Select Save As Local — saves to a local or network path.
3. Browse to the target folder, enter a name for the process file, and select Save. The file is saved with the current date and time appended to the file name with .iof extension. You can change the file name before saving.

Run the Process file

To run the Process file, see Run an OData Process file