In this article a scenario is described, where a Salesforce account is synchronized in near-real time to SAP. An SAP customer is automatically created and the customer number is written back to Salesforce using the following tools:

  • SAP ECC system on Premise
  • ECS Core for SAP process integration with cloud scenarios
  • Salesforce
  • Microsoft Power Automate as workflow solution

ECS Core enables you to build powerful and sophisticated cloud applications for SAP on Premise. It allows you to integrate your cloud-based apps with SAP.
For that ECS Core uses only outbound connections. It pulls the pending requests from the cloud, sends the query to the SAP system for execution and then sends the SAP result back onto the cloud service.

Step 1: Define the Connection to the SAP system

In ECS Core define the connection to your SAP ECC system. This connection will be used to create the SAP customer.

ecscore_salesforce_Flow_ERPconnect_01

Step 2: Use ECS Core to provide a REST Service for SAP customer master data creation.

The WebService Designer tool provided with ECS Core is used to create a REST Service “CreateSAPCustomer” based on a default SAP function module to create customer master data. The REST service has different input parameters covering customer information and returns the number of the created SAP customer.

ecscore_salesforce_Flow_ERPconnect_02

ecscore_salesforce_Flow_ERPconnect_03

Deploy the REST service then it can be consumed in the cloud.

ecscore_salesforce_Flow_ERPconnect_04

Step 3: Customize your Salesforce account to provide related fields such as SAP Customer Number.

In the Salesforce account you need to creat some addtional fields to store the SAP customer number and further details required to create the SAP customer, e.g. SAP Company Code or related sales data such as the sales organization.

ecscore_salesforce_Flow_ERPconnect_05

Step 4: Use Microsoft Power Automate to define a workflow to trigger Salesforce account Changes

As a workflow solution Microsoft Power Automate is used to trigger any account changes in Salesforce, where the account type is changed from prospect to customer and no related SAP customer exists. In this case the SAP customer will be created using the Salesforce account data. When the operation is successful, the Salesforce account is updated with the SAP customer number.

ecscore_salesforce_Flow_ERPconnect_06

Optional steps

In your workflow, you can use further optional steps. In this sample a SharePoint Online list is used to log all synchronized Salesforce accounts to SAP. An additional step could be the sending of notifications when a customer has been created.

ecscore_salesforce_Flow_ERPconnect_07

Let’s have a closer look and go through the process.

Let us change the account type to customer. As you can see the field SAP ID is empty.

ecscore_salesforce_Flow_ERPconnect_08

The workflow runs and creates the customer in SAP.

ecscore_salesforce_Flow_ERPconnect_09

Check the customer in SAP.

ecscore_salesforce_Flow_ERPconnect_10

Go to Salesforce and check that the SAP customer number is set.

ecscore_salesforce_Flow_ERPconnect_11

Now check the video to see that in action:


Related Links