data dictionary

[Former Member]

hi frieneds,

can you tell me the definitions of domain,data element.database table.

[Former Member]

Hi,

Hi,

Domain provides technical attributes for field like data type, length, and possible value range.

Data element provides business context. i.e., it provides field labels for the field in the backend,

Data type :

A data element is an elementary type. It describes the type attributes (data type, field length and possibly the number of decimal places) and screen information (explanatory text or field help) about unstructured data objects (table fields and structure fields or variables).

Table fields and structure fields with the same contents should refer to the same data element. This ensures that the attributes of these fields are always consistent.

A data element can be referenced in ABAP programs with TYPE. This permits you to define variables that take on the type attributes of the data element in an ABAP program.

Domain :

A domain describes the technical attributes of a field, such as the data type or the number of positions in a field. The domain defines primarily a value range describing the valid data values for the fields referring to this domain.

Different technical fields of the same type can be combined in a domain. Fields referring to the same domain are changed at the same time when a domain is changed. This ensures the consistency of these fields.

Additional info about data element

1.Data type, number of places and possibly the decimal places were entered directly. In this case the field is not filled.

2.A data element is assigned to the field. The field then gets its data type, length and possibly decimal places from this data element. The semantic attributes of the element (field help, representation of the field in input templates with keyword text, column headers for list output of the table contents and editing of the output with parameter IDs) are also copied.

Originally, in database theory, a view is a read only virtual or logical table composed of the result set of a query. Unlike ordinary tables in a relational database, a view is not part of the physical schema: it is a dynamic, virtual table computed or collated from data in the database.

Regards

[seshatalpasai_madala]

HI,

Domain:

Is the data type that defines the technical details like the kind of data (Integer, character or floating etc) also it gives you details like the length of the data type.

Dataelement: Is used to create Data types using domains which will give you the meaning of the data type like EMPLOYEE_ID means an employee id where as its domain EMP_ID with type NUMC abd length 10.

Here domain just tells how the data needs to be stored in the database where as dataelement tells the semantic defination of the field.

Database table is grouping of some related information for example you can represet a bank account as a table as follows.

ACCOUNT_ID

ACCOUNT_HOLDER_NALE

DATE_OF_BIRTH

etc

etc.

so each row of this database table represets one bank account.

Regards,

Sesh

[Former Member]

hi varadarajan,

These are simple and understandable definitions for your question.

data element : definition of the properties and type for the table field. It is an intermediate object between the domain and the table field.

domain : Domain contains the technical characteristics of the field such as field length, data type and possible value ranges.

Table : Table is a 2D data matrix having rows and columns, rows contain data while column contains fields.

Regards...

Arun.

Reward points if useful.

[Former Member]

Hi,

<b>DOmain:</b> domain defines a value range. A domain is assigned to a data element. All table fields or structure components that use this data element then have the value range defined by the domain. The relationship between the field or component and the domain is thus defined by the data element of the field or component.

Fields or components that refer to the same domain (with the assigned data elements) are also changed when the domain is changed. This ensures that the value ranges of these fields or components are consistent. Fields or components that are technically the same can thus be combined with a reference to the same domain.

<b>Data Element</b>: Data elements in the ABAP Dictionary describe individual fields. They are the smallest indivisible units of the complex types described below, and are used to specify the types of columns in the database. Data elements can be elementary types or reference types.

TABLES: Tables can be defined independently of the database in the ABAP Dictionary. The fields of the table are defined with their (database-independent) data types and lengths.

When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAP Dictionary. The table definition is translated from the ABAP Dictionary to a definition of the particular database.

A table definition in the ABAP Dictionary contains the following components:

Table fields define the field names and data types of the fields contained in the table

Foreign keys define the relationships between the table and other tables.

Technical settings control how the table should be created in the database.

Indexes: To speed up data selection, secondary indexes can be created for the table

Regards

Sudheer

[Former Member]

The Domain specifies the Technical attributes of the field such as the data type, length and the value range.

The data element is an elementary type defining the description/text for the field when displaying on the screen and Parameter ID

regards

Suresh

[Former Member]

Hi,

Domain explains what type of data( size,characterisitic) you are storing .

Data element is more on how you will name this domain.

A real life example :

1) Think domain as a chocolate

2) And Data element as its wrapper.

chocolate is the actual content and the wrapper is just a description of the chocolate.

You can have same chocolate content covered by various wrappers ( by giving various brands ) according to the usage.

Database table

Table in which the Data is stored n maintained for further retrieval is called a database table.

Regards,

Priyanka.

[Former Member]

What is the function of a

Domain

?

· A domain describes the technical settings of a table field.

· A domain defines a value range, which sets the permissible data values for the fields, which refers to this domain.

· A single domain can be used as basis for any number of fields that are identical in structure.

What is the function of a

data element

?

A data element describes the role played by a domain in a technical context. A data element contains semantic information

The statistical values stored in the database catalog can be retrieved by ... For a definition of the statistics system tables,is called

database table

Girish

[Former Member]

hi,

domain--in which we can maintain the tecnical attributes of a field like data type,field length and optionally an output length.

data element--here, we can specify the semantic attributes of the field like domain name,labels for the field in diff lengths.after saving de u can specfy documentation in this.

database table--in which data is stored in rows and columns.

[Former Member]

hi,

Domain provides technical attributes for databse fields field like data type, length, and possible value range.

Data element provides symantic properties of database fileds. i.e., it provides field labels for the field in the backend.

database tables: contains data and resides at backend [ database server]

if useful reward some points.

with regards,

suresh.