topic Re: view table vs standard table in Application Development and Automation Discussions

view table vs standard table

Former Member — Fri, 05 Jan 2007 01:32:13 GMT

Hi,

i am new to abap programming, i want to know which table are always to use in real environment? view or standard table?

Besides, any reference book has specify all sap table, view, function etc.

Thanks.

Re: view table vs standard table

Former Member — Fri, 05 Jan 2007 01:50:27 GMT

Depends on your requirement. Sometimes if SAP views are available, it may make sense to use them to improve performance. Most of the time , we end up going against tables.

Please chekc this link for the list of standard tables.

http://www.erpgenie.com/abap/tables.htm

Re: view table vs standard table

gopi_narendra — Fri, 05 Jan 2007 02:27:51 GMT

Most of the time we come accross Transparent tables in our day to day scenario.

views are logically a combination of one or more tables. the view is not physically stored ,it is being derived from one or more tables. view is basically a join of tables.

Regards

- Gopi

Re: view table vs standard table

Former Member — Mon, 08 Jan 2007 16:47:17 GMT

If you need info from one table....Use a Standard Table...If you need to read info for two or more tables, use a View.

Both Transparent Tables and Views can be viewed and created on TX. SE11.

Greetings,

Blag.

Re: view table vs standard table

Former Member — Wed, 10 Jan 2007 11:53:14 GMT

hii thr,

standard tables are always there but it depends upon your requirement what you want,you can always select data from tables but if the no of tables,fields and data is large it becomes a performance issue,veiws are very helpful in such cases there are 3 types of views have a look,please reward points if of any use to you,

The followings are different types of views:

- Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

- Help View ( SE54)

Help views are used to output additional information when the online help system is called.

When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

- Projection View

Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.

A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.

- Maintenance View ( SE54 )

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.