Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and table ?
- 13 Answers
- 74665 Views
- Deloitte, Renault Nissan, I also Faced
- E-Mail Answers
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
Does the table can have multiple foreign keys?
What are the differences between se01, se09 and se10?
1. If I send 5 entries of table from one system to another system, if the only 4 entries there in the target system what I have to do? 2. If I send the customer master IDOC from one SAP system to another system, if one field is missing in target table what is the steps? 3. If I want to access the 4th row 3rd column in the hashed table how to do it? 4. Whether there is any other statement than MODIFY statement to modify the content of internal table?
Did you create any joins?
What is append search help? : sap abap data dictionary
Concepts of OO ABAP and why we are using it?
what is a text table ?
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 is the use of message command in a report? What are the different message types?
What are the advantages of abap query tool?
What is a logical database?
Which function module would you use to check the user’s authorization to access files before opening a file?
How would you define the exponents for a type ‘f’ field?
What are the two ways for restricting the value range for a domain ?
What is the use of the statement leave to list-processing?
