Data Import from SAP R/3 to SAP MDM 7.1 without SAP PI

[Former Member]

Hi All,

I have a requirement to import Vendor Master data from SAP R/3 to SAP MDM 7.1 on a regular basis. What are the Options available for data transfer between these two systems without any middleware(like SAP PI,etc). I checked the SAP Documentation and found the scenarios with SAP PI as middleware.

I have few very basic ideas:

1) Will there be any way for SAP MDM to pick a file from certain location and load the data..

2) Shall I use MDM ABAP API to write a program to connect to MDM Repository and schedule this at regular intervals to achieve the data transfer.

Pls suggest the best design approach..

Thanks in advance.

[Former Member · Accepted solution]

1) Will there be any way for SAP MDM to pick a file from certain location and load the data..

ANS : No, MDM will not pick up the file, file can be pick up from MDM Inbound folder and send from outbound folder for automize process and for MDM manual Process you can pick up and send file to local desktop, network shared path

2) Shall I use MDM ABAP API to write a program to connect to MDM Repository and schedule this at regular intervals to achieve the data transfer.

ANS : require to write code at ABAP side

so ABAP program will pick or send data file to MDM folder

Note following point

1. Require to write ABAP Program which will pick or send data file to MDM outbound / Inbound folder

2. Require to do some technical setting for ABAP program at SAP side, technical person will help regarding this matter

Note : There are many disadvantage and time consuming procss, monitoring file and it is not advisable to go without any intermidiate software for e.g PI, Tibco

Thanks,

Jignesh Patel

[Former Member · Accepted solution]

Thanks Jignesh..

Will placing a XML file(Collecting the Idocs from SAP to XML) with vendor info into the inbound folder of MDM work...

What would be the steps after placing the file in the inbound folder of MDM.

Appreciate your time..

Thanks.

[Former Member · Accepted solution]

Hi,

There is no need to do anything after placing the file in the inbound folder.

Just make sure that your MDIS is running and you are putting the file in right inboundfolder and in right structure .

The structure of file will be same with xsd that you assigned to that inbound port.

Thanks,

Sudhanshu

[Former Member · Accepted solution]

Hi Sethuram,

Follow this and convert the idocs into xml format.

http://www.erpgenie.com/sap/sapedi/Conversion%20of%20IDOCs%20to%20XML%20format.pdf

While configuring the directory give the inbound folder. But you need to make sure that the inbound folder is shared and NFS mounted in the network. Then you need to map accordingly. This would be little tedious to map if you customize further. If you have any middleware which can handle for you your life would be easy. You can follow sivas approach in this thread and get the schema for the idoc:

Regards,

---Satish

[Former Member · Accepted solution]

Hi Sethuram,

What would be the steps after placing the file in the inbound folder of MDM.

Ans: Follow the Step

1. Select the port in MDM Console

2. Assign Map & Processing Type = "Automatic"

3. Start MDM Import Server through Auxiliary Server with correct username & password

File will pick up automatically from inbound ready and transfer to archive folder and data get updated to repository

and you can check the data in MDM Data Manager

Thanks,

Jignesh Patel

[Former Member · Accepted solution]

Yes this will work provided yu have followed the required steps for setting the import automatic in MDM by defining the port and assigning an import map.

However might not be the preferred way as we lose on multiple fronts-

1. Error handling

2. Monitoring of the messages and reposting if required.

3. Security concerns- XML files to be written in the Inbound folders without FTP? Pls check if this is permitted in 7.1

4. Building mapping rule repository for synchronous data flow

5. ........

hope this helps-Ravi