MDM-XI-R/3 integration

MDM-XI-R/3 integration

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
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
How?
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

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Two - Create Port for Client System
How?
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.


This was first published in October 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.

    Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

    Back to top