Problem solve Get help with specific problems with your technologies, process and projects.

MDM-XI-R/3 integration

Learn how to integrate Master Data Management (MDM) and SAP R/3 using SAP PI in short frame with SAP NetWeaver as the framework in this tip authored by Bala Subbaiah Gorla of SDN. Inbound and outbound scenarios are presented.

This blog will show you how to integrate Master Data Management (MDM) and SAP R/3 using SAP PI in short frame with SAP NetWeaver as the framework. MDM and R/3 integration is required in two different scenarios as listed below.

Prerequisites for integration of these scenarios include some of the software applications installed. The list is as below:
*SAP R/3 (4.6, 4.7, or any)
*SAP MDM version 5.5 SP3 Server
*SAP MDM Syndicator
*SAP PI (Process Integration), formally XI (Exchange Infrastructure) Version 3.0 SP16

Outbound Scenario - MDM to R/3 (Inbound to R/3)

Inbound Scenario - R/3 to MDM (Outbound to R/3)

PART I (Inbound Scenario)

We will be discussing the inbound process i.e., inbound to the SAP R/3 and outbound to the SAP MDM.

Figure 1. Inbound to R/3

MDM Console side Configuration Steps

Step One - Create Client System
Log on to the SAP MDM Console and choose the repository which you going to syndicate
Navigate the selected Repository

(Example Repository, BP3_PoC_Customer) -->Admin -->Client Systems. This right hand side you can find Client Systems context area. If you right click on context area, you will get the context menu Items, choose --> Add Client System, enter name of a client system (example, Siebel), code and type. See the below figure 2.

Figure 2. Client System

Step Two - Create Port for Client System
Select --> Ports --> by navigating MDM Console -->Repository (BP3_PoC_Customer) --> Admin --> Ports.
By clicking on the Ports you will get Context Area in the right side.
Right click on the Context Area and you will get Context Menu.
From selections choose the Menu Item -->Add port.
Here you need to give TWO ports details, one is for Outbound, and other one is for Inbound. In this step we need Outbound Port.
The Port Name is SIEBEL_OB_CUS_SIEBELCUS01, Code SIEBEL_OB_CUS_SIEBELCUS01, and Type as Outbound. See the figure 3 below.

Figure 3. Port

MDM Server Side Configuration

In the SAP MDM Server-->Look at the server folder structure for the repository. Here, you can see the Client system and Outbound Port details as folder name in the SAP MDM Server folder, which creats in MDM console as shown in below figure 4.

Figure 4. SAP MDM Server Folder

NOTE: No customizing is required in MDM Server but you need to ensure whether the folders as explained here are created in the inbound and outbound folders after additions of the ports in console.

FTP Server Side Configuration

Step Three -- In the FTP Server
How To?
Configure/Specify the file folder path for pulling the file in FTP Server.This is screen refers the FTP server configuration (WS_FTP server).

Figure 5. FTP Server

SAP XI / PI Side Configuration

Step Four - Sender Communication Channel
In the PI Integration Repository:

Figure 6. Sender CC

Step Five - Receiver Communication Channel

Figure 7. Receiver CC

Inbound Process Flow

Figure 8. Process Flow

>>>Here, I will be discussing about inbound process, the above figure shows the entire process.

Process step in MDM: You need to choose the destination structure, i.e., type of the destination file like XML, XLS, and CSV. Then mapping will have to be done in the MDM Syndicator that for specified repository, and then syndicate that repository. The syndicated repository data will be saved as predefined type in the Ready folder of SAP MDM Server. (SAP MDM 5.5--> Server-->Distributions-->bp1bocap080.bp.co_MSQL--> BP3_PoC_Customer--> Outbound-->Siebel--> SIEBEL_OB_CUS_SIEBELCUS01--> Ready)

Process step in PI: Here you need to need specify the File Communication Channel Path as folder specified/created as in the MDM sever (i.e.,Outbound-->Siebel--> SIEBEL_OB_CUS_SIEBELCUS01 -->Ready) as per FTP Server configuration. The File Adapter picks up the file and then PI process starts. In the PI transformation and conversion happens and then sends the IDoc to the R/3Inbound port.

Process step in R/3: Here the IDoc receives to Inbound port and then IDoc is available in R/3.

I hope this blog will be useful for real time while integrating the same.

This content is reposted from the SAP Developer Network.
Copyright 2006, SAP Developer Network

SAP Developer Network (SDN) is an active online community where ABAP, Java, .NET, and other cutting-edge technologies converge to form a resource and collaboration channel for SAP developers, consultants, integrators, and business analysts. SDN hosts a technical library, expert blogs, exclusive downloads and code samples, an extensive eLearning catalog, and active, moderated discussion forums. SDN membership is free.

Want to read more from this author? Click here to read Bala Subbaiah Gorla's weblog. Click here to read more about Master Data Management (MDM) on SDN.

Dig Deeper on SAP UX

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.