SAP
Description
The SAP activity enables integration with SAP CRM systems using OData v2 or v4 protocols. It allows workflows to fetch structured business data such as sales orders, customers, or materials from SAP services..
This activity is typically used to fetch master data, transactional records, or business object details from SAP. It supports flexible configuration to connect with various OData services exposed by SAP, such as Sales Orders, Customers, Materials, etc.
SAP systems expose data as entities (objects), and each entity can be queried using APIs. This activity supports configuring the object, API version, and additional constraints like result limits.
Use case:
In a supply chain automation workflow, use the SAP activity to fetch live Sales Order records from the SAP S/4HANA system using OData v4. The results can then be passed to a downstream Email Sender activity to notify account managers, or to Google Sheet Upload for reporting.
Input
- Data – Optional input used for advanced filtering or parameters (depends on the target API).
Output
| Output Type | Format | Description |
|---|---|---|
| Data | JSON | SAP CRM object data in structured JSON format |
Configuration Fields
| Field Name | Description |
|---|---|
| Connection | Select an existing SAP OData connection. Required for authentication and host resolution. |
| Object Name | The name of the SAP object/entity set to fetch. For example: A_SalesOrder, Customer, etc. |
| Api | The specific OData endpoint within SAP. Typically maps to a service root path like /sap/opu/odata/sap/API_SALES_ORDER_SRV. |
| Limit | (Optional) Maximum number of records to fetch. Prevents over-fetching. |
| ODataVersion | Specify the OData version used by the target API. Supported: v2, v4. |
Sample Input
Not applicable
Sample Configuration
| Field | Value |
|---|---|
connection.id | sap-prod-connection |
connection.name | SAP Production CRM |
objectName | A_SalesOrder |
api | /sap/opu/odata/sap/API_SALES_ORDER_SRV |
limit | 50 |
odataVersion | v4 |
In this example, the workflow is configured to fetch recent sales orders from an SAP S/4HANA system using the OData v4 protocol:
- Object Name:
A_SalesOrder - API Endpoint:
/sap/opu/odata/sap/API_SALES_ORDER_SRV - OData Version:
v4 - Limit:
50
This configuration retrieves the 50 most recent Sales Orders from SAP. A downstream StaticLookup or ConditionSwitch activity may route the records based on SalesOrderType (e.g., OR for standard orders) for further processing like sending email alerts or pushing to external systems.
Sample Output
| SalesOrder | SalesOrganization | CreatedOn | CustomerID | Status |
|---|---|---|---|---|
| 5000000123 | 1710 | 2024-07-10 | CUST-1020 | Open |
| 5000000124 | 1710 | 2024-07-11 | CUST-1021 | Confirmed |
| 5000000125 | 1710 | 2024-07-11 | CUST-1022 | Delivered |