What are the table types?

[Former Member]

hi friends

please explain me the table types with examples

its urgent

[Former Member]

Hi Rao,

Please reward points also to all who has replied to your questions and read the new rules of engagement. You can not have more than 10 questions open on forum.

Please rewards to all users, its not fair to close the thread with good comments.

BR,

Alok

[Former Member]

Hi,

An MDM repository has multiple types of tables which are as follows:

1. Main Table and Subtables:

The standard tables include the main table and its subtables, that is, the tables related to it. These standard tables contain the actual master data. References from the main table to individual subtables

through lookup fields, that is, reference fields to other tables that connect the main table record and the subtable record, can be used

to model even complex data models in MDM.

For main tables and subtables, the following four table types exist in MDM:

a. Flat Tables

b. Hierarchy Tables

c. Taxonomy Tables

d. Qualified tables

Flat tables are the most common table. A main table is always of type flat.

Hierarchy tables display hierarchies in master data, such as product hierarchies, which are displayed in a tree menu. One example is an organisation chart, with branching between areas and departments.

Taxonomies are used to categorize or classify master data into coherent groups according to defined attributes, like product groups. For instance, a category u201Cbottlesu201D might automatically contain subcategories u201C1 liter bottles,u201D u201C1.5 liter bottles,u201D and so on, which can be used to form a uniform expression of the u201Cvolumeu201D attribute.

Qualified tables are used to show different variants in the relation-ships between main tables and subtables in a simple, highly efficient way. For example:

Suppose first customer pays a price of 5 USD per item for quantities between 1 and 100 items. From 101 to 200 items, he pays only 3.50 USD.

Second customer pays 5.50 USD for 1 to 100 items and 4 USD from 101to 200.

The qualifier (here, the price) is not just related to the record of the table in which it is stored, but also to the main table record to which it is connected.

2. Object Tables:

In MDM, there are special object tables that store objects separately by file type. The advantage of these external object tables is that an object can be referenced in multiple places.

Object tables are predefined by SAP and are delivered in their

required comprehensive structure. The fields are fixed and cannot be changed.

The following object types are supported:

a. Image files

b. Text blocks

c. HTML text

d. PDF files

e. Sound files

f. Video files

g. Binary files

3. Special Tables:

Special tables are used to represent additional repository and structure information. They are created automatically when a repository is created. The special tables include

a. Masks

b. Families

c. Image variants

d. Relationships

e. Workflows

f. Data groups

g. Validation groups

Families can be used to group together records, which have the same value or the same attribute in certain fields. The families table contains one record for each family.

The images object table are used used to attach images to a master record. Depending on the use of the master record, these images may have to comply with different criteria. For example, for a catalog generated from the MDM system, it is important to know whether it will be printed or published on the web.

Relationships table show the relations between master records and how the objects they represent are related to one another. These relationships can be of type parent/child or sibling.

The workflow table stores information on the workflows existing for Workflows this repository, for example, to which table the workflow refers. A reference to a workflow modeled in Visio is also stored, which defines how a certain group of records should be handled.

The data groups table is created automatically and is transparent to Data groups the user. This is where data groups are managed in which objects are organized in the MDM system.

4. System Tables:

The system tables are used for data protection and administration of the repository. Tables are:

1. Roles

2. Users

3. Logins

System tables also include the following descriptive tables:

1. Change tracking

2. Client systems

3. Ports

4. URLs

5. XML schemas

6. Reports

7. Logs

Roles are the permissions to insert, edit, delete, protect, or remove the protection from a record, or to group multiple records

together.

The users table is used to store information about the people who Users should have access to the repository, along with their roles.

For every repository, there is an Admin role created with all permissions.

In the logins table, there is an overview of which users are currently Logins accessing the repository and which client applications they are using to access it.

reports document all individual steps taken by MDM during the operation, and can be checked. A report is always relative to a special repository.

Ports are used to manage the connection between MDM and the

client systems.

XML schemas are intended for use in the Import Manager or Syndicator, that is, for import or export from the MDM system

The change tracking table is used to store changes to the data inventory of the repository.

The logs table is used to store all the log files for the current server.

Regards

Richa

[Former Member]

Hi Ram,

In MDM there are tables of different types: Main Table, Flat Table, Qualified table, Taxonomy table, Hierarchy table, family table, system tables,special tables and object tables. Functions of all the tables are given in very first chapter of MDM console reference guide. You will get a better understanding from there.

In every repo only one main table is there which holds you records for Supplier, Customer material etc.

Flat table is table to contain values which the main table record can choose from for its any field. Like countries is a flat table and it will be used by country field of main table for any country for a Supplier.

Qualified table is used for, say you can have multiple bank accounts for one person. These purposes are met using qualified tables.

Hierarchy tables are used to store hirarchy.

Taxonomy is used to store hierarchy along with some attributes linked to individual categories.

and so on...........

Hope this is helpful.

Regards,

Dheeraj.