This article shows how to synchronize a Salesforce account in near-real time with SAP.
In the following scenario, data from Salesforce is used to automatically create a customer account in SAP. The newly created SAP customer number is then written back to Salesforce.

About #

This article leads you through all necessary steps to set up the following process:

  • When an account in the Sales Console of Salesforce is modified, a Power Automate workflow is triggered.
  • The workflow checks if the type of the account is set to Customer - Direct and if the customer exists in SAP.
  • If both conditions are true, a yunIO service that writes customer data from Salesforce to SAP is executed.
  • Once the customer is created in SAP, the newly created SAP customer number is written back to the Salesforce sales account.

Setup in yunIO #

yunIO is the connector that reads and writes data from and to SAP. For more information on yunIO, see Theobald Software: yunIO.

  1. Define the connection to your SAP system in yunIO. This connection will be used to create the SAP customer. For more information on how to set up an SAP connection, see Online Help: SAP connection.
  2. Create a new service in yunIO. This example uses the standard BAPI BAPI_CUSTOMER_CREATEFROMDATA1 to create a customer in SAP. For more information on how to create a service, see Online Help: Getting Started.
    Set all import parameters you want to transfer from Salesforce to SAP to Supplied by Caller e.g., NAME, CITY, POSTL_COD1, STREET, etc.
    Select CUSTOMERNO for export. This Export parameter contains the newly created SAP customer number that is written back to Salesforce.
    yunio-Services-Function-Download
  3. Download the service definition (download-file icon).
    yunio-Services-Function-Download

Tip: It is recommended to test a yunIO service in a REST client before integrating it with Power Automate, see Running a yunIO Service in Swagger Inspector or Running a yunIO Service in Postman.

Setup in Salesforce #

Customize your Salesforce account to provide SAP related fields:

  • Create a field SAP ID. Once a customer is created in SAP, the customer number is written back into SAP ID.
  • Company Code, Sales Org, Distribution Channel and Disivion are organisation details required to create the SAP customer.
  • Create a checkbox that indicates if the customer exists in SAP.

For more information on how to customize fields in Salesforce, see Salesforce Documentation: Create Custom Fields.

Note: Creating Company Code, Sales Org, Distribution Channel and Disivion in Salesforce is optional as they can also be set as static values in Power Automate.

salesforce_before_sap

Setup in Power Automate #

  1. Integrate the yunIO service created in Setup in yunIO in Power Automate, see Integrating a yunIO Service with Power Automate.
  2. Create a new workflow that is triggered when a Salesforce account is mofified (1).
  3. Check if the account type is Customer - Direct and if the customer does not yet exist in SAP (2).
    If one or both conditions are false, end the workflow (3). If both conditions are true, execute the yunIO service to write the customer data to SAP (4).
    power-automate-salesforce-conditions
  4. Add the yunIO connector created in step 1 to the workflow and map the customer data from Salesforce to the input parameters of yunIO.
    power-automate-yunio-parameters
  5. Check if the SAP customer was created using the yunIO return field TYPE (5).
    If TYPE does not equal ‘E’ (error), the SAP customer number is written back to Salesforce.
  6. When updating the Salesforce account (6), assign the CUSTOMERNO from yunIO to SAP ID and set the checkbox In SAP to ‘Yes’. power-automate-write-to-salesforce
  7. Optional: Send notifications when a customer is created or log all synchronized Salesforce accounts e.g., in a SharePoint Online list.
  8. Turn on the workflow.

Triggering the Process #

  1. Go to Salesforce and change the account type from Prospect to Customer - Direct. Make sure that the checkbox In SAP is deactivated.
  2. The Power Automate workflow runs and creates the customer in SAP.
    power-automate-finished
  3. Check if the SAP customer number is set in Salesforce and if the checkbox In SAP is active. salesforce_after_sap
  4. Open SAP and look up the customer using the transaction xd03. Enter the customer number from Salesforce to look up the customer. sap-customer-search