Skip to main content

Celonis Product Documentation

1.5 Multiple SAP Source Systems

It is often the case that more than one SAP system is required to get a full end-to-end view of the supply chain. This view can be split by regions, business units, company codes, etc. The Accounts Receivable data is flexible enough to support this with just a few steps.

Step 1: Create a duplicate of the local data jobs by clicking on the three dots to the right of the local job name and then clicking Duplicate. The duplication is important, because it allows for the same template transformations to be shared across the different data jobs. Do not simply copy and paste the data transformations.

image35.png

Step 2: Change the Data Connection of the newly duplicated data job to your other source system:

image92.png

Step 3: Select your data connection (or connections) from the drop-down.

image2.png

Step 4 (Optional): Change the name of the data job by removing the (1) that was added when the job was duplicated.

Step 5: Run both (or as many as required) data jobs as usual and remember to incorporate the new job into any schedules.

Step 6: In all global AR jobs, update the different transformations to reference both local jobs and union them together as shown in the example below.

DROP VIEW IF EXISTS "AR_ACCOUNT";

CREATE VIEW "AR_ACCOUNT" AS(

SELECT * FROM <%=DATASOURCE:SAP_CONNECTION_EU%>."ACCOUNT"

UNION ALL

SELECT * FROM <%=DATASOURCE:SAP_CONNECTION_APAC%>."ACCOUNT"

);