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
What are the modes in which any update tasks work?
There is 1 person but it’s displaying that this person cannot be booked. He is not available for the business event. Can you tell me where is it going wrong? What can be the reasons? : sap abap hr
What are the aggregate objects in the dictionary? : abap data dictionary
When was the sap abap being created?
Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc
What are indexes? : abap hr
What is append search help? : sap abap data dictionary
In which cluster time results are stored? : abap hr
What are the page windows? How many main windows will be there in a page window?
What is dialog module?
Explain the types of bdc's?
What are spa/gpa parameters (sap memory)?
How to read 5th record from Hash Internal Table?
What are the user groups?
What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc