data dictionary

[Former Member]

hi experts,

i have a doubt like

1. is there any difference between datadictionary and database.

please reply

its troubling me

bye,

[Former Member]

DDIC(Data dictionary) is the SAP term, thru which we can do access to Creation/change/display of of a table and all Database related stuff.

if you create a table in DDIC, the same table space also created at Database level.

the advantage of DDIC in SAP is, the definition what we give at SE11 will be converted to SQL statement based on the underlying database.we no need to think of what actual database is.

Database is the actual DB where the actual tables definition & its attributes & values stored.

further info

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

regards

srikanth

Message was edited by: Srikanth Kidambi

added some documentation

Message was edited by: Srikanth Kidambi

[RichHeilman]

Yes, there is. The data dictionary is a tool that we use on the application server which includes table definitions, structures, data elements, domains, search helps, etc. The database is the underlying software which mananges the data in its tables. For example, the database can be DB2, Oracle, SQL, etc. But the data dictionary will always function the same way no matter what the db is. When you create a transparent table using SE11(dictionary), when you activate it, the system will automatically create the database table in the underlying database. This means, that we(as developers) never really have to interact with the underlying database.

Regards,

Rich Heilman