Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 17, 2010 at 05:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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