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
Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
What is the difference between Classic badi and Kernal badi ?
How to create a button in selection screen ?
Explain the different types of mode (run code) in call transaction method?
What are the different types of laws. What are they?
How do you execute the payroll
In BDC, data transfer is done success in foreground mode but if we done the same in background mode it shows errors. What is the reason?
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
What is the use of table maintenance allowed?
what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me
What is value table?
What is the difference between getting and get late?
any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.
What does the extract statement do in extract datasets? : abap modularization
How to write a code for multiple transactions? : abap bdc