What is the difference between view and table ?
Answer Posted / baskar
VIRTUAL is an important word to be used that matches for
defining a VIEW. View just holds a pre-compiled query which
pulls records from a table or combination of joined tables.
A view can also be used to query which can then be used in a
view. So to define, A VIEW is a virtual representation of
data from real tables/views which is pre-compiled and
secured. The retrieval of records would be quicker in a view
than a table based query. The main usage of view is to hide
few columns from the table which you may not want to share
with the users who wants only the required and relevant data.
TABLE is a normal real time table which really hold data in
the database.
Functionality wise, we may not pass variables in a view and
order by clause cannot be used in a view.
Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
Explain the properties of selection screen?
I am uploading 100 records out of which say 59th record has error so what will happen if I am using synchronous or asynchronous method of bdc? Can we update the database using local update mode how? : abap bdc
Explain the sequences of event block?
What are the page windows?
Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.
Difference between domain and data element? What are aggregate object?
What is new enhancement framework?
What are internal tables? How do you get the number of lines in an internal table?
What are field symbols?
What is human resource information systems (chris)? : sap abap hr
How do you Export a session ?
What is evaluation path, where do we do it and why? : sap abap hr
Can we make use of flow logic control key words in abap/4 and vice-versa?
Is it possible to pass data to and from include programs explicitly? : abap modularization
What data is contained? : abap data dictionary