Difference

[Former Member]

Hi All,

What is the difference between transparent table and view?

Thanks & Regards,

<b>Anil Kumar</b>

[RaymondGiuseppi]

Hi Anil, look at <a href="http://http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf">BC - ABAP Dictionary</a>

<b>Tables</b>

<i>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.</i>

<b>Views</b>

<i>Data about an application object is often distributed on several tables. By defining a view, you

can define an application-dependent view that combines this data. The structure of such a view is

defined by specifying the tables and fields used in the view. Fields that are not required can be

hidden, thereby minimizing interfaces. A view can be used in ABAP programs for data selection.</i>

Regards

[Former Member]

Hi

<b>Name of an SAP table view, 16 characters</b>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.

In the simplest case, this derivation process can involve simply suppressing the display of one or more fields from a table (projection) or transferring only certain records from a table to the view (selection). More complicated views can be assembled from several tables, with individual tables being linked using the relational join operation.

Use

Logical views for the application permitting direct access to the data can be generated with the definition of view. The structure of such a view is defined by specifying the tables and fields involved in the view.

<b>Database table</b>

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

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

Table fields: The field names and the data types of the fields contained in the table are defined here.

Foreign keys: The foreign keys define the relationships between this table and other tables.

Technical settings: The technical settings define how the table is created on the database.

Indexes: Indexes can be defined for the table to speed up data selection from the table.

There are three categories of database tables in the ABAP Dictionary.

<b>

A physical table definition is created in the database for the table definition stored in the ABAP Dictionary for transparent tables when the table is activated. The table definition is translated from the ABAP Dictionary to a definition of the particular database.</b>

On the other hand, pooled tables and cluster tables are not created in the database. The data of these tables is stored in the corresponding table pool or table cluster. It is not necessary to create indexes and technical settings for pooled and cluster tables.

reward if usefull