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 differences between the table and the structure in the data dictionary in the sap abap?
How we format the data before before write statement in report ?
What is the syntax for call transaction? : abap bdc
Why do we use types statement in abap programming?
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?
Can i Have Some Realtime Examples on Badi ?
What is the difference between pnp and pnpce? : abap hr
Which transaction code can I used to analyze the performance of ABAP program.?
What are the different function modules used in sapscript?
Hat are the different types of mode (run code) in call transaction method?
What are field groups?
Name the function module used to convert logical file names to physical file names in abap/4 programs?
Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh
What are the events driven batch jobs?
Explain what are the events used in interactive reports?