S4 HANA and IBP Integration using CPI-DS
In this blog, I will explain the CPI steps to integrate the S4 HANA and IBP using CPI-DS(Cloud Platform Integration for Data Services).
Refer the below blog to know quick overview about the scenarios/stories and IBP.
https://blogs.sap.com/2016/05/04/hit-the-ground-running-a-quick-start-guide-for-ibp-data-integration/
SAP help reference:
https://help.sap.com/viewer/eab8fd1726934516a89eabced318b210/1711/en-US
Scenario: OP S4HANA and IBP integration using a standard template
Source system: S4HANA
Data integration: CPI-DS using IBP Templates
Target system: SAP IBP
- Create a Project – Login to CPI system and create a new project for the integration scenario
- Create Task – Create the task using the SAP provided standard template
- Select source connection – Source and target connections should be created before designing the DS integration flow( S4H is the source connection for this blog)
- Select target connection – IBP_S4HOP is the target connection which connects to IBP on the cloud environment.
- Define data flow under the task created in step 2.
- Assign/Change staging table – You have the option to change the target staging table
- Change data flow using mapping editor – we have copied the standard template for location master integration. Using mapping editor we have the option to change the data flow objects such as mapping & query
- The next step is to map source and target structure using mapping editor
- Define data flow join
- Data flow custom filter
- Trigger data agent using the task by clicking the More Actions from the menu item.
- Check the flow in CPI-DS
- IBP Data replication verification – Login to IBP on-demand system and navigate to data integration jobs to check the replicated data
- IBP Replicated data – you can find the number of replicated records in the data integration jobs.
Some useful links to read more about IBP.
Wiki page : https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=441453186
CPI-DS
CPI-DS agent setup guide : https://blogs.sap.com/2015/12/11/step-by-step-guide-to-setup-hci-ds-agent/
Thank you for sharing.
This blog would greatly benefit from a short explanation on why did you do all this. While "step by step with screenshots" can be very helpful in a pinch, it does very little to educate the reader. Blindly following the instructions is not a very beneficial skill IMHO but without any story that's all there is to this blog, I'm afraid.
Thanks for your feedback Jelena. The focus is to provide step-by-step approach for S4HANA and IBP integration using CPI-DS template .
You can find the relevant details from SAP help link from the post and from the screenshots to find the actual template(for this case SOP_MD_LocationMaster).
Some useful links to read more about IBP.
Wiki page : https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=441453186
data integration quick start guide : https://blogs.sap.com/2016/05/04/hit-the-ground-running-a-quick-start-guide-for-ibp-data-integration/
CPI-DS
https://wiki.scn.sap.com/wiki/display/SCM/SAP+HANA+Cloud+Integration+for+data+services+-+Best+Practices%2C+Common+Mistakes+and+Debugging+Tips
CPI-DS agent setup guide : https://blogs.sap.com/2015/12/11/step-by-step-guide-to-setup-hci-ds-agent/
Cheers,
Sukumar
You might want to add the links to the blog directly.
Sorry but it seems you might have missed my point. There is still no answer to "why". Did you just wake up in a morning and decided to do these steps? It's probably not what happened. I'm guessing you had some problem to solve or some goal in mind. That information is still missing.
What's the story behind this? What compelled you to write up these steps? Might want to start even with a brief explanation on what the heck is IBP.
There are many good blogs on SCN with blogging advice. This is just one example (see p. 3 especially).
Thank you.
Thanks Sukumar, this is really helpful. I am starting into IBP so please excuse any naivety. I have one question here, the source in S/4 HANA which you took I assume it was a table. Since you have used a standard template so it would be a master data.
For transaction data how do we proceed? We have a requirement where changes to any product should also be replicated to IBP. What do you suggest in such scenario, a file based approach or a table in SAP which will act as staging table for changes and will be used as source.