Extraction of Data from SRM Server into MDM

[Former Member]

Hi Everybody,

Using Generic Extractor(MDMGX) we are able to extract reference data from SRM server.

How we can extract data from backend r/3 of SRM into MDM?

Is it necessary to extract reference data from backend r/3 of SRM or only from SRM server will suffice?

Can neone plz explain about extraction of master data from SRM Server to MDM? Master data of SRM is present in SRM server or Backend R/3 of SRM?

We have the Master data extractor MDM_CLNT_EXTR & we know that we have to use ABAP Proxy.

But plz tell us the detailed procedure ASAP.

Edited by: Madhurim Basu on Jun 4, 2008 8:02 AM

Edited by: Madhurim Basu on Jun 4, 2008 8:06 AM

[Former Member]

Hello Madhurim,

We have the Master data extractor MDM_CLNT_EXTR & we know that we have to use ABAP Proxy.But plz tell us the detailed procedure ASAP.

As per your requirement, Here is the step by step process:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/50260ae5-5589-2910-4791-fc091d9b...

I am sure that it will surely help you.

Also refer the SAP Note: 1035601

Reward if found useful.

TNR,

Saurabh...

Edited by: Saurabh Kumar Sahu on Jun 4, 2008 12:15 PM

Edited by: Saurabh Kumar Sahu on Jun 4, 2008 12:44 PM

[Former Member]

Hi Mandeep whatever you said are correct but we have done this already.We are using MDMGX & MDM_CLNT_EXTR and extracting lookup & master data resp.But whatever new thing you said is the use of the reports in mysap srm,when we run those reports the data gets extracted but where does it go?We cant understand.you said it goes to SRM-MDM what does that mean?if its going through XI (I am a XI consultant) then xi-ftp-MDM this connection happens but if we use the reports where does the data go?

also if we use XI I know that I hav to apply some standard PI content tpz files in XI then I have to write ABAP Proxy but can u tell the entire procedure?

[Former Member]

Hi Madhurim,

SRMMDM nothing but your Repository name, i mean MDM.

Scenario is like this:

SRM (using transaction as i said (BBP_CCM_TRANSFER) etc / ERP R/3 Beckend System -

---

(PROXY)-> PI -

---

(FTP, COMM CHANNELS)-> MDM (SRMMDM -- REPOSITORY NAME)

As I said SAP has Provided standard PI content which you can download from Service Market Place .

A) SETTINGS REQUIRED , SLD CONNECTIONS

1. DEFINING TECHNICAL SYSTEM FOR SRM SERVER, MDM AND SAP PI

2. CREATING BUSINESS SYSTEM FOR SRM, PI and MDM

B)CONFIGURING SETUP FOR ABAP PROXIES: IN SRM SYSTEM T-CODE SM59, SXMB_ADMIN ETC.

C)IMPORT OF PI BUSINESS CONTENT FOR SRM-MDM CATALOG IN INTEGRATION REPOSITORY

D)CONFIGURING SCENARIO CREATION FROM INTEGRATION SCENARIO SRM-MDM CATALOG IN INTEGRATION DIRECTORY, ALSO FOR DEFINING INTERFACE CONDITIONS SEE SAP NOTE 1057316

Hope it will Help you,

Rewards if Useful......

Mandeep Saini

[Former Member]

Hi Madhurim,

It is always a best practice to populate lookup table records before Populating Main table Records, So after lookup table records using transaction MDMGX, Populate the Master Data Records.

See SAP Note 964991 for refernce lookup data

Is it necessary to extract reference data from backend r/3 of SRM or only from SRM server will suffice?

its not compulsion but you can extract the reference data from both the sytems, like in SRM-MDM Catalog, lookup table LT_PurchasingOrganistions is not get populated from SRM -Server alone, so we use R/3 Beckend ERP Sytem to fetch data

for this reference data LT_PurchasingOrganistions. if the Edit Key Mappings for your Refernce look up tables are enabled you can check data by edit key mappings is it filled from ERP or SRM or Both.

Transaction MDM_CLNT_EXTR is use to Populate Material extraction , Customer Extraction etc. the use of this transaction depends what kind of Data you are extracting.

I feel, you can use standard Business Content For SRM-MDM Catalog which is avilable on Service Market Place.

To download Business Content : https://service.SAP.com/swdc

Navigate to Support Packages and Patches --> SAP Application Components --> SRM Catalog --> SRM-MDM CATALOG 2.0 and download the Business Content for SRM-MDM Catalog

In which we use Both SRM-Server and Beckend R/3 ERP sytem because Some fields get Populate from SRM-Server and Some from R/3 ERP System.

As SAP has provided Standard Transactions

To send product data from the SRM system to the SRM-MDM , you start the report BBP_CCM_TRANSFER_CATALOG (transaction

BBP_CCM_TRANSFER) in mySAP SRM.

● To send contracts from the SRM system you

start the report SRMMDM_CTR_TRANSFER (transaction

SRMMDM_CTR_TRANSFER) in SRM.

● To upload suppliers from the SRM system to the SRM-MDM Catalog repository, you start the report ROS_SUPPLIER_SEND_TO_CATALOG in mySAP SRM.

See SAP NOTE 1057316

Also SAP has Provided Standard PI Business content using which you can send Data From SRM to MDM.

Hope it will Help you,

Rewards if Useful......

Mandeep Saini