What are Views, how they were useful. Types of Views
- 2 Answers
- 11343 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / uma mb
Views are basically a join of two or more underlying
database tables. Certain tables are logically related and
make sense and more meaning when viewed linked together.
Instead os making these joins at runtime and increasing
overheads, views when existing can provide information
readily such as in Search Helps in data entry screens.
Another example is when there is a table with many fields
and it does not make a lot of sense to see all of them
together everytime, it is better we project only certain
columns that we want to see.
There are four types of views:
a) Database View (Generally used a a read only view)
b) Maintenance View (Used as a means to maintain the
underlying tables participating in the view)
c) Projection View (Single table view)
d) Help View (used in 'search helps' got by pressing F4)
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Can you set up background processing using call transaction?
What is the relationship existing between the various data elements? : abap data dictionary
What is protect & endprotect?
What is the difference between call transaction method and the session method? : abap bdc
Why do we use dynamic where conditions?
Define batch input session?
Did you use buffering?
please give the remaining answers.
Can a constructor be declared private? If yes then in which scenario?
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
How to get that a secondary index is attached to a select query?
How can we send data to external programs?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
What is the last entry in all bdc tables? : abap bdc
How the at-user command serves mainly in lists?
