This SAP ByDesign documentation is old and soon will be replaced. However, most of the content is still applicable.

SAP Business ByDesign is ideally suited for SMEs and subsidiaries of large corporations. It offers a complete, integrated suite that can run your whole enterprise – financials, human resources, sales, procurement, customer service, and supply chain.

SAP Business ByDesign integration from elastic.io is a flexible and easy-to-use way to integrate your ByD data with other applications you are using in your company.

The SAP Business ByDesign connector acts both as a trigger and an action connector at Elastic.IO.

Authentication

In order to use the SAP ByDesign with our Elastic.IO environment you would need to first authenticate your account.

Name your account (required) - Please give one memorable name for you to identify this account during the integration designer stage.

  • Service URL (required) - This is the address of your SAP ByDesign instance which should look something like https://my[number].sapbydesign.com where [number] should be specific ID unique to your instance.
  • Username (required) - The username of your SAP ByDesign account.
  • Password (required) - The password of your SAP ByDesign account.

Triggers

Query Price Lists

The Query Price Lists trigger will periodically query for new and updated PriceList objects. During the setup of the Query Price Lists trigger you can set the following options and constraints:

  • Account (required) - if you have authenticated your SAP ByDesign account before you can select it from the drop-down menu. Otherwise, you are given an opportunity to add your account from here as well.

    If the main idea is only to query the whole price list then no further input from the user is required in this part. There are, however, more optional fields which can help drill-down and filter the price list for specific types of sales, clients or distribution channels:

  • Type Code - Type Code specifies the type of price list or discount list and can have different values depending on your specific SAP ByDesign setup. More information about this can be access from SAP ByDesign help page about Query Sales Price List .
  • Sales Organisation Id - This field can be used to specify the Sales Organisation specific ID. The field expects only the ID, not the whole name. The information can be located in your SAP ByDesign > Product and Service Portfolio > Products.
  • Distribution Channel - This field can be used to define the type of sales. This is specific to your SAP ByDesign setup and can have different value but the expected format is numeric code like 01, 02, etc. For example, is can have 01 for Direct Sales or 02 for Indirect Sales.

Query Products

The Query Price Lists trigger will periodically query for new and updated Product objects. During the setup of the Query Price Lists trigger you can set the following options and constraints:

  • Account (required) - Select your account from the menu or authenticate the new one.
  • Product type - This drop-down menu has 3 possible values:
    • Master Products (NON SELLABLE) - This option can be used to query the non-sellable Master products. Non-sellable means that these products are referenced by variant products. Master means the product is not referencing another product.
    • Master Products (SELLABLE) - This option can be used to query for the sellable Master products. Sellable means that these products are not referenced by any variants.
    • Variant Products - This option can be used to directly query the different variants of one or many products.
  • Don't use snapshots - It is an optional field but is very useful if one needs to test the flow. Our system creates a snapshot of the sync after first use so that any subsequent queries would just transfer the updated information not the whole list. However, if you are still testing the flow it is sometimes useful to completely remove the synced snapshot from our system. This option prevents the snapshot to be created in the first instance.
  • Sales organisation ID (required) - In this field, the ID of the sales organisation should be written.
  • Distribution channel code (required) - This field is used to define the type of sales.

Actions

Before we can configure our integration flow to perform actions the authentication process needs to be performed. The SAP ByDesign action connector section always follows the mapper section on Integration Designer interface. Please scroll down to find it.

Get Price List by ID

When Get Price List by ID action is used it is only required to map the external ID of your product with ID from your price list in SAP ByDesign.

Create Customer

In this case of Create Customer action, there are more than 50 fields that your data can be mapped from which only a few are required to ensure that the process runs with the minimum requirements expected by SAP ByDesign system. These required fields are:

  • Account Debtor External ID (required)
  • Account Determination Debtor Group Code (required)
  • Address Country Code (required)
  • Address Street Postal Code (required)
  • Company ID (required)
  • Currency Code (required)
  • Distribution Channel Code (required)
  • Family Name (required)
  • Sales Organization ID (required)

Update Customer

Update Customer action has 40 fields where it can receive that data from which the required field are:

  • Address Country Code (required)
  • Address PO Box Postal Code (required)
  • Address Street Postal Code (required)
  • Family Name (required)

Get Stock Data by Product ID

When Get Stock Data by Product ID action connector is selected the system has only two required fields (Planning area ID and Product internal ID) where it expects data from a trigger connector.

Create Order

For using Create Order connector there is a possibility to map almost 60 different parameters from which the required field are:

  • AccountID (required)
  • Cash discount code (required)
  • Currency code (required)
  • Customer Account Debtor External ID (required)
  • Customer Account Determination Debtor Group Code (required)
  • Customer Company ID (required)
  • Customer Currency Code (required)
  • Customer Distribution Channel Code (required)
  • Customer Sales Organization ID (required)
  • Distribution channel code (required)
  • Main Price Amount (required)
  • Main Price Currency Code (required)
  • Product ID (required)
  • Product Quantity (required)
  • Product Recipient AccountID (required)
  • Product Units of measure (required)
  • Sales Unit AccountID (required)

Set Order Payment Info

When Set Order Payment Info action connector is used then your external data can be mapped into 3 required fields (Buyer ID, Cash Discount and Terms Code and Order ID).