Skip to content

SAP

Description

SAP (Systems, Applications, and Products in Data Processing) is a leading enterprise resource planning (ERP) software used to manage business operations and customer relations.

It integrates processes like finance, supply chain, sales, and human resources across organizations in real time. 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, Purchase Orders, 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 and Purchase Order data from the SAP S/4HANA system using OData v4.
The results can be filtered and routed using a Condition Switch to trigger different workflows:

  • Sales Orders can be pushed to a Google Sheet for real-time dashboards.
  • Purchase Orders can be validated and sent for approval via Send Email.
  • Item Master data can be compared with external warehouse databases to flag discrepancies.

Input

Not Applicable

Output

Output TypeFormatDescription
DataJSONSAP CRM object data in structured JSON format

Configuration Fields

Field NameDescription
ConnectionSelect an existing SAP OData connection. Required for authentication and host resolution.
Service URLThe base URL of the OData service. For example: https://sap-server/sap/opu/odata/sap/API_SALES_ORDER_SRV/.
ApiThe specific API endpoint path appended to the base URL. Often includes placeholders (e.g., /A_SalesOrder('{SalesOrderID}')/Items).
ParametersOptional dictionary of parameter key-value pairs to substitute placeholders in the API path (e.g., {SalesOrderID}5000000123).
Limit(Optional) Maximum number of records to fetch. Prevents over-fetching.
ODataVersionSpecify the OData version used by the target API. Supported: v2, v4.

Sample Input

Not applicable

Sample Configuration

FieldValue
connection vSAP Connection
objectNameA_SalesOrder
api/sap/opu/odata/sap/API_SALES_ORDER_SRV
limit50
odataVersionv4

Below are Some of the object names and endpoints that can be used for SAP activity:

Object TypeObject NameAPI Endpoint
Sales Order HeaderA_SalesOrder/sap/opu/odata/sap/API_SALES_ORDER_SRV
Sales Order LineA_SalesOrderItem/sap/opu/odata/sap/API_SALES_ORDER_SRV
Purchase Order HeaderA_PurchaseOrder/sap/opu/odata/sap/API_PURCHASEORDER_SRV
Purchase Order LineA_PurchaseOrderItem/sap/opu/odata/sap/API_PURCHASEORDER_SRV
Material MasterA_Product/sap/opu/odata/sap/API_PRODUCT_SRV
Customer MasterA_Customer/sap/opu/odata/sap/API_CUSTOMER_SRV
Supplier MasterA_Supplier/sap/opu/odata/sap/API_SUPPLIER_SRV
Item InventoryA_Stock/sap/opu/odata/sap/API_STOCK_SRV
Delivery DocumentA_OutboundDelivery/sap/opu/odata/sap/API_OUTBOUND_DELIVERY_SRV
Invoice HeaderA_BillingDocument/sap/opu/odata/sap/API_BILLING_DOCUMENT_SRV

Sample Output

A_SalesOrder

SalesOrderSalesOrganizationCreatedOnCustomerIDStatusCreatedByUserTotalNetAmountCurrency
500000012317102024-07-10CUST-1020OpenCB998000001140,000.00INR
500000012417102024-07-11CUST-1021ConfirmedCB998000001260,000.00INR
500000012517102024-07-11CUST-1022DeliveredCB998000001375,000.00INR
500000012617102024-07-12CUST-1023OpenCB998000001455,000.00INR
500000012717102024-07-13CUST-1024RejectedCB998000001520,000.00INR

A_SalesOrderItem

SalesOrderItemProductQuantityNetAmountCurrencyDeliveryDatePlant
500000012310PRD-100110025,000.00INR2024-07-121710
500000012320PRD-10025015,000.00INR2024-07-131710
500000012410PRD-10037030,000.00INR2024-07-141710
500000012510PRD-100110045,000.00INR2024-07-151710
500000012520PRD-10042530,000.00INR2024-07-161710

A_PurchaseOrder

PurchaseOrderPurchaseOrderTypeCreatedByUserCreationDatePurchaseOrderDateLastChangeDateTimePurchasingDocumentOriginPurchaseOrderSubtype
4500000001NBCB99800000262016-08-042016-08-049
4500000002NBCB99800000112016-08-102016-08-112024-07-25T10:45:00Z9Z1
4500000003FOCB99800000332016-09-152016-09-162024-07-28T12:30:00Z7Z2
4500000004NBCB99800000162016-10-102016-10-122024-07-29T14:20:00Z9Z1
4500000005FOCB99800000222016-11-012016-11-022024-07-30T09:00:00Z7Z2

A_PurchaseOrderItem

PurchaseOrderItemMaterialQuantityPriceCurrencyPlantStorageLocation
450000001010MAT-2021500100.00INR1710WH01
450000001020MAT-2022300150.00INR1710WH02
450000001110MAT-2023600120.00INR1710WH03
450000001120MAT-2024400130.00INR1710WH01
450000001210MAT-2025700110.00INR1710WH02

A_Product

ProductProductTypeCreationDateCreatedByUserGrossWeightWeightUnitProductGroupBaseUnit
21SERV2016-10-17CB99800001600KGP001HUR
22MAT2016-11-01CB998000016125KGP002HUR
23MAT2016-11-02CB998000016230KGP003HUR
24SERV2016-11-03CB99800001630KGP004HUR
25MAT2016-11-04CB998000016445KGP005HUR

A_Customer

CustomerIDNameCityRegionCountryStreetPostalCodePhone
CUST-1020Alpha TradersMumbaiMHINFort Road4000019876543210
CUST-1021Beta Ltd.BengaluruKAINMG Road5600019988776655
CUST-1022Gamma Co.DelhiDLINConnaught Pl1100019876512345
CUST-1023Omega Corp.PuneMHINFC Road4110019988665544
CUST-1024Zeta Pvt. Ltd.ChennaiTNINAnna Salai6000029876001122

A_OutboundDelivery

DeliveryIDSalesOrderShipToPartyStatusDeliveryDatePlannedGIActualGIWarehouseID
80000004515000000123CUST-1020Shipped2024-07-122024-07-112024-07-12WH-001
80000004525000000124CUST-1021InTransit2024-07-132024-07-122024-07-13WH-002
80000004535000000125CUST-1022Delivered2024-07-142024-07-132024-07-14WH-003
80000004545000000126CUST-1023Pending2024-07-152024-07-14WH-004
80000004555000000127CUST-1024Cancelled2024-07-16WH-005

A_BillingDocument

BillingDocumentSalesOrderAmountCurrencyStatusBillingDateCreatedByUserReference
9000001234500000012340,000.00INRPosted2024-07-13CB9980000111INV-001
9000001235500000012460,000.00INRDraft2024-07-14CB9980000112INV-002
9000001236500000012575,000.00INRPosted2024-07-15CB9980000113INV-003
9000001237500000012655,000.00INRCancelled2024-07-16CB9980000114INV-004
9000001238500000012720,000.00INRDraft2024-07-17CB9980000115INV-005