cancel
Showing results for 
Search instead for 
Did you mean: 

what are the differnet type of tables in mdm ?

Former Member
0 Kudos

hi experts i am new to mdm. just i have refered some documents in that the have created some table and fileds ,taxnomy,lokups,.......

so can any one give me the bref ida on

what is mdm ?

what are the different type of tables in mdm ? What is the requirement for the selection of table?

what is a feld ? what are the diff type of fealds in mdm ? And requriement ?

what is taxnomay ? And Requriement or where or when we can use ?

what is lookups in mdm ? what is lookup tables in mdm ?

what is mdm console ?

what is mdm data manager. ?

what is mdm import manager ?

what is mdm syndicator ?

....

please any body answer this questions .

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Praveen,

There are five type of tables in MDM

1.Flat

2.Hierarchy

3.Taxonomy

4.Qualified flat

5.Families

There are different types of fields like

integer

boolean

text

currency

Literaldate etc.

For more information follow the links:

http://help.sap.com/saphelp_mdmgds55/helpdata/en/88/9f9c427055c66ae10000000a155106/frameset.htm

Regards,

Vinay Yadav

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Praveen,

Below are the the all possible links of books,articles... etc for MDM.

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

demo

http://www.sap.com/community/int/innovation/esoa/demo/MDM_demo/index.html

http://www.asug.com/DesktopModules/Bring2mind/DMX/Download.aspx?TabId=66&DMXModule=370&Command=Core_...

MDM

http://www.asug.com/DesktopModules/Bring2mind/DMX/Download.aspx?TabId=66&DMXModule=370&Command=Core_...

SAP Netweaver MDM Overview

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b09b548d-7316-2a10-1fbb-894c838d...

SAP NETWEAVER MDM Leverage MDM in ERP Environments - An Evolutionary Approach -

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/4059f477-7316-2a10-5fa1-88417f98...

Master Data Management architecture patterns

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0703sauter/

MDM and Enterprise SOA

http://www.saplounge.be/Files/media/pdf/Lagae---MDM-and-Enterprise-SOA2007.10.10.pdf

Effective Hierarchy Management Using SAP NetWeaver MDM for Retail

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ee0c9e-29a8-2910-8d93-ad34ec8a...

MDM World

http://mdm.sitacorp.com/

MDM: Master Data for Global business

http://www.sitacorp.com/mdm.html

MDM Master Data Management Hub Architecture

http://blogs.msdn.com/rogerwolterblog/archive/2007/01/02/mdm-master-data-management-hub-architecture...

Improve Efficiency and Data Governance with SAP NetWeaver MDM

http://www.sapnetweavermagazine.com/archive/Volume_03_(2007)/Issue_02_(Spring)/v3i2a12.cfm?session=

Data Modeling i MDM

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d4211fa-0301-0010-9fb1-ef1...

http://www.sap.info/public/INT/int/index/Category-28943c61b1e60d84b-int/0/articlesVersions-31279471c...

SRM-MDM Catalog

http://help.sap.com/saphelp_srmmdm10/helpdata/en/44/ec6f42f6e341aae10000000a114a6b/frameset.htm

http://events.techtarget.com/mdm-ent/?Offer=DMwn716mdm

http://viewer.bitpipe.com/viewer/viewDocument.do?accessId=6721869

http://searchdatamanagement.bitpipe.com/data/search?site=sdmgt&cr=bpres&cg=VENDOR&sp=site_abbrev%Asd...DataManagement

http://viewer.bitpipe.com/viewer/viewDocument.do?accessId=6721819

http://www.dmreview.com/channels/master_data_management.html

http://searchdatamanagement.techtarget.com/originalContent/0,289142,sid91_gci1287620,00.html?bucket=...

MDM Console -- http://help.sap.com/saphelp_mdmgds55/helpdata/en/88/9f9c427055c66ae10000000a155106/frameset.htm

MDM Import manager --http://help.sap.com/saphelp_mdmgds55/helpdata/en/43/120367f94c3e92e10000000a1553f6/frameset.htm

MDM DataManager --http://help.sap.com/saphelp_mdmgds55/helpdata/en/43/e0615a82b40a2ee10000000a11466f/frameset.htm

MDM Syndicator --http://help.sap.com/saphelp_mdmgds55/helpdata/EN/43/5fe0e8a55f5f6be10000000a1553f6/frameset.htm

Rgds

Ankit

Former Member
0 Kudos

Hi Praveen,

There are five type of tables in MDM

1.Flat

2.Hierarchy

3.Taxonomy

4.Qualified flat

5.Families

There are different types of fields like

integer

boolean

text

currency

Literaldate etc.

SAP PRESS. SAP-Wissen aus erster Hand.

sofort lieferbar

Weitere Infos zum Buch

Lesen Sie auch:

1 Introduction

(aus: Kapitel 1 Introduction)

8.1 Architecture in Detail

(aus: Kapitel 8 MDM: Technical Details)

8.2.1 Table Types

(aus: Kapitel 8 MDM: Technical Details)

8.4 MDM Data Manager

(aus: Kapitel 8 MDM: Technical Details)

C The Authors

(aus: Kapitel C The Authors)

Auszug aus:

SAP NetWeaver Master Data Management

8.2.2 Field Types and Options

8.2.2 Field Types and Options

Field types specify which value ranges (for example, purely numeric, integer, alphanumeric values, etc.) may be used by a field. The variety of field types and their properties can already model a large amount of logic, which sets an MDM repository apart from a conventional database. These field properties impose a series of limitations on creation and processing, which can already be semi-covered by master data specifics.

Data Types for Fields

MDM supports the field types listed in Table 8.1.

Table 8.1 Field Data Types Field Data Type

Description

Text

Text field with less than 4,000 characters

Text Large

Text field with more than 4,000 characters

Text Normalized

Text field from which all non-alphanumeric characters should be removed. Can be used, for instance, for better searching.

Name

Text field with a structure appropriate to names (e.g., first name, middle name, last name)

Integer

Whole number, 4 bytes in length

Real

Floating point number, 4 bytes in length

Real8

Floating point number, 8 bytes in length

Boolean

Yes/no field

Log

Field of type Text Large with predefined structure for multiple blocks with timestamps

AutoID

Field of type Integer, which automatically counts up by one

Currency

Field of type Real8, which includes a freely definable currency symbol

GM Time

Field of type Time Stamp, which is relative to a special time zone

Measurement

Field of type Real to which a measurement unit is attached. MDM currently supports more than 750 units of measurement and allows simple conversion from one unit to another. For user-defined units of measurement beyond the standard ones, the application MDM standard ones, the application MDM Unit of Measure Manager (UOM) can be used.

Literal Date

Date field

Literal Time

Time field

Create Stamp

Field of type Time Stamp, which is automatically populated with the current date and current time upon creation of a record

Time Stamp

Date and timestamp field, which is automatically updated on each change to a record

User Stamp

Field in which the code of the user who changed a record is stored

Mask

Field in which a subset of the master records is stored. This field is not visible; it is used only for searches.

Lookup

For table types Flat, Hierarchy, Taxonomy, Qualified, Image, Text Block, Text HTML, PDF, Sound, Video, and Binary Object

For more information follow the links:

http://help.sap.com/saphelp_mdmgds55/helpdata/en/88/9f9c427055c66ae10000000a155106/frameset.htm

This is a link to create repository:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8066a6f5-9b01-2b10-0290-97445c7b...

For DBMS Settings:

http://help.sap.com/saphelp_mdmgds55/helpdata/EN/42/ea053837f33ee9e10000000a1553f7/content.htm

Regards,

Vinay Yadav

Former Member
0 Kudos

hi vinay yadav thank very much for your repaly

you have any doc or books on mdm plese mail me praveen.sapmdm@gmail.com

Edited by: g.praveen kumar on Jun 5, 2008 7:08 PM