Technical Articles
How to synchronize time-series master data from SAP ECC to SAP IBP via Supply Chain Integration add-on and CPI-DS
Integration is an import part for a plan system. Usually we need to synchronize master data such as product, location, resource etc. and transactional data like sales order, planned order, product order etc. For SAP Advanced Planning and Optimization, we use CIF to handle these, and for SAP Integrated Business Planning for Supply Chain solution, SAP provides a ‘SAP ERP, supply chain integration add-on for SAP Integrated Business Planning’ to do the data synchronization. The add-on is suitable for both time-series data and order-based data.
In this blog, you will get the introduction of add-on’s overview and an example about how to use add-on to synchronize time-series master data from SAP ERP Central Component (SAP ECC) to SAP IBP.
Supply chain integration add-on for SAP IBP overview
Let’s start from the system landscape.
a. The add-on will collect master/transactional data through application and store these data in staging tables. You can find these staging tables by searching ‘/IBP/*EXT’
b. For order-based data, add-on provides some function modules to connect with data provisioning agent, and the agent will use OpenAPI to synchronize data with SAP IBP through SAP HANA smart data integration.
c. For time-series data, with SAP IBP inbound scenario, add-on provides some data sources’ extractors which let SAP Cloud Platform Integration for data services (CPI-DS) to get data and send to SAP IBP. With SAP IBP outbound scenario, it will provide some web services to handle it.
Tips:
Make sure to active these data sources, after the add-on is installed.
Master data’s data sources are under application component ‘SCM-IBP-INT-ECC-TS-IO’, transactional data are under ‘SCM-IBP-INT-ECC-TS’.
After we have some preliminary knowledge of the add-on, imagine a simple scenario, planner want to synchronize SAP ECC’s plant data to SAP IBP. Let’s have a look at this solution step by step.
1. Define plants
Tips:
Add prefixes ‘/n’ or ‘/o’ when use the T-Code which have prefixes ‘/IBP’.
2.Integrate Locations to SAP IBP
Use T-Code: /IBP/ECC_INT_LOC to initial load of the selected plants.
Plants, customer, vendor are defined as location in SAP IBP. This program can collect all these three types of locations’ data. In this example, we just need to set plant’s transfer mode as initial load.
If there is no customization requirement, the work of SAP ECC side has been completed.
Tips:
For customer, vendor and material data, we can use BTE to immediate, automatic transfer of all the changes to the staging tables which will be transferred to SAP IBP.
But if plant has been changed in SAP ECC, the changes will not synchronize to table ‘/IBP/LOC_EXT’ automatically. We have to re-execution ‘/IBP/ECC_INT_LOC’ to transfer the change to the staging table. That means maybe we should define a period background job to handle it.
3.Use template to create a task
4.Define global variables
4.1 $G_LOAD_DATE
4.2 $G_PLAN_AREA
We need to fill planning area ID in this variable.
4.3 $G_BATCH_COMMAND
The following values are supported for this variable:
- ‘INSERT_UPDATE’ (inserts or updates the selected entries, but does not delete any entries)
- ‘DELETE’ (deletes the selected entries)
- ‘REPLACE’ (deletes all entries, and replaces them with the selected ones)
Hopefully, this article will help you better understand how to synchronize time-series master data from SAP ECC to SAP IBP via supply chain integration add-on and CPI-DS.
You can refer to the SAP help portal as below for more information.
Locations via Extractors: https://help.sap.com/viewer/ccfe175310e04be9b38087c8df73974d/1.1%20SP11/en-US/e235699350db4d8794ebe3d3314d75b0.html
Thanks! Liked it and helpful. Steps need to be mentioned clearly where are they being executed. Great learning. Thanks!
Good post !
Based on the integration setup I understand that customer master data should be read from the same /IBP/LOC_EXT staging table. In the note 2735177 - IBP Integration - Mapping Overview for Time-Series Content you can find the mapping. I am wondering that for example for supply chain planning purposes you might need ship-to customer data as the customer ID in IBP and then the relevant attribute data. Please share you experience, concrete examples and best practice on this area if you have some?
It is really nice article, Thanks for sharing such insight on integration between SAP IBP-ECC/H4HANA