regarding ddic

[Former Member]

hi,

lpz tell me what's the difference b/n DDIC table and DATABASE table

[Former Member]

hi

tables will be defined in the ddic and the actual table[ table with content ] wil be available in the databse table only.

you can say only the structure of the table is available in ddic.

also,

ddic is available in sap repository[ seperate mem location ].

database table is available in backend database.

ddic works in application server level.

database table in database server.

regards

mano

[Former Member]

hi,

The ABAP Dictionary permits a central management of all the data definitions used in the R/3 System.

In the ABAP Dictionary you can create user-defined types (data elements, structures and table types) for use in ABAP programs or in interfaces of function modules. Database objects such as tables and database views can also be defined in the ABAP Dictionary and created with this definition in the database.

Tables and database views can be defined in the ABAP Dictionary.

These objects are created in the underlying database with this definition. Changes in the definition of a

table or database view are also automatically made in the database.

Indexes can be defined in the ABAP Dictionary to speed up access to data in a table. These indexes are

also created in the database.

There are three different type categories in the ABAP Dictionary:

Data elements: Describe an elementary type by defining the data type, length and possibly decimal

places.

Structures: Consist of components that can have any type.

Table types: Describe the structure of an internal table.

Any complex user-defined type can be built from these basic types.

The ABAP Dictionary is actively integrated in the development and runtime environments. Each change takes immediate effect in the relevant ABAP programs and screens.

Examples:

When a program or screen is generated, the ABAP interpreter and the screen interpreter access the type definitions stored in the ABAP Dictionary.

The ABAP tools and the Screen Painter use the information stored in the ABAP Dictionary to support you during program development. An example of this is the Get from Dictionary function in the Screen Painter, with which you can place fields of a table or structure defined in the ABAP Dictionary in a

screen.

The database interface uses the information about tables or database views stored in the ABAP Dictionary to access the data of these objects.

A transparent table is automatically created on the database when it is activated in the ABAP Dictionary.

At this time the database-independent description of the table in the ABAP Dictionary is translated into

the language of the database system used.

The database table has the same name as the table in the ABAP Dictionary. The fields also have the

same name in both the database and the ABAP Dictionary. The data types in the ABAP Dictionary are

converted to the corresponding data types of the database system.

Hope this helps, Do reward.

[Former Member]

Hi,

-->Tables and database views can be defined in the ABAP Dictionary.

Definition

A data dictionary is a central source of information for the data in a data management system. Its main function is to support the creation and management of data definitions (or "metadata”)

Functions

Management of data definitions

Provision of information for evaluations

Support for software development

Support for documentation

Ensuring that data definitions are flexible and up-to-date

Regards

ArchanaRaghunathan

[Former Member]

Hi,

DDIC is nothing but where u create the table structure kno...in sql v directly write code to create a databasetable but here we u DDIC to create DBtable .

when create it in se11 the structure is only created and when u save it only then the same structure is created in database... it is nothing but carbon copy of DBtable......what ever changes u make in DDIC it 'll reflect in DB.... only with the help of DDIC u can make changes and modify tables in DB... it is a GUI for DB.

Thanks,

Arunprasa.P

Reward if useful.

[Former Member]

hai VISHAL THAKUR,

Data Dictionary Contains Metadata.

where as database contains all the data.

so ddic table means it will have only metadata.

whereas Database table contains all the data related to that table.

Regards.

Eshwar.

[Former Member]

HI,

database table : The Table has a physical storage of data and this is the table where actual data is stored.

-->through ABAP DDIC we can get the data from avtual database.

-->ABAP Data Dictionary centrally describes and manages all the data definations used in the system. The ABAP dictionary is completly integrated in the ABAP workbench. All the other components of the workbench can actively access the definations stored in the ABAP dictionary.

ABAP Dictionary stores :

1. Tables

2. Views

3. Types

4. Domains

5. Search Helps

6. Lock Objects

In the development environment or projects objects of the ABAP dictionary can be changed any number of times before activated and made available to the operative components of the system. Objects can have both active and nonn active version in the ABAP dictionary at the same time.

Inactive ABAP Dictionary objects have no effect on the runtime system. The objects can only be activated together when they have all been changed.

Transaction Codes for ABAP Dictionary.

SE11 - Data Dictionary

regards,

vineela.

[Former Member]

Hi Vishaal,

I would like to make you clear that DDIC is a development tool in ABAP used to create tables and the tables get created in the database and are called database tables.

Thanks & Regards,

AMK.

REWARD POINTS IF USEFUL.

[Former Member]

hi,

A ddic table represents a table description as part of a table declaration or table definition.user data can be stored when a database table has been created using a ddic table.

The database table represents the data definitions or the specific data object.

Regards,

Rajyalakshmi.A

[Former Member]

The ABAP Dictionary, part of the ABAP Workbench, allows you to create and administer database tables. Open SQL contains no statements from the DDL part of Standard SQL. Normal application programs should not create or change their own database tables.

The ABAP Dictionary uses the DDL part of Open SQL to create and change database tables. It also administers the ABAP Dictionary in the database. The ABAP Dictionary contains metadescriptions of all database tables in the R/3 System. Only database tables that you create using the ABAP Dictionary appear in the Dictionary. Open SQL statements can only access tables that exist in the ABAP Dictionary.

The ABAP Dictionary centrally describes and manages all the data definitions used in the system. The ABAP Dictionary is completely integrated in the ABAP Workbench. All the other components of the Workbench can actively access the definitions stored in the ABAP Dictionary.

The ABAP Dictionary supports the definition of user-defined types (data elements, structures and table types). You can also define the structure of database objects (tables, indexes and views) in the ABAP Dictionary. These objects can then be automatically created in the database with this definition. The ABAP Dictionary also provides tools for editing screen fields, for example for assigning a field an input help (F4 help).

The most important object types in the ABAP Dictionary are tables, views, types (data elements, structures, table types), domains, search helps and lock objects.

DATABASE:

In the R/3 System, long-life data is stored in relational database tables. In a relational database model, the real world is represented by tables. A table is a two-dimensional matrix, consisting of lines and columns (fields). The smallest possible combination of fields that can uniquely identify each line of the table is called the key. Each table must have at least one key, and each table has one key that is defined as its primary key. Relationships between tables are represented by foreign keys

SQL (Structured Query Language) is a largely standardized language for accessing relational databases. It can be divided into three areas:

Data Manipulation Language (DML)

Statements for reading and changing data in database tables.

Data Definition Language (DDL)

Statements for creating and administering database tables.

Data Control Language (DCL)

Statements for authorization and consistency checks.

Each database has a programming interface that allows you to access the database tables using SQL statements. The SQL statements in these programming interfaces are not fully standardized. To access a specific database system, you must refer to the documentation of that system for a list of the SQL statements available and their correct syntax.

To make the R/3 System independent of the database system with which you use it despite the differences in the SQL syntax between various databases, each work process on an application server has a database interface. The R/3 System communicates with the database by means of this interface. The database interface converts all of the database requests from the R/3 System into the correct Standard SQL statements for the database system. To do this, it uses a database-specific component that shields the differences between database systems from the rest of the database interface. You choose the appropriate layer when you install the R/3 System.

To access DataBase we use OpenSQL & Native SQL.

Reward if Helpful.

Iyswarya

[former_member230674]

Hai vishal takur,

There is a clear and simple diffrenece between the Data Dictionary(DDIC) and Database table.

Data Dictionary - manages all data definitions used in the system but not the data.

Here data definitions means , the details of objets defined in the data dictionary like tables, structures,views,locks,indexs and matchcodes.

For example, if you are taking a table,

the data definition stores the details of

name of the table,

name of the field,

length of the field,

type of the field.

These are forming data definition (meta data) of that table.

In the database,

it stores only data.

Database - It consists of data.

if you feel it is useful,

reward the points.

Thank you,

prasad g.v.k