Hello SAP-community,
In this post, we will see how to establish a connection to SAP Integrated Business Planning (IBP) in SAP Signavio using Odata service /odata/IBP/MASTER_DATA_API_SRV. And as test case, we will extract IBP location master data from one planning area and view it in SAP Signavio.
IBP Prerequisites:
Below steps should be executed by IBP Consultant with admin role.
1-Choose Communication Management from IBP homepage and click on
Maintain Communication Users app.
Maintain Communication Users (a)
2-Select
NEW user setup and enter below details
User Name: IBP_COM_USER
Description: IBP_COM_USER
Password can be generated automatically by clicking
Propose Password or else manually give any password.
Maintain Communication Users (b)
3-Select
Communication Systems app and click
New.
Communication Systems (a)
4-Enter the system ID and name for the communication system. Then in the General heading in the Technical Data section, checklist Inbound Only. Under Users for Inbound Communication, add the communication user previously created and select the authentication method below.
Choose Save.
System ID: SIGNAVIO
System Name: SIGNAVIO
User ID and Password: IBP_COM_USER
Communication Systems (b)
5- Select the
Communication Arrangements app and click
New.
Communication Arrangements (a)
6-Fill the communication scenario as
SAP_COM_0720, enter a name for the communication arrangement, and select the communication system that was previously created.
Also maintain the business user under Additional Properties section.
Arrangement Name: SAP_COM_0720
Communication System: SIGNAVIO
Corresponding Business User: CBXXXXXXX
Communication Arrangements (b)
7-In order to expose which planning area and master data to be used, we have to enter required planning areas and master data in
Global Configuration app in IBP.
Global Configuration (a)
8-Odata - /IBP/PLANNING_DATA_API_SRV service is used to add planning areas, hence select
FLEXQUERY PLANNINGAREA.
Odata - /IBP/MASTER_DATA_API_SRV service is used to define master data types, hence select
FLEXQUERY RELEVANT_MDT_FOR_MD_API.
Global Configuration (b)
Signavio Prerequisites:
Below steps should be executed by Signavio Consultant-
1-Login to
SAP Signavio homepage > Process Intelligence > Manage Data > Connections.
Select Create and enter below details.
Connection name: IBP-TEST
Connection type: Open Data Protocol
Connections (a)
2-Fill Credentials details from IBP communication user and enter the Configuration URL from IBP communication system.
Connections (b)
Configure Data extraction:
Here in this step, we will extract Location master data from IBP planning area
SAPIBP1.
1-Create test data in Location master data staging table
INTLOCATION under planning area
SAPIBP1.
Manage Master Data - INTLOCATION
2-Create new
source data named - IBP-UWE-Test and select
connection type – Open Data Protocol.
Signavio - source data (a)
3-Click
Next and select the connection created before. Then click
Create.
Signavio - source data (b)
4-Now the setup is complete.
Signavio - source data (c)
5-Click
Add table option and select the table which needs to extract. Here we are selecting the location master staging table. Click
Next.
Signavio - source data (d)
6-Here we need to select which fields needs to extract for location staging table. Click
Next.
Signavio - source data (e)
7-Now location table can be seen in list of tables here.
Signavio - source data (f)
Final Data extraction:
1-Click on the
action menu on right side of tables.
2-Select
Extract from the list.
3-Extraction process starts, and it can be checked in
Logs tab.
4-Once job completes – click on the record to show extraction logs.
5-For viewing the data click on
Preview from
action menu.
6-IBP test data is visible here.
Summary:
After reading this blog, you will be able to integrate IBP data to SAP Signavio using Odata service and this data will be used in Signavio Process data pipelines. Below are the steps covered:
1-IBP configuration
2-Signavio configuration
3-Master data transfer from IBP to Signavio
Like what you’ve read? Please share your thoughts, questions and feedback. Feel free to share on Facebook, Twitter, or LinkedIn using the super-easy share buttons at the bottom! And don’t forget to follow
SAP Signavio @ SAP Community &
SAP IBP @ SAP Community for more content like this.
Thank You...!!
