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
What are the different window types in sapscript?
Have you set up a back ground job ? How to create a background job without a variant ?
How to call other programs?
What is meant by hide area?
What are the different attributes that can be assigned to a variant?
What is a persistent class?
What is a batch input session? : abap hr
Explain badi in abap.
There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.
In order to upload purchase order details, how you handle multiple values for a single field?
What is the name of the system variable that holds the contents of the selected line in interactive reporting?
Where the payroll results are stored
How do you delete duplicate records from internal table?
what precautions or prerequisites do you follow to update a record into database table and how
How is the command suppress-dialog useful?