Skip to Content
avatar image
Former Member

MDM basics

Hi All,

If any one of you have MDM architecure for materials master syndication please let me know . my company does not want to use any Middle ware system instead of standard idoc processing they want to go with LSMW . which is the best format to syndicate files (XML or XLS or TXT) .Please let me know ASAP .

can we get the data from MDM into MATMAS IDOC format ?

here is my company flow .

MDM -


> MDM SYNDICATOR ---> LSMW (to upload the data in to MDM) -


>R/3 system.

which is the best method to upload the data via LSMW?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 05, 2009 at 03:58 AM

    Hi Priya,

    LSMW can be a way out..But defianately not the best one as you may need to perform a whole lot of steps manually.As you will be required to syndciate the file in csv format so you will have to create the entire MATMAS IDOc structure by adding destiantion items and also map each field manually while if you use the standard idoc type then you can use the standard maps which will make your task easier.

    Better option is to use a middle ware like PI.Syndicate the file in XML format to the ready folder which in return will be picked up by PI, convert the XML into IDOC and post it back to R3.

    Hope it helps.

    Thanks,

    Minaz

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 05, 2009 at 04:59 AM

    Hi Priya,

    From MDM we can syndicate both XML and FLAT file to local system. The upload to R/3 via LSMW is a manual and tedious process.However if it is an one time activity then LSMW can be preferred. For uploading via LSMW, the excel files have to be syndicated from MDM syndicate manager. The automatic syndication and upload to R/3 can be achieved by auto syndicate feature of mdm and PI/XI (middleware)which is very convenient.If you need any doc or further help pls feel free to write.

    Regards

    Bis

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi guys,

      I don't want to use ABAP wrapper program or XI or LSMW . Is there any other approach to get the file as MATMAS idoc format from MDM ? I need to give this file EDI_DATA_INCOMING . Plesase let me know ASAP .

      Edited by: priya katragadda on Mar 12, 2009 6:00 PM

  • avatar image
    Former Member
    Mar 04, 2009 at 11:49 PM

    We cannot we get the data from MDM into MATMAS IDOC format directly, we definetly need middle ware to convert it the into IDOC format.

    LSMW is a generic approach for data extraction and migration.SAP has provided standard transaction like MDM_CLNT_EXTR to extract ECC master data and push it in to MDM.LSMW is not primarly used in this area.

    The following are the links for LSMW:

    http://www.sap-img.com/general/lsmw-steps-for-data-migration.htm

    http://www.scribd.com/doc/7151636/LSMW

    The MDM Syndicator exports record data to a file in either flat text or XML format.There are four basic steps to using the MDM Syndicator:

    u2022 Connect to a source MDM repository

    u2022 Define the map

    u2022 Select the records to syndicate

    u2022 Execute the syndication

    Please go through the following links for better understanding:

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8973bcaf-0801-0010-b7a7-f6af6b1df00e

    http://help.sap.com/saphelp_mdm550/helpdata/en/43/D7AED5058201B4E10000000A11466F/frameset.htm

    I hope this would be some help.

    Regards

    SR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2009 at 11:54 PM

    Priya,

    Another link for MDM Syndication:

    /people/harrison.holland5/blog/2006/11/27/mdm-syndication

    SR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 05, 2009 at 04:49 AM

    Hi priya,

    If you dealing with Material Master data in an ECC ERP system it is difficult to avoid Idocs.

    LSMW performs data extraction and migration mostly in Text format. And this text data cannot be uploaded in to ECC system for Material master creation.

    You will need the material data in an XML format so that it can be coverted to Idoc to fit in to material master tables and fields.

    If you want to avoid the use of XI in your landscape.You can use ABAP programming for XML to Idoc conversion.

    As LSMW output will be text,and plain text cannot be converted to Idoc and ECC system will accept only idoc.

    You can refer the below link to get some insight on the topic:

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/107fabbb-b8ca-2b10-04b5-8f34729ef228 (XML generation from Idoc)

    Hope It Helped

    Thanks & Regards

    Simona Pinto

    Add comment
    10|10000 characters needed characters exceeded