Skip to Content
avatar image
Former Member

Mdm doc

Hi All

I am new in sap mdm ,and my background is sap xi ,now i started learn to MDM , So i am confused some basic mdm term like----

Syndicator

Console

Import manger

Data manager

And what is difference between Main table and lookup Table

Thanks

pankaj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 14, 2010 at 09:45 AM

    Hi Pankaj

    MDM console, Data manager, Import and Syndication Manager are the different components of SAP MDM.

    Apart from the above four components we also have servers like MDS, MDIS and MDSS. to get a proper understanding on different components and MDM scenarios please refe to the MDM wiki-

    http://wiki.sdn.sap.com/wiki/display/SAPMDM/SAPMasterData+Management

    You can also refer to help.sap.com which is a good start point-

    http://help.sap.com/saphelp_mdm300/helpdata/EN/2d/ca9b835855804d9446044fd06f4484/frameset.htm

    Diff between Main table and Looup table-

    If we take examples Master data objects in ECC are stored in multiple tables. Material has MARA/MARC/MVKE.. which is main table and the reference tables like Unit of Measures, Material Type, Group etc are modeled as Lookup tables in MDM.

    thanks-Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2010 at 01:59 PM

    Hi Pankaj,

    MDM Console, Import manger, Data manager and Syndicator are the MDM components.

    These are the four GUI tools (MDM Components) use for different Purpose.

    MDM Console: For Data Modeling, Adminstrator Right, Repostories operations like load, unload repsotories.

    MDM Import Manager: This GUI is use to import Data into MDM by connecting to Source, in this we have source structure and Target Structure for which we need to map source and Target fields and Values.

    Data Manager(Content Manager): This GUI tool is use to see all the data(records) imported through MDM import Manager. It can be also use to create data centrally Using Data Manager. Here, You can write Assignment, Validations and Match and Merging etc.

    Syndicator: This is a tool which is use to send Data Out of MDM in the XML or text file formats.

    Please refer below link for more understanding: Page 9-10/14

    http://hosteddocs.ittoolbox.com/RD021507b.pdf

    Main table & Lookup table: Main table is a table which contain Master data records like in R/3 we have Mara table, Lookup table are the tables which contains limited number of records and use in main table like in R/3 we have Countries, Regions table and also known as Refernce(Check) tables.

    Kindly revert if you still have any doubts else mark thread as answered.

    Regards,

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2010 at 04:18 PM

    Hi,

    I am new in sap mdm ,and my background is sap xi ,now i started learn to MDM , So i am confused some basic mdm term like

    Syndicator --> This tool is used for Syndicating Master data to legacy systems.(Ex: MDM to ECC, infterface will be XI)

    Console --> This tool is used for Data Model desigh, users & Roles creation. MDM Console allows system managers to administer and monitor MDM Servers, and to create, maintain the structure of, and control access to the MDM repositories.

    Import manger--> This tool is used for importing the data from legacy systems. we can import data in different file formats(Ex: XML, Excell, CSV e.t.c.

    Data manager--> This tool is used for serch, viewing & editing the data in the Repository.

    Main table --> A main table contains primary information about a business object such as a product or supplier.

    Look Up table -->To define the set of legal values to which a corresponding lookup field in the main table can be assigned. These tables hold the lookup information.

    EX: Countries look up table: MDM repository of Customer information may include a field called country; the actual list of allowed country names would be contained in a subtable.

    http://help.sap.com/saphelp_nwmdm71/helpdata/en/index.htm

    Hope this may help you,

    Thanks & Regards,

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2010 at 06:08 PM

    Hi Pankaj,

    The main role is:

    Console: Administration purpose

    Import Manager: We will write rules or check for condition before you import your master data from other systems.

    Data Manager: you can view or change master data

    Syndicator: Used to send master data to other systems.

    Main table is where your master data is located. Lookup table is where you have multiple values for the field like currency is a field but it might have values like USD, EUR, INR etc. So these values are stored in the lookup table. This is same like doing rfc or jdbc lookup for a field in xi.

    The best thing would be do a search in SDN and you have doucments on all these.

    Regards,

    Satish

    Add comment
    10|10000 characters needed characters exceeded