topic Re: ABAP DICTIONARY in Application Development and Automation Discussions

ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:18:01 GMT

what is the difference between a database table and a view in the abap dictionary?

Re: ABAP DICTIONARY

p291102 — Fri, 23 Nov 2007 08:19:57 GMT

Hi,

table can hold records but view is only meant for display .

view can be from one table or from combination of multiple .

If you need certain fields of the table or combination of fields from more than one table or entries from one table such that those entries exist in another table, u can use databse view.

This will work simply as a select query on the database,

Thanks,

Sankar M

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:22:23 GMT

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.

Data from several tables can be combined in a meaningful way using a view (join).

You can also hide information that is of no interest to you (projection) or only display

those data records that satisfy certain conditions (selection).

Database views implement an inner join. You only get those records which have an

entry in all the tables included in the view.

in views db modifications are not possible

views only contain data at run time

when they consult the database

in case of views the join definitions are already sstored in the database itself

whereas join as open sql is a query to oracle database as similar select statements

Views are optimized by SAP and stored in the repository while Joins

are in reports that needs to be compiled at every execution

Reward if helps

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:23:03 GMT

its the same as it is in any other database system.

a table holds records, a view is a window to a table....

in abap dictionary, you can club multiple tables based on join conditions in a view to show data from multiple tables.

regards,

Priyank

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:25:16 GMT

A database table is the central data structure of the ABAP/4 data dictionary.

The structure of the objects of application development are mapped in tables on the underlying relational database.

The attributes of these objects correspond to fields of the table.

A table consists of columns (fields) and rows (entries). It has a name and different attributes, such as delivery class and maintenance authorization.

A field has a unique name and attributes; for example it can be a key field.

A table has one or more key fields, called the primary key.

The values of these key fields uniquely identify a table entry.

You must specify a reference table for fields containing a currency (data type CURR) or quantity (data type QUAN). It must contain a field (reference field) with the format for currency keys (data type CUKY) or the format for units (data type UNIT). The field is only assigned to the reference field at program runtime.

A view is a logical view on one or more tables, that is, a view is not actually physically stored, instead being derived from one or more other tables.

The data of a view can be displayed exactly like the data of a table in the extended table maintenance.

Data for an application object is often distributed on several database tables. Database systems therefore provide you with a way of defining application-specific views on the data contained in several tables. These are called views.

Data from several tables can be combined in a meaningful way using a view (join). You can also hide information that is of no interest to you (projection) or only display those data records that satisfy certain conditions (selection).

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.

The ABAP Dictionary supports program development with a number of services:

Input helps (F4 helps) for screen fields can be defined with search helps.

Screen fields can easily be assigned a field help (F1 help) by creating documentation for the data element.

An input check that ensures that the values entered are consistent can easily be defined for screen fields using foreign keys.

The performance when accessing this data can be improved for database objects (tables, views) with buffering settings.

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:28:37 GMT

View is better than table.

Using View u can avoid extra codings in ur program(u can avoid Joining conditions in program).

Also View has faster access.

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:36:48 GMT

A one-line punch statement is....

DATABASE TABLE HOLDS PHYSICAL DATA

VIEWS DOESN'T HOLDS PHYSICAL DATA, ONLY AT RUNTIME DATA WILL BE LOADED INTO IT...

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:51:00 GMT

Hi,

A table can have data independently and view is independent on the table.

A table can hold data about itself, but a view can have data from more than one table.

Thanks,

Sriram Ponna.

Re: ABAP DICTIONARY

Former Member — Fri, 23 Nov 2007 08:54:36 GMT

View is a program to fetch data from 1 or more database tables and show in screen, database tables holds actual values