What are Views, how they were useful. Types of Views
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
How can we decide weather we can enhance the standard infotype or not ? : abap hr
What are the different software packets available in the market? : sap abap hr
How to know if the value entered contains records or not?
What is client in the sap system? : sap abap hr
What is read line in abap?
Why do we use Abstract classes give an example from your project?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subarc after perform?
Performance tuning techniques
What is bdc? : abap bdc
What are the functional areas, user groups? How does abap query work in relation to these?
In delivery processing which step comes first picking, packing, posting goods issue ?
What is the use of the raising exception?
What is erp? : sap abap hr
What is an update task?
How can we create callable modules of program code within one abap/4 program? : abap modularization