What is the difference between view and table ?

Answer Posted / vani pushadapu

view is a virtual table based on the result-set of an SQL
statement.

A view contains rows and columns, just like a real table.
The fields in a view are fields from one or more real
tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a
view and present the data as if the data were coming from
one single table.

Is This Answer Correct ?    76 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Reports: Event functionality.

891


What is step-loop? Explain all the steps?

544


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?

872


Sy index and sy tabix

968


What are the differences between a database index and a match code? : abap data dictionary

654






Explain the use of table maintenance allowed?

544


What are the buffering options in abap?

564


I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

1767


please any one can tell me How to validate the data in Table maintinance generator?how can u validate the table field values if u r entering the data into fields .it shows record is wrong?wher we can done validation in table maitenance generator before getting the data as out ?

1583


how to track records from data dictionary?

1655


What is the use of the raising exception? : abap modularization

517


What are screen painter? Menu painter? Gui status?

598


what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

1732


Can you delete data element, which is being used by table fields. : abap data dictionary

666


What is a matchcode?

597