What are Views, how they were useful. Types of Views
- 2 Answers
- 10889 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
What are the differences between table and structure in data dictionary?
Explain how do you move on to the next screen in interactive reporting?
what are Hana Basics
What are multiple use BADIS?
What is meant by search help? : sap abap data dictionary
Name some data dictionary objects?
How to write a code for multiple transactions? : abap bdc
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
How are the function code handles in flow logic?
pls if any one have idea ,reply as soon as possible 1.Allied solution group inc. is a genuine company or not ? 2.what is update module. 3.Transaction: scc3 what it is?
In a loop of an internal table, what is the use of at first & at last statements?
Some Realtime Objects on Bdc.
What is an Open Item in SAP? How will you find an Open Item in SAP?
What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary
What are spa/gpa parameters (sap memory)?
